Script to get all the table definitions under one user name

[lgaorcl]

Does anyone know a script to get all the table definition of one schema in once?

Thanks!

Lisa

[dknight]

You might be able to use the

fromuser and touser

options of import to get what you want.

[pando]

you could use dbms_metadata if you are using 9i

select dbms_metadata.get_ddl('TABLE', table_name) from user_tables

[jrpm]

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.