Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Full Database Export/Import - Create Tablespaces, Roles, etc.

Titan1617Feb 28 2018 — edited Mar 1 2018

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!

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 29 2018
Added on Feb 28 2018
10 comments
884 views