Re: moving a database

Hm... sorry to bother again, but I'm not that familiar with Oracle.

When I executed the "alter database backup controlfile to trace"-command there was a trace-file generated with information about my datafiles. OK, now I can change the location of these files in this trace-file and move the datafiles physically.

Then what? How do I get my Oracle instance to use this new information from the tracefile?
Do I need to shut down Oracle?

By the way, it's an Oracle 8.1.5 on Windown NT 4.0.

Thanks in advance for any help.
/Håkan W

Mulderonline wrote:

> different choice:
> 1) easy : make link on file to old location
> 2) rename datafiles in controlfiles
> You have to backup controlfile to trace
> rename datafile in trace
> move files
> execute backup controlfile trace in svrmgrl
> 3) rename individualy datafiles:
> alter database rename datafile '/...' to '/...';
> ...
>
> "Håkan Wahlberg" <hakan.wahlberg_at_boliden.se> a écrit dans le message news:
> 38A42816.A7A90220_at_boliden.se...
> > How do I move a database (instance) with all its files from one disk to
> > another.
> > /Håkan W
> >
> >
Received on Mon Feb 14 2000 - 07:46:14 CST