Home » RDBMS Server » Backup & Recovery » Move the datafile to another database (Oracle 9.1.0 Window server 2003)
Move the datafile to another database [message #366366] Sat, 13 December 2008 01:42 Go to next message
azhar masood
Messages: 15
Registered: September 2008
Location: Pakistan
Junior Member

I have two databases(dummy and actual) with different SID , I want to copy a datafile from One database to paste with another database,For this what i have to do?(means in which files i have to edit etc). What about renaming the datafile?

Best Regards

Azhar Masood
Re: Move the datafile to another database [message #366370 is a reply to message #366366] Sat, 13 December 2008 01:52 Go to previous message
Michel Cadot
Messages: 63923
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to either copy tablespace (not datafile) using transportable tablespace feature or export/import the objects that are in the datafile/tablespace.

Previous Topic: ORA-19554: error allocating device, device type: SBT_TAPE, device name:
Next Topic: create a database from offline backup
Goto Forum:

Current Time: Tue Oct 25 21:27:02 CDT 2016

Total time taken to generate the page: 0.06825 seconds