Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Database export and "set define off"

914889Feb 2 2012 — edited Feb 2 2012
After upgrading to SQL Developer 3.1 EA 3 (from 3.0) I notices that the "Database Export" tool produces a "SET DEFINE OFF;" statement before each insert.

As far as I understand the statement is an SQLPlus command. When I then try to import the database using a different tool (e.g., with an Ant task) I get the following error "ORA-00922: missing or invalid option".

Is there a way to generate a DB export without SQLPlus specific commands?

Thanks

Matteo
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 1 2012
Added on Feb 2 2012
#error, #export, #sql-developer
2 comments
934 views