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 -> How can I change the path to a datafile

How can I change the path to a datafile

From: Karl Hahn <hahnk_at_forwiss.tu-muenchen.de>
Date: Tue, 27 Jan 2004 14:25:15 +0100
Message-ID: <bv5ot6$1co09$1@sunsystem5.informatik.tu-muenchen.de> 





Hi,



I have inserted a datafile using



alter TABLESPACE XXXX add datafile '/path/to/oracle/oradata/mydb/x_blob5.dbf'
SIZE 1000M REUSE AUTOEXTEND ON NEXT 200M MAXSIZE 8000M


How can I change the path to this file in Oracle
(e.g., file has moved to /new/path/oradata/mydb/x_blob5.dbf)?
Where in the system tables is this information stored (Ora 8.1.7)?



Bye and thank you in advance,


Charlie
Received on Tue Jan 27 2004 - 07:25:15 CST












Original text of this message













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