Re: oracle 9i problems.. renaming datafiles

"Howard J. Rogers" wrote because I wrote:

> > AFAIK you can't rename the file when the database is open. Shutdown the
> > instance, startup mount, rename the file (on OS level *and* in the
> database) and
> > open the db.

> Of course you can. Taking the tablespace offline is like shutting down part
> of the database, so the procedure is: take tablespace offline, drop to the
> O/S and do the necessaries, issue the 'alter database datafile rename x to
> y' command to tell the controlfile what you've been up to, bring the
> tablespace back on line.
>
> The only time this doesn't work, of course, is when it's the SYSTEM datafile
> that's being renamed, since you can't offline the system tablespace. If
> that's the case, then your shutdown-rename-mount-tell controlfile-open
> method is the only way of doing it.

Thanks for clearing it up, Howard. I was a bit confused with system vs. other tablespaces.

Regards,

Knut Received on Thu Jun 20 2002 - 04:58:44 CDT