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 -> moving datafiles

moving datafiles

From: <muller.brenda_at_primestar.tci.com>
Date: 1997/02/21
Message-ID: <856556482.24815@dejanews.com>#1/1

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
Received on Fri Feb 21 1997 - 00:00:00 CST

Original text of this message

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