Script to get all the table definitions under one user name
Does anyone know a script to get all the table definition of one schema in once?
You might be able to use the
fromuser and touser
options of import to get what you want.
OCP DBA 8i, 9i, 10g
you could use dbms_metadata if you are using 9i
select dbms_metadata.get_ddl('TABLE', table_name) from user_tables
The easiest is probably to export the user, ROWS=N, then generate an indexfile using import. (With the right editor, you don't even need the import step.)
I have an old script to dump a user (it goes back to V6), but the above is cleaner and more consistent.
Joseph R.P. Maloney, CSP,CDP,CCP
'The answer is 42'
Click Here to Expand Forum to Full Width