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!

How to export a schema.

504217Aug 24 2006 — edited Sep 7 2006

Hi guys!

How do I use SQL Developer to export a schema?

I kind of hoped, that I would end up with a file containing a complete setup-script for the schema. This way I would be able to use SQL*Plus to create an empty version of the schema on another server.

Whenever I use Tools -> Export I get a blank file or, if I'm lucky, I get a file containing only my sequences and my packages. But no CREATE TABLE... :-( Even if I've checked "tables" in the tree.

Is this kind of export at all possible with SQL Developer? Or am I doing this all wrong?

SQL Developer version: 1.0.0.14.57
OS: Windows XP Professional SP2
Java version: 1.5.0_05
Oracle IDE: 1.0.0

Best regards.
Soeren Lauritsen

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 5 2006

Added on Aug 24 2006

#sql-developer

15 comments

3,263 views