Home » SQL & PL/SQL » Client Tools » Generating Insert scripts for BLOB
Generating Insert scripts for BLOB [message #270546] Thu, 27 September 2007 08:19 Go to next message
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
Re: Generating Insert scripts for BLOB [message #270548 is a reply to message #270546] Thu, 27 September 2007 08:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
insert ... select ...

Regards
Michel
Re: Generating Insert scripts for BLOB [message #270554 is a reply to message #270548] Thu, 27 September 2007 08:32 Go to previous messageGo to next message
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!
Re: Generating Insert scripts for BLOB [message #270555 is a reply to message #270554] Thu, 27 September 2007 08:37 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Generating Insert scripts for BLOB [message #270558 is a reply to message #270554] Thu, 27 September 2007 08:44 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Would you deign to share the actual error you are getting?
Re: Generating Insert scripts for BLOB [message #270859 is a reply to message #270558] Fri, 28 September 2007 03:27 Go to previous messageGo to next message
hedonist123
Messages: 119
Registered: August 2007
Senior Member
Unable to generate insert scripts due to one or more nvarchar2 columns
Re: Generating Insert scripts for BLOB [message #270868 is a reply to message #270859] Fri, 28 September 2007 03:56 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Is there an error code attached to this error message?
Re: Generating Insert scripts for BLOB [message #270873 is a reply to message #270868] Fri, 28 September 2007 04:07 Go to previous messageGo to next message
hedonist123
Messages: 119
Registered: August 2007
Senior Member
No. It was generated when I used the export data tool using PL/SQl Developer
Re: Generating Insert scripts for BLOB [message #270885 is a reply to message #270546] Fri, 28 September 2007 04:43 Go to previous message
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.
Previous Topic: Can't INSERT INTO table
Next Topic: Procedural Option...???
Goto Forum:
  


Current Time: Fri Dec 02 20:53:22 CST 2016

Total time taken to generate the page: 0.22354 seconds