Re: DB sizing... what if getting full?

From: Jerry Gitomer <jgitomer_at_hbsrx.com>
Date: Tue, 9 Nov 1999 12:53:11 -0500
Message-ID: <809niu$nfn$1@autumn.news.rcn.net>

Hi,

The first line of defense is:

ALTER DATABASE DATAFILE '<filename>' RESIZE xxxM;

                        or

        ALTER TABLESPACE <name> ADD DATAFILE '<filename>' SIZE

xxxM;

The second line of defense (used when you are out of disk space) is prayer.

hth
jerry gitomer

Valerie Swingler wrote in message
<382856CE.15B78BB3_at_intermetrics.com>...
>hello,
>
>What approaches would i take if the database (tablespace) is
nearing
>full and i do not want to lose any data in it. Can i extend it
>somehow? What init parameters specify this ability?
>
>any pojnts are appreciated,
>steve
>
Received on Tue Nov 09 1999 - 11:53:11 CST