Depends on the size of your database. If it small enough you can use
export/import. If it is huge you'll save a lot of time by restoring a cold
backup from the old system on the new system and recreating the control
file. steps to follow
1. Alter database backup controlfile to trace.
2. take cold backup
3. restore on the new system and modify file names if necessary
4. create new initsid file on the new system.
5. modify the trace file from step1 to reflect changes in file names and
change the database name if desired
6. startup mount with the new initsid
7. from server manager run the trace file to create the control file
Venkat
> I am planning to move an oracle database to a different
>ORACLE_HOME on a different system. What is the best way.
>I am planning to do an export of the database and then on the other
>system, just create a new database withe same name. Is this the easiest
>way to go about this???
>
>thanks in advance for any help here
Received on Fri May 08 1998 - 15:05:31 CDT
