|
Oracle FAQ
|
Your Portal to the Oracle Knowledge Grid
|
Home ->
Community ->
Usenet ->
c.d.o.server ->
Re: Moving Oracle data files to a different hard disk
Re: Moving Oracle data files to a different hard disk
Moving datafiles is not really complicated. Here's how:
- Bring up your database.
- using SQL*Plus or Server Manager, Alter the tablespace associated
with the datafile you want to move, OFFLINE.
- copy the underlying datafile to the new location.
- issue ALTER TABLESPACE tablespace RENAME DATAFILE "old datafile" TO
"new name". (this changes the name in the control file).
- alter the tablespace online.
- delete the old datafile.
Received on Sun Sep 21 1997 - 00:00:00 CDT
Original text of this message
