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: 65143
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: Different between ROLLBACK and COMMIT
Goto Forum:
  


Current Time: Sat Aug 19 06:27:56 CDT 2017

Total time taken to generate the page: 0.06324 seconds