Re: System datafile, moving.

hi,

1. shutdown your database
2. move the file using mv command
3. mount the database (not open)
4. rename datafile using alter database datafile rename '/old_dir/system.dbf' to '/new_dir/system.dbf'
5. open database (alter database open)
6. backup database / take a control file trace

HTH NeilC
"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:32 CST