The documentation for the imp utility states that although there are no parameters to change the tablespace from the export to the import, you can coerce the utility to place things in a particular tablespace by making that the only available tablespace. I am trying to import a database across hosts. I have a user qc with a default (and no other) tablespace user_00. I get to a certain point in the import:
IMP-00017: following statement failed with ORACLE error 1950:
"CREATE TABLE "QC_ERROR_RATE" ("QC_ERROR_RATE_ID" NUMBER(12, 0) NOT NULL ENA"
"BLE, "QC_SEQ_LIBRARY_ID" NUMBER(12, 0) NOT NULL ENABLE, "PLATE_ERROR_RATE" "
"FLOAT(126) NOT NULL ENABLE, "WELL_ERROR_RATE" FLOAT(126) NOT NULL ENABLE, ""
"SAMPLE_SIZE" NUMBER(12, 0) NOT NULL ENABLE, "DATE_CREATED" DATE NOT NULL EN"
"ABLE, "CONFIDENCE_INTERVAL_HIGHE
R" FLOAT(126), "CONFIDENCE_INTERVAL_LOWER
" "
"FLOAT(126), "WELLS_FAILED" NUMBER(12, 0), "WELLS_COMPARED" NUMBER(12, 0), ""
"DETAILS" CLOB, "PLATES_FAILED" NUMBER(12, 0), "TOTAL_PLATES" NUMBER(12, 0))"
" PCTFREE 0 PCTUSED 99 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELI"
"STS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" LOGGING NOC"
"OMPRESS LOB ("DETAILS") STORE AS (TABLESPACE "USERS" ENABLE STORAGE IN ROW"
" CHUNK 8192 PCTVERSION 10 NOCACHE STORAGE(INITIAL 65536 FREELISTS 1 FREELI"
"ST GROUPS 1 BUFFER_POOL DEFAULT))"
IMP-00003: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'USERS'
It seems to me that if the tablespace is called out in the SQL, I need to have those tablespaces enabled. Is this a reasonable conclusion?
Start Free Trial
