Re: How to create a DDL for a schema

Don't top-post please, people don't like it :)

Anyway, a bit of lateral thinking produces:

select dbms_metadata.get_ddl('TABLE',table_name,'<schema_name>') from all_tables
where owner='<schema_name>';

And:

select dbms_metadata.get_ddl('INDEX',index_name,'<schema_name>') from all_indexes
where owner='<schema_name>';

Run as SYSTEM rather than SYS.

HTH

• g