OraFAQ Forum: Client Tools » Generating Insert scripts for BLOB

Home » Other » Client Tools » Generating Insert scripts for BLOB

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Generating Insert scripts for BLOB [message #270546]

Thu, 27 September 2007 08:19

hedonist123
Messages: 119
Registered: August 2007

Senior Member

Hi,

I wish to move the data in one table with nvarchar2 columns to another table with nvarchar2 columns.

However, I am not able to generate inserts for a table with nvarchar2 columns using PL/SQL developer.

Could someone suggest a workaround?

Thanks

Report message to a moderator

Re: Generating Insert scripts for BLOB [message #270548 is a reply to message #270546]

Thu, 27 September 2007 08:23

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

insert ... select ...

Regards
Michel

Report message to a moderator

Re: Generating Insert scripts for BLOB [message #270554 is a reply to message #270548]

Thu, 27 September 2007 08:32

hedonist123
Messages: 119
Registered: August 2007

Senior Member

Thanks for the reply.

But it doesnt work.

I am moving the data from an oracle database to a db2 database.

Please help!

Report message to a moderator

Re: Generating Insert scripts for BLOB [message #270555 is a reply to message #270554]

Thu, 27 September 2007 08:37

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

I am moving the data from an oracle database to a db2 database

And of course this was a little detail that does not worth to indicate in the first post. Mad

Regards
Michel

Report message to a moderator

Re: Generating Insert scripts for BLOB [message #270558 is a reply to message #270554]

Thu, 27 September 2007 08:44

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

Would you deign to share the actual error you are getting?

Report message to a moderator

Re: Generating Insert scripts for BLOB [message #270859 is a reply to message #270558]

Fri, 28 September 2007 03:27

hedonist123
Messages: 119
Registered: August 2007

Senior Member

Unable to generate insert scripts due to one or more nvarchar2 columns

Report message to a moderator

Re: Generating Insert scripts for BLOB [message #270868 is a reply to message #270859]

Fri, 28 September 2007 03:56

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

Is there an error code attached to this error message?

Report message to a moderator

Re: Generating Insert scripts for BLOB [message #270873 is a reply to message #270868]

Fri, 28 September 2007 04:07

hedonist123
Messages: 119
Registered: August 2007

Senior Member

No. It was generated when I used the export data tool using PL/SQl Developer

Report message to a moderator

Re: Generating Insert scripts for BLOB [message #270885 is a reply to message #270546]

Fri, 28 September 2007 04:43

scorpio_biker
Messages: 154
Registered: November 2005
Location: Kent, England

Senior Member

From this post in the Allround Automations forum it appears you couldn't do this in certain versions of PL/SQL Developer
Forum Post

If you want to use PL/SQL Developer you will have to contact the company or post to the forum to see if they have fixed this yet.

Otherwise you'll have to use another method of exporting the data.

Report message to a moderator

Previous Topic:	Can't INSERT INTO table
Next Topic:	Procedural Option...???

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 18 08:44:12 CST 2025