Errors IMP-3 ORA-959 While Importing Data Into Existing Table Of 11gR2 Using Traditional Import

(Doc ID 1180873.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version 11.2.0.1 and later
Information 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.

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