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.
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:
Post a Comment