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
    Posts
    176

    Sql for Table Creation

    hi

    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

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

  2. #2
    Join Date
    Sep 2002
    Posts
    9
    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
    Location
    Up s**t creek
    Posts
    1,525
    If your using 9i you can also use DBMS_METADATA

    Regards
    Jim
    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
    Location
    Colorado Springs
    Posts
    5,253
    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