--- Paula_Stankus@xxxxxxxxxxxxxxx wrote: > Guys, > > I have a very recent export. I had to drop > corrupted > datafiles/tablesapces for indexes. > Isn't there an option in the import to just pull > indexes? yes. use the INDEXFILE option. That will create a file (that you specify the path for) that you can run to create the indexes. The table creation code will be commented out. imp help=y Aren't you glad that you had your tables and indexes separated by tablespace? Pd ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------