IBM Support

Oracle database schema to schema import command impdp fails when restoring database to new location

Troubleshooting


Problem

​Customers who need to move their Oracle™ database to a new location might encounter import errors with the schema to schema impdp command during database restore operation due to table spaces not existing.

Symptom

SQL failure errors similar to as follows might occur:

Processing object type DATABASE_EXPORT/SCHEMA/USER
ORA-39083: Object type USER:"CONFIG" failed to create with error: ORA-00959: tablespace 'RIS_TEMP' does not exist Failing sql is: CREATE USER "CONFIG" IDENTIFIED BY VALUES '6927AD6126C5EDB6' DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "RIS_TEMP" PASSWORD EXPIRE ACCOUNT LOCK

ORA-39083: Object type USER:"RIODS" failed to create with error: ORA-00959: tablespace 'RIS_TEMP' does not exist Failing sql is: CREATE USER "RIODS" IDENTIFIED BY VALUES 'EDA2AD77A7B97EC7' DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "RIS_TEMP" PASSWORD EXPIRE ACCOUNT LOCK

ORA-39083: Object type USER:"RIDW" failed to create with error: ORA-00959: tablespace 'RIS_TEMP' does not exist Failing sql is: CREATE USER "RIDW" IDENTIFIED BY VALUES 'A9FFF3AFEB2C5AB9' DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "RIS_TEMP" PASSWORD EXPIRE ACCOUNT LOCK

ORA-39083: Object type USER:"RIASSET" failed to create with error: ORA-00959: tablespace 'RIS_TEMP' does not exist Failing sql is: CREATE USER "RIASSET" IDENTIFIED BY VALUES '8D9AEDCDC452CD6E' DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "RIS_TEMP" PASSWORD EXPIRE ACCOUNT LOCK

ORA-39083: Object type USER:"RISCHK" failed to create with error: ORA-00959: tablespace 'RIS_TEMP' does not exist Failing sql is: CREATE USER "RISCHK" IDENTIFIED BY VALUES '4E9D65B260D41388' DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "RIS_TEMP" PASSWORD EXPIRE ACCOUNT LOCK

ORA-39083: Object type USER:"RICALM" failed to create with error: ORA-00959: tablespace 'RIS_TEMP' does not exist Failing sql is: CREATE USER "RICALM" IDENTIFIED BY VALUES '0E25A26491AF10B9' DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "RIS_TEMP" PASSWORD EXPIRE ACCOUNT LOCK

Document Location

Worldwide

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSPRJQ","label":"IBM Engineering Lifecycle Management Base"},"Component":"Database","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
28 April 2021

UID

ibm15737179

Page Feedback