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
Hey,

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

Report message to a moderator

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: 68767
Registered: March 2007
Location: Saint-Maur, France, https...
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.

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Aug 23 17:14:57 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.