Re: What state... to rename datafile

Well...I'm not sure and I don't have the option to test it, but AFAIK when your database is in mounted stage and not opened, then the instance does not know anything about tablespaces. You have to use "alter datafile 1 rename" or something similar.

HTH,
Juhan

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.
 

-- 
+-----------------+
|NB! Please remove|
|   .NICHT-SPAM   |
|  when replying  |
|    to get my    |
|     *REAL*      |
| e-mail address! |
|                 |
|  Cheers, Juhan  |
+-----------------+