Hi all,
We're currently trying to migrate our Oracle 12.1.0.1 database instance across from Server 2008 R2 to Server 2012 R2. However, when running: expdp DBA_USER/DBA_USER@DB.Company.Co.UK FULL=Y FILE=FULL.DMP LOGFILE=H:\Export.log, and then importing it using: impdp DB_USER/DB_USER@DB.Company.Co.UK FULL=Y FILE=F:\DB12101\FULL.DMP log=C:\test.log, I get a multitude of errors like:
ORA-39083: Object type TABLE:"MRK_TEST"."VFM_PROTOCOL" failed to create with error:
ORA-00959: tablespace 'MRK_TEST_D' does not exist
Failing sql is:
CREATE TABLE "MRK_TEST"."VFM_PROTOCOL" ("PROTOCOLID" NUMBER(9,0) NOT NULL ENABLE, "MACHINEID" NUMBER(5,0) NOT N
ULL ENABLE, "WORKFLOWREGEX" CLOB DEFAULT null, "PROTOCOLFILENAME" VARCHAR2(1000 CHAR) NOT NULL ENABLE, "ROWCREAT
EDDATE" DATE DEFAULT sysdate, "ROWUPDATEDDATE" DATE DEFAULT sysdate) PCTFREE 10 PCTUSED 40 INITRANS 5 MA
ORA-39083: Object type TABLE:"MRK_TEST"."INV_SEARCH_RESULT" failed to create with error:
ORA-00959: tablespace 'MRK_TEST_D' does not exist
Is there a way to export the tablespaces and import them so everything is created automatically? Or, do I need to create the tablespaces and roles, etc. manually before running the import?
The folder structure and set up on the new server is exactly the same as the old one, so there shouldn't be any issues in that regard.
Any help with this would be most appreciated!