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!

Getting the DDL for all the tables in a Schema ;

645300Feb 4 2011 — edited Feb 4 2011

Hi,

I was trying to get DDL for all the tables under my own schema 'A'. Below are the steps i tried, but i was unsuccessful

 1. logged in as a user A 
2. And the ran query 
          
SELECT DBMS_METADATA.get_ddl ('TABLE', 'XYZ')
FROM user_tables
      
o/p
(HugecloB)

{code}

Any idea how i can get the DDL for all the tables under my own schema ?


Thank you so much!

Edited by: user642297 on Feb 4, 2011 12:05 PM

Edited by: user642297 on Feb 4, 2011 12:05 PM

Edited by: user642297 on Feb 4, 2011 12:05 PM

Edited by: user642297 on Feb 4, 2011 12:07 PM

This post has been answered by Nelson Calero on Feb 4 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 4 2011

Added on Feb 4 2011

#general-database-discussions

8 comments

30,597 views