Database DataWarehousing (MOSC)

MOSC Banner

Rename datafiles in TRANSPORABLE TABLESPACES

edited Oct 2, 2012 8:26PM in Database DataWarehousing (MOSC) 2 commentsAnswered
Can not rename files from Transportable Tablespace Set
Problem Description
---------------------------------------------------
Source database has file names of the form '+DATA_DG/olddb/datafile/* on old server, target datafiles are '+DGRAC/newdb/datafile/* on new server. I copied the files to new server to the new ASM location on the new server. Then exported the metadata for all tablespaces. When doing the import of the metadata on the new database/server the impdp utility complains that it can not find the files. Which of course makes sense. How do I rename the files on either the expdp or impdp ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center