Home » RDBMS Server » Server Administration » copy tablespace from Oracle
copy tablespace from Oracle [message #286454] Fri, 07 December 2007 08:31 Go to next message
majstoru
Messages: 68
Registered: October 2006
Location: Serbia
Member
Hi,

I found some pdf's about how to copy database from one to another server and how to create a new instance to a new server and transfer old data.

I have a small newbie question, if I use TS2007.DBF like my data tablespace and TEMP.DBF like temp tablespace, can I transfer ony TS2007.DBF file to a new server with same installation of Oracle?

Thanks. Embarassed

Report message to a moderator

Re: copy tablespace from Oracle [message #286456 is a reply to message #286454] Fri, 07 December 2007 08:35 Go to previous messageGo to next message
Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can transfer the whole database, you cannot tranfer only a file to plug it into another database.
It is possible to do this for a (set of) tablespace through transportable tablespace method.

Regards
Michel

Report message to a moderator

Re: copy tablespace from Oracle [message #286458 is a reply to message #286454] Fri, 07 December 2007 08:39 Go to previous message
majstoru
Messages: 68
Registered: October 2006
Location: Serbia
Member
Thanks Michael!

Report message to a moderator

Previous Topic: migration from one server to another
Next Topic: interim patch 5854190 failing
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 14:17:38 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.