Errors IMP-3 ORA-959 While Importing Data Into Existing Table Of 11gR2 Using Traditional Import
Last updated on NOVEMBER 28, 2016
Applies to:Oracle Server - Enterprise Edition - Version 22.214.171.124 and later
Information in this document applies to any platform.
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:
("BIOMETRIC_ID" NUMBER(25, 0) NOT NULL ENABLE,
"CIVIL_NUMBER" NUMBER(14, 0) NOT NULL ENABLE,
"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.
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