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
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: 64102
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
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!
Previous Topic: migration from one server to another
Next Topic: interim patch 5854190 failing
Goto Forum:
  


Current Time: Fri Dec 02 23:10:14 CST 2016

Total time taken to generate the page: 0.07838 seconds