ORA-00959: tablespace 'TABSPACE1' does not exist

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 ??

Solution:-

If you specify ignore=y in your import the table will get created in the schema's default tablespace.
 Just make sure that the default tablespace is the one that you want to use.
Otherwise create the table the way you want in the proper tablespace then import with ignore=y.

No comments:

ORA-00059: Maximum Number Of DB_FILES Exceeded in 19C database

When I am adding datafile to my 19C database facing the below error. SQL> alter tablespace DATA  add datafile '/u01/data/data15.dbf...