importing tablespaces only
575300Aug 2 2007 — edited Aug 2 2007I am trying to import data into a differenet DB, I want to import only the tablespace and also set the errors=0
DIRECTORY=DATA_PUMP_DIR
DUMPFILE=EXPDAT.DMP
TABLESPACES= POSITION, RESUME, SKILLSET_POSITION, SKILLSET_RESUME
Errors=0
I have been getting this error can anyone help me out here thank you in advance
Connected to: Oracle Database 10g Release 10.2.0.1.0 - Production
Master table "SYSMAN"."SYS_IMPORT_TABLESPACE_01" successfully loaded/unloaded
Starting "SYSMAN"."SYS_IMPORT_TABLESPACE_01": sysman/******** directory=data_pump_dir dumpfile=expdat.dmp Tablespaces= Position resume skillset_position Skillset_resume
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE
ORA-39083: Object type TABLE failed to create with error:
ORA-01918: user 'POSITION' does not exist
Failing sql is:
CREATE TABLE "POSITION"."POSITION" ("POSITIONID" NUMBER(20,0) NOT NULL ENABLE, "TITLE" NVARCHAR2(255), "SKILLSETID" NUMBER(20,0), "TASKSETID" NUMBER(20,0), "FILLEDBYRESUMEID" NUMBER(20,0), "FILLEDONDATE" NVARCHAR2(40), "DESCRIPTION" NVARCHAR2(700), "TOTALFORCEINTEGRATEDMETRIC" NVARCHAR2(255)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS NOLOGGING STORAGE(INITIAL 65536 NEXT 104857
ORA-39083: Object type TABLE failed to create with error:
ORA-01918: user 'POSITION' does not exist
Failing sql is:
CREATE TABLE "POSITION"."FINANCIAL" ("POSITIONID" NUMBER(20,0) NOT NULL ENABLE, "ID" NUMBER(20,0) NOT NULL ENABLE, "TYPE" NVARCHAR2(255), "TITLE" NVARCHAR2(255), "VALUE" NVARCHAR2(255), "CODE" NVARCHAR2(255), "STARTDATE" NVARCHAR2(40), "ENDDATE" NVARCHAR2(40), "NOTE" NVARCHAR2(700)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS NOLOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTEN
ORA-39083: Object type TABLE failed to create with error:
ORA-01918: user 'POSITION' does not exist
Failing sql is:
CREATE TABLE "POSITION"."JOB" ("POSITIONID" NUMBER(20,0) NOT NULL ENABLE, "JOBID" NUMBER(20,0) NOT NULL ENABLE, "TITLE" NVARCHAR2(255), "CODE" NVARCHAR2(255), "FAMILY" NVARCHAR2(255)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS NOLOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPA
ORA-39083: Object type TABLE failed to create with error:
ORA-01918: user 'POSITION' does not exist
Failing sql is:
CREATE TABLE "POSITION"."MISSIONTASK" ("POSITIONID" NUMBER(20,0) NOT NULL ENABLE, "ID" NUMBER(20,0) NOT NULL ENABLE, "TYPE" NVARCHAR2(255), "VALUE" NVARCHAR2(255), "CODE" NVARCHAR2(255), "STARTDATE" NVARCHAR2(40), "ENDDATE" NVARCHAR2(40)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS NOLOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREE
ORA-39083: Object type TABLE failed to create with error:
ORA-01918: user 'POSITION' does not exist
Failing sql is:
CREATE TABLE "POSITION"."WORKER" ("POSITIONID" NUMBER(20,0) NOT NULL ENABLE, "ID" NUMBER(20,0) NOT NULL ENABLE, "TYPE" NVARCHAR2(255), "VALUE" NVARCHAR2(255), "CODE" NVARCHAR2(255)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS NOLOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE
ORA-39083: Object type TABLE failed to create with error:
ORA-01918: user 'POSITION' does not exist
Failing sql is:
CREATE TABLE "POSITION"."WORKPLACE" ("POSITIONID" NUMBER(20,0) NOT NULL ENABLE, "WORKPLACEID" NUMBER(20,0) NOT NULL ENABLE, "TYPE" NVARCHAR2(255), "VALUE" NVARCHAR2(255), "CODE" NVARCHAR2(255)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS NOLOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT
ORA-39083: Object type TABLE failed to create with error:
ORA-01918: user 'POSITION' does not exist
Failing sql is:
CREATE TABLE "RESUME"."TEST1" ("PROCESS_ORDER" NUMBER, "DUPLICATE" NUMBER, "DUMP_FILEID" NUMBER, "DUMP_POSITION" NUMBER, "DUMP_LENGTH" NUMBER, "DUMP_ALLOCATION" NUMBER, "COMPLETED_ROWS" NUMBER, "ERROR_COUNT" NUMBER, "ELAPSED_TIME" NUMBER, "OBJECT_TYPE_PATH" VARCHAR2(200), "OBJECT_PATH_SEQNO" NUMBER, "OBJECT_TYPE" VARCHAR2(30), "IN_PROGRESS" CHAR(1), "OBJECT_NAME" VARCHAR2(500), "OBJECT_LONG_NA
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX
ORA-39112: Dependent object type INDEX:"POSITION"."POSITION_INDEX" skipped, base object type TABLE:"POSITION"."POSITION" creation failed
ORA-39112: Dependent object type INDEX:"POSITION"."FINANCIAL_INDEX" skipped, base object type TABLE:"POSITION"."FINANCIAL" creation failed
ORA-39112: Dependent object type INDEX:"POSITION"."JOB_INDEX" skipped, base object type TABLE:"POSITION"."JOB" creation failed
ORA-39112: Dependent object type INDEX:"POSITION"."MISSIONTASK_INDEX" skipped, base object type TABLE:"POSITION"."MISSIONTASK" creation failed
ORA-39112: Dependent object type INDEX:"POSITION"."WORKER_INDEX" skipped, base object type TABLE:"POSITION"."WORKER" creation failed.