Export Specifies Wrong Tablespace For Partitioned Table That Has Been Moved
(Doc ID 271046.1)
Last updated on OCTOBER 11, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 9.2.0.4 and laterInformation in this document applies to any platform.
Symptoms
Following error is seen during import:
Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production
Export file created by EXPORT:V09.02.00 via conventional path
import done in WE8ISO8859P1 character set and US7ASCII NCHAR character set
importing <SCHEMA_NAME>'s objects into <SCHEMA_NAME>
IMP-00017: following statement failed with ORACLE error 959:
"CREATE TABLE "TEST_TAB" ("COL1" NUMBER) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXT"
"RANS 255 TABLESPACE "<TBS_NAME1>" LOGGING PARTITION BY RANGE ("Col1" ) (PARTITION "
""P_OVERFLOW" VALUES LESS THAN (MAXVALUE) PCTFREE 10 PCTUSED 40 INITRANS 1 "
"MAXTRANS 255 STORAGE(INITIAL 163840 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 214"
"7483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TA"
"BLESPACE "<TBS_NAME>" LOGGING NOCOMPRESS )"
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'USERS2' does not exist
Import terminated successfully with warnings.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |