I have to import Prod data into Tes instance. The Prod .dmp file comes up to almost 700MB.
I do my import using imp system/password file=x.dmp fromuser=userprod touser=usertest grants=y indexes=y
All the data is imported into data TableSpace (TS). I would have to resize to data TS to accomodate both data, and index.
I have to run a script to move index files from data TS to index TS.
The data TS would then have a lot of space without data and I could not resize it to smaller size as to use diskspace more efficiently.
Is there a way, where I can do imports where the tables goes into data TS and indexes would go to index TS.