Sql for Table Creation
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Sql for Table Creation

  1. #1
    Join Date
    Aug 2002

    Sql for Table Creation


    how do we get the SQL for creating all the tables whihc are in one of my schema;

    i saw a post relating to this matter and Pando had given a nice answer but now i cannot find it. If anyone knows that post pls help

    Success Consists of Getting Up Just One More Time Than You've Fallen Down
    Be Blessed

  2. #2
    Join Date
    Sep 2002
    You can use TOAD or some other third party tool that generates the create table SQL for you.

    You also can do some fine PL/SQL programming where you use the user_tables, user_tab_columns, user_constriant, etc. to generate these script.

    I hope this is helpful

  3. #3
    Join Date
    Jan 2002
    Up s**t creek
    If your using 9i you can also use DBMS_METADATA

    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  4. #4
    Join Date
    Aug 2002
    Colorado Springs
    if you are just interested in tables, and maybe indexes, then export will do that in any version of Oracle. Extract the definitions from the dump file using import with the indexfile option
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width