Re: Zero Percent Free space

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Sun, 20 Jun 1999 04:19:13 GMT
Message-ID: <3775651d.46528394@netnews.worldnet.att.net>

On Fri, 18 Jun 1999 18:29:51 +0530, Anurag Minocha <anurag_at_synergy-infotech.com> wrote:

>My Rollback and system tablespace have zero percent free space . what
>should i do .how should i tacke this. I am a newbee so please help me
>out with this.

You can add space by adding datafiles. for example:

	alter tablespace system
		add datafile '/m01/oradata/orcl/system.dbf' 
		size 50m;

The above will add 50 meg to your system tablespace. To see where your database files are currently, issue the following:

	select file_name, tablespace_name, bytes
	from dba_data_files;

Hope this helps,

Jonathan

---

jonathan_at_gennick.com
http://gennick.com
Brighten the Corner Where You Are Received on Sat Jun 19 1999 - 23:19:13 CDT