OraFAQ Forum: Server Administration » Transportable tablespace

Home » RDBMS Server » Server Administration » Transportable tablespace

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Transportable tablespace [message #226764]

Mon, 26 March 2007 08:34

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

Report message to a moderator

Re: Transportable tablespace [message #226773 is a reply to message #226764]

Mon, 26 March 2007 08:58

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14231/tspaces.htm#sthref1281

Report message to a moderator

Re: Transportable tablespace [message #226774 is a reply to message #226764]

Mon, 26 March 2007 08:58

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

Michel Cadot
Messages: 68686
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

Report message to a moderator

Re: Transportable tablespace [message #226779 is a reply to message #226773]

Mon, 26 March 2007 09:06

Michel Cadot
Messages: 68686
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

Report message to a moderator

Re: Transportable tablespace [message #226784 is a reply to message #226779]

Mon, 26 March 2007 09:17

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

Michel Cadot
Messages: 68686
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

Report message to a moderator

Re: Transportable tablespace [message #226840 is a reply to message #226764]

Mon, 26 March 2007 14:13

caprikar
Messages: 226
Registered: March 2007

Senior Member

Is there any note available to use transportable tablespace in ASM ?
-GK

Report message to a moderator

Re: Transportable tablespace [message #226846 is a reply to message #226840]

Mon, 26 March 2007 14:38

Michel Cadot
Messages: 68686
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

Report message to a moderator

Previous Topic:	Datapump Error
Next Topic:	Installing Database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 03:40:54 CDT 2024