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
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
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!
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
Click Here to Expand Forum to Full Width