Last updated on NOVEMBER 28, 2016
Applies to:
Oracle Server - Enterprise Edition - Version 11.2.0.1 and laterInformation in this document applies to any platform.
Symptoms
On 11gR2, a user imports a table with the parameter IGNORE=Y. No errors are reported during import. If the user drops the tablespace, then imports the table with the parameter IGNORE=Y, then the user may hit the error ORA-00959 even-though table was pre-created in the target database:
"CREATE TABLE "BIOMETRIC"
("BIOMETRIC_ID" NUMBER(25, 0) NOT NULL ENABLE,
"CIVIL_NUMBER" NUMBER(14, 0) NOT NULL ENABLE,
"HIRES_PHOTO" BLOB,
"CAPTURE_DATE" DATE) PCTFREE 10 PCTUSED
40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 243269632
FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "NRSDB_EXT" LOGGING
NOCOMPRESS LOB ("HIRES_PHOTO") STORE AS
(TABLESPACE "NRSDB_EXT" ENABLE STORAGE IN ROW
CHUNK 8192 PCTVERSION 10 NOCACHE LOGGING STORAGE"
"(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT))"
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'NRSDB_EXT' does not exist
Import terminated successfully with warnings.
("BIOMETRIC_ID" NUMBER(25, 0) NOT NULL ENABLE,
"CIVIL_NUMBER" NUMBER(14, 0) NOT NULL ENABLE,
"HIRES_PHOTO" BLOB,
"CAPTURE_DATE" DATE) PCTFREE 10 PCTUSED
40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 243269632
FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "NRSDB_EXT" LOGGING
NOCOMPRESS LOB ("HIRES_PHOTO") STORE AS
(TABLESPACE "NRSDB_EXT" ENABLE STORAGE IN ROW
CHUNK 8192 PCTVERSION 10 NOCACHE LOGGING STORAGE"
"(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT))"
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'NRSDB_EXT' does not exist
Import terminated successfully with warnings.
Cause
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 hundreds of Community platforms