You have to create the tables and indexes to your test instance before importing the .dmp file. In creating the the tables and indexes to your new instance, specify the tablespaces for the table and indexes.
Note : create the same index name of the orignal table and put ignore=y during import.




Reply With Quote