|
-
There is one package called "DBMS_METADATA" Under that package u can use method "get_ddl".This method gives back the script of the table u have given as a parameter to it.Use this thing in connection with user_tables.This method gives scripts with all constraints and all grants.Spool it to some file and then just change the name of tables in file manually.I think this should solve your problem.
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
|