Re: What state... to rename datafile

From: Hermi <hs_at_technologist.com>
Date: Thu, 30 Nov 2000 01:10:54 +0100
Message-ID: <9045vb$s3u$05$1@news.t-online.com>

johna_at_digisys.net wrote:

> I thought I would bounce the datbase. ie do a shutdown
> (immediate) on the database, then open it to the "mounted"
> state.

alter tablespace dog index offline;
should do it.
then copy file with operating system to new location.

Now write the new location to your controlfile by typing your command:

> Then when I run the command "Alter tablespace dog index
> rename
> datafile1 to datafile2;

shure you will like then
alter tablespace dog index online;

and - if Bill Gates allows - delete the
old datafile. Sometimes it's still locked and you have to wait for the next reboot to be able to delete it. :-( Received on Wed Nov 29 2000 - 18:10:54 CST