Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> moving datafiles
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 UsenetReceived on Fri Feb 21 1997 - 00:00:00 CST