My Oracle Support Banner

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 later
Information 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!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.