SQL & PL/SQL

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!

Generating DDL of table from synonym

557505Jul 13 2007 — edited Jul 17 2007

Hi All,

I have synonyms in one schema A, and the original corresponding tables of those synonyms is in other schema B. Both the schema's are in integration server and I have only command prompt mode to work with and I can log in to only Schema A.
I want to generate the DDL's of those tables in schema B using synonyms in schema A.

Is this possible ? If yes Please help.

I am using Oracle 9i.

Thanks
-AKJ

Message was edited by:
user554502

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 14 2007

Added on Jul 13 2007

3 comments

829 views