Home » RDBMS Server » Server Administration » Transportable tablespace
Transportable tablespace [message #226764] Mon, 26 March 2007 08:34 Go to next message
caprikar
Messages: 226
Registered: March 2007
Senior Member
Hi,
I have two servers both are oracle 10g with ASM running on RedHat Linux and I want to use transportable tablespace to transfer one tablespace from database say DB1 to DB2. Can anyone tell me the steps involved? is it necessary that I must use RMAN to do this?
Thanks,
GK
Re: Transportable tablespace [message #226773 is a reply to message #226764] Mon, 26 March 2007 08:58 Go to previous messageGo to next message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14231/tspaces.htm#sthref1281
Re: Transportable tablespace [message #226774 is a reply to message #226764] Mon, 26 March 2007 08:58 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

No Message Body

[Updated on: Mon, 26 March 2007 09:17]

Report message to a moderator

Re: Transportable tablespace [message #226777 is a reply to message #226764] Mon, 26 March 2007 09:04 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In "Database Administrator's Guide", Chapter 8 "Managing Tablespaces", section Transporting Tablespaces Between Databases: A Procedureand Example, it is said:

If either the source or destination is an Automatic Storage Management (ASM) disk group, you can use:

  • ftp to or from the /sys/asm virtual folder in the XML DB repository.
  • The DBMS_FILE_TRANSFER package
  • RMAN


Regards
Michel
Re: Transportable tablespace [message #226779 is a reply to message #226773] Mon, 26 March 2007 09:06 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
thapush,

Your link is misleading.
It belongs to normal file system and not ASM.

Regards
Michel
Re: Transportable tablespace [message #226784 is a reply to message #226779] Mon, 26 March 2007 09:17 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Thnx Michel for pointing that out
Removed.. Smile

[Updated on: Mon, 26 March 2007 09:17]

Report message to a moderator

Re: Transportable tablespace [message #226790 is a reply to message #226784] Mon, 26 March 2007 09:27 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You should not, it can be useful with just the note it is not for ASM.

Regards
Michel
Re: Transportable tablespace [message #226840 is a reply to message #226764] Mon, 26 March 2007 14:13 Go to previous messageGo to next message
caprikar
Messages: 226
Registered: March 2007
Senior Member
Is there any note available to use transportable tablespace in ASM ?
-GK
Re: Transportable tablespace [message #226846 is a reply to message #226840] Mon, 26 March 2007 14:38 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Did you already read the link I pointed and the links pointed by the link I pointed and the whole chapter?
If yes, I think you have your answer.

Regards
Michel
Previous Topic: Datapump Error
Next Topic: Installing Database
Goto Forum:
  


Current Time: Sat Dec 10 03:33:33 CST 2016

Total time taken to generate the page: 0.10013 seconds