Re: Duplicate Tables with indexs

A couple of ways:

1. Run an export of the required schema with the "rows=n" option. The dump file produced will need a bit of manipulation but the required DDL will be in it.
2. Use DBMS_METADATA:

e.g.

set long 20000
connect XAL_<user>/<password>

SELECT DBMS_METADATA.GET_DDL('TABLE',u.table_name)

     FROM USER_TABLES u;

SELECT DBMS_METADATA.GET_DDL('INDEX',i.index_name)

     FROM USER_INDEXES i; Received on Wed Oct 19 2005 - 09:18:12 CDT