Re: Refreshing test d/base

Are you using 9i or greater? In that case, you can do something like:

set pagesize 0
set long 99999
select dbms_metadata.get_ddl('TABLE', table_name) from user_all_tables;

select dbms_metadata.get_ddl('FUNCTION', object_name) from user_objects where object_type = 'FUNCTION';

...etc. Received on Thu Apr 14 2005 - 13:49:10 CDT