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.

Was this topic helpful?

Document Information

More support for:
IBM Engineering Lifecycle Management Base

Software version:
All Versions

Document number:
5737179

Modified date:
28 April 2021

UID

ibm15737179

IBM Support

Tips