Hi guys,

I specifically exported a large partitioned table. The tablespace it was in is TABSPACE1, which also contains many more large tables

When I import into another instance, which does not have the tablespace TABSPACE1, I get the error message

IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'TABSPACE1' does not exist
Import terminated successfully with warnings.

This is fair enough, but is there a way of forcing the import into another tablespace ??

I don't particularly want to create a new tablespace, and I don't want to transport the whole TABSPACE1 tablespace.

Your thoughts would be appreciated.