Re: Moving Database files

Hi Don,
Piece of cake...you can easily do that.
To move database files:
1) BACKUP!!! 2) Take the tablespace that contains
the datafile off-line from SQL*DBA
ALTER TABLESPACE tablespace_name OFFLINE NORMAL;

3) Copy the datafiles to the new location using your native operating system commands.

4) From SQL*DBA do
ALTER TABLESPACE tablespace_name
RENAME DATAFILE 'old_filename' TO 'new_filename';

5) Bring back the table space online by
ALTER TABLESPACE tablespace_name ONLINE;

If your hard disk is full and want to expand into the new drive, create additional datafiles on the new drive.

ALTER TABLESPACE tablespace_name
ADD DATAFILE 'new_filename' SIZE #M;

Thew new_filename you specified resides on the new hard disk.

But, my suggestion is that you look up
Oracle Server Administrator's guide to get a good understanding of what you are doing.

Good Luck,
  Kittu.

Don Parente (dparente_at_notes.cc.bellcore.com) wrote:
: My hard disk drive is full and I added another. Oracle 7.1 is install on the full drive and I
: need to expand my database. Can I expand into the new drive and How????
 

: Thanks
 

: Don
: dparente_at_notes.cc.bellcore.com
Received on Fri Aug 09 1996 - 00:00:00 CEST