| Shifting Databases [message #303561] |
Fri, 29 February 2008 14:59  |
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
|
Senior Member |
|
|
Hi,
I have to move the database of one branch of the company to another. One branch has expired its oracle license and does not want to renew it as they do not have much work now. I have LAN access to the target computer different city.
One DBA friend of mine told that I can just copy the systems files from this site to the target computer in the same location and create a service of the same name and the database will be up and running without any loss of any objects and data.
Is this possible?
Is there any other way to do this?
- Das
|
|
|
|
| Re: Shifting Databases [message #303563 is a reply to message #303561] |
Fri, 29 February 2008 15:17  |
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
|
Senior Member |
|
|
It is possible, if it's the *exact* same oracle version.
On the running source database run an
alter system backup controlfile to trace;
You should then have a SQL - Script in the user trace directory which can be used to re-create the database on the target system after the files are copied and the service is created.
You can also adjust the database name and the paths of the data files in that script.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
