Use RAID. Oracle has much information on configuration in their
manuals.
The fact that you have to shut down Oracle to move datafiles is
bullshit. As long as its not system. Forward this to your "dba"
(excerpt from Oracle):
- Determine how many datafiles are associated with the tablespace.
SVRMGR> SELECT FILE_NAME, STATUS FROM DBA_DATA_FILES
WHERE TABLESPACE_NAME = '<YOUR_TABLESPACE_NAME>';
- Alter the tablespace offline.
SVRMGR> ALTER TABLESPACE <YOUR_TABLESPACE_NAME> OFFLINE;
- Copy the datafiles associated with the tablespace determined by
step 1 using normal operating system commands (cp or cpio for UNIX
etc.)
- Once the tablespace is offline you will need to rename the
datafile(s) to the new location. This updates the entry for the
datafile(s) in the controlfile.
SVRMGR> ALTER DATABASE RENAME
FILE'/FULL_PATH_OF_OLD_LOCATION/AND_DATAFILE_NAME.DBF'
TO
'/FULL_PATH_OF_NEW_LOCATION/AND_DATAFILE_NAME.DBF'; * You will
need to do this for all datafiles associated with
this tablespace.
- Once the alter database statement has been processed for the
datafile(s) you can bring the tablespace online.
SVRMGR> ALTER TABLESPACE YOUR_TABLESPACE_NAME ONLINE;
Received on Fri Nov 07 2003 - 14:28:19 CST