Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: moving datafiles
muller.brenda_at_primestar.tci.com wrote:
>
> Hi,
>
> Can anyone tell me if there is a way to update the Oracle fixed tables
> to change the name of a datafile? I can't find the real underlying table
> where these names are kept, and even if I knew where it was, I
> wouldn't know how to update it directly.
>
> To clarify, let's say I want to move /oradata1/name01.dbf
> to /oradata01/name01.dbf
>
> I know I need to recreate the control files, but how can I update the
> system DDL?
>
> TIA,
>
> Brenda
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
Use ALTER DATABASE RENAME 'filename' TO 'filename';
This does not actually rename the file, it just tells Oracle what the new name is. The database must be mounted, but not open to do this.
-- James H. Yoshii Intellitech Business Solutions yoshii_at_planet.netReceived on Sat Feb 22 1997 - 00:00:00 CST