importing to a different tablespace
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.