Importing partitioned tables and indexes into another database
I am copying metadata of our 3.5T oracle 9i production database into a development database which is 1% of production.
the three schemas I am copying have about 2000 partitioned tables and indexes and import has failed on tablespace names.
I created an indexfile which has 29000 rows. Editing this file and changing the tablespace names, extent sizes etc., undoubtly is a very painful task and may take along time. Importing one or two tables by editing is ok. But editing 2000 tables each has a definition of 100 lines or more is cumbersome to say the least.
Is there any other smart solution?