Skip to Main Content

Oracle Database Discussions

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!

Export Database

806937Oct 29 2010 — edited Oct 29 2010
Hi,
I have a test DB and need to export my DB. I access all the data from synonyms and not from tables. I am using SQL Developer tool. When i try to use the Export option from SQL Developer tool, it only gets me the DDL of the synonym and not actual data. I tried expdp option from sql editor, unfortunately, i don't have access to create new directory.

One way, i was able to get data was, searching for objects from object viewer within SQL Developer tool, but i have to do individually all the synonyms and also for DB structure.

Please advice me how to accomplish this task without getting individual synonyms and get entire DB at a time.

Thanks in advance.

Regards.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 26 2010
Added on Oct 29 2010
3 comments
102 views