Re: System datafile, moving.

Sorry, just answering myself here, but would backing up the controlfile to trace, shutting down the instance, copying the system file to a new location, editing the controlfile to reflect the changes and then re-starting the instance?

"s. hunter" wrote:

> Hi,
>
> This is something which I've never had to do before, but I migrated a
> database from 7.3.3 to 8.0.5 last year. I didn't delete 7.3.3
> $ORACLE_HOME because there were other databases using that version of
> oracle.
>
> I now DO want to get rid of it, but my system.dbf file is still in the
> 7.3.3 $ORACLE_HOME/dbs (oops!). Could someone please tell me the
> easiest way to move it to the 8.0.5 ORACLE_HOME?
>
> Thanks!
>
> Sarah
Received on Mon Jan 10 2000 - 07:56:03 CST