Joined: 31-July 05
Member No.: 2,629
Hi David, As far as i know INDEXFILE option would only give DDLs for Indexes but it improves importing by not creating indexes at that time. Please correct me if i am wrong.
I think here the need is a script (shell or perl) that can extract the DDL for all db components from the imp log.
Please see metalink ID Note:123720.1 if it's useful.(If you have access to metalink). Here they give a perl script which extracts ddl for tblspaces,rollback,tables,user schema ddls. Please test it for any errors and also if any db components are missed out for 9i.