Re: How can I allocate database files to another hard disks

From: R.B <rich.bevan_at_bt.com>
Date: Tue, 9 Dec 2003 11:03:47 +0000 (UTC)
Message-ID: <br4a6i$qhr$1@visp.bt.co.uk>

"Ursula Lee" <ursula.lee_at_thales-is.com> wrote in message news:br45bj$htp21_at_imsp212.netvigator.com...
> Hi All,
>
> We are currently running out of disk space in our existing hard drives.
> The Oracle instances always take up to 100% of disk space usage. We
> are now ordering the extra 2 hard disks 18 G each (36 G total), is it
> possible to allocate those data files in the extra hard disks, but
> keeping the Oracle instance in the existing one?
>
> As I am not a DBA, any idea how to do that?
>
> One of the example in creating DB Files is:
>
> CREATE TABLESPACE "INDX" LOGGING DATAFILE
> '/bases/data/oradata/TKEDBMS//bdoracle/indx1_tkedbms.dbf' SIZE 25M REUSE
> AUTOEXTEND
> ON NEXT 1280K MAXSIZE UNLIMITED,
> '/opt/oracle/product/oracle9i/oradata/TKEDBMS/.dbf' SIZE 5M EXTENT
> MANAGEMENT LOCAL SEGMENT
> SPACE MANAGEMENT AUTO ;
>
> Appreciate your help!
> Ursula
>

Ursula,
If your tablespace is running out of space add a datafile to it on another disk with a modified version of the statment below:

SQL> alter tablespace tablespace_name add datafile '/path/to/datafile.dbf' size ??m;

change it for your own -
tablespace_name
'/path/to/datafile.dbf'
??m - this can be K,M etc

hope this helps Received on Tue Dec 09 2003 - 05:03:47 CST