Script to get all the table definitions under one user name

[pando]

you could use dbms_metadata if you are using 9i

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