Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Renaming datafiles on 7.1/OpenVMS
Did you rename the files in Oracle or only at the OS level? The alter
database command includes a syntax for renaming files as does the alter
tablespace command. Both of these commands will update the control file as
necessary.
I have used the alter database command to take files offline so Oracle
would start clean and then used other commands like alter and create
tablespace to fix the damage. That would be the approach that I would
take. You could get Oracle to dump the control file to text, modify it
with the new filenames, and re-create the control file, but I do not
recommend this approach unless you have trouble trying the other method.
James Petts <jpetts_at_celltech.co.uk> wrote in article
<3641c64e.186169327_at_firewall.celltech>...
> I had a disk go bad, and had to replace it with another. The name of
> the new disk is different from the original. I have renamed the
> datafiles using the appropriate syntax.
>
> Do I need to do anything to the controlfiles?
>
> James
>
Received on Thu Nov 05 1998 - 13:20:27 CST