-
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
-
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
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!
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|