Re: What state... to rename datafile

In our last gripping episode johna_at_digisys.net wrote:
> Hello,
>
> We are using Oracle8i on NT4, and need to rename a datafile.
>
> I thought I would bounce the datbase. ie do a shutdown (immediate) on
> the database, then open it to the "mounted" state.
>
> Then when I run the command "Alter tablespace dog_index rename
> datafile1 to datafile2; I get errors.
>
> This doesn't seem to work though, any ideas why??
>
> Thanks,
>
> John
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Since you don't report what errors you are receiving it is difficult to assess the problem, although I suspect that you are getting 'file not found' or 'cannot read from file' errors. Simply renaming a datafile in Oracle does not move the file at the O/S level. You started off correctly, up to and including the ALTER TABLESPACE command. At this point you should then physically move the datafile from its original location to the new location (and name, if that is changing as well) at the O/S level, then open the database. You should have no errors at that point, presuming the file move occurred without error.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.