Home » RDBMS Server » Server Utilities » Change File Locations while Transport Tablespace (Oracle 10.2.0.4.0 on Linux)
Change File Locations while Transport Tablespace [message #416476] Mon, 03 August 2009 01:20 Go to next message
OraKaran
Messages: 183
Registered: March 2008
Location: United Kingdom
Senior Member
Hi,

Is it possible to change the file locations dynamically while doing transportable tablespace?
This is required while transporting tablespace from one database to another on the same host

Thanks and Regards,
OraKaran
Re: Change File Locations while Transport Tablespace [message #416482 is a reply to message #416476] Mon, 03 August 2009 01:40 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Backup and Recovery Advanced User's Guide
Chapter 14 Creating Transportable Tablespace Sets from Backup with RMAN
Section Customize Other Auxiliary File Locations in TRANSPORT TABLESPACE

Regards
Michel
Re: Change File Locations while Transport Tablespace [message #416496 is a reply to message #416476] Mon, 03 August 2009 02:07 Go to previous messageGo to next message
OraKaran
Messages: 183
Registered: March 2008
Location: United Kingdom
Senior Member
Michel,

Thanks for quick reply

The link is quite useful but using RMAN has it's constraints as mentioned in the document.

I would like to know if, while we import(impdp) the metadata in destination database during TTS, can be use something like remap_datafile/ db_file_name_convert so that the datafiles can be created at different location(after physically copying to that location for destination database)

Regards,
OraKaran
Re: Change File Locations while Transport Tablespace [message #416506 is a reply to message #416496] Mon, 03 August 2009 02:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As your question is posted in "Backup & Recovery" forum, I assume you use RMAN.
If the question is about DataPump it should be
1/ Post in "Server Utilities" as clearly mentioned in forum list
2/ Post it clearly in your question.
Then it will save both your and our time.

Regards
Michel
Re: Change File Locations while Transport Tablespace using Data Pump [message #416509 is a reply to message #416476] Mon, 03 August 2009 02:58 Go to previous messageGo to next message
OraKaran
Messages: 183
Registered: March 2008
Location: United Kingdom
Senior Member
Sorry Michel.

But since this is alredy moved to 'Server Utilities' forum, Could you please suggest on the same?

Regards,
OraKaran
Re: Change File Locations while Transport Tablespace using Data Pump [message #416565 is a reply to message #416509] Mon, 03 August 2009 05:47 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/dp_export.htm#sthref73
Previous Topic: SQLLDR Carriage Return
Next Topic: Convert the Swedish Database to English
Goto Forum:
  


Current Time: Sun Dec 04 10:15:15 CST 2016

Total time taken to generate the page: 0.07654 seconds