Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: moving datafiles

Re: moving datafiles

From: Jim Yoshii <yoshii_at_planet.net>
Date: 1997/02/22
Message-ID: <330F25C9.126B@planet.net>#1/1

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.net
Received on Sat Feb 22 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US