From page 9-11 of the Oracle 8 Server Administrator's Guide
- Identify the datafile names of interest
select file_name, bytes from sys.dba_data_files where
tablespace_name = '.....';
- Back up the database (or be confident that you have a good, recent
backup)
- Shut down the database and restart and mount it, leaving the database
closed
in server manager
shutdown
startup mount
- Copy the datafile(s) to their new locations using operating system
commands
in Unix: cp sourcepathfilename destpathfilename
- Rename the file(s) in Oracle
alter database rename datafile 'old path and filename' to 'new path
and filename';
- Shutdown and restart the database
in server manager
shutdown abort
startup
Terry <tmaguire_at_iiu.nospam.ie> wrote in message
news:80ujc7$e8e$1_at_ezekiel.eunet.ie...
>
>
> Hi all
>
> Sorry, but bit of a newbie question here:
>
> Due to disk space problems it is required to move some of our datafiles to
> new disks. I tried the following using 'Storage Manager' but failed:
>
> 1. Take the tablespace where the datafiles are located offline (Normal
> offline)
> 2. Copy the datafiles to the new disk
> 3. Try to change the path location of the datafile
>
> All I achieved were Oracle errors telling me that it could not locate the
> datafile with the new path location. I am presuming there is some process
in
> place to achieve this but unfortunately I haven't had the chance to go on
a
> Oracle DBA course to learn this info, and won't have the time in the
> foreseeable future.
>
> Any help would be gratefully appreciated.
>
> Terry Maguire
> IIU
> IFSC House
> Custom House Quay
> Dublin 1
> Ireland
>
>
>
>
Received on Wed Nov 17 1999 - 12:43:04 CST
