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

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 09 Nov 1999 17:50:19 +0800
Message-ID: <3827EE5B.4766@yahoo.com>

Valerie Swingler wrote:
>
> 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

select file_name
from dba_data_files
where tablespace_name = 'XXX';

to get the file(s) for this tablespace

alter database datafile '...' resize 1000m;

to make the file larger (1000m is the total size, not the amount you are increasing by)

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Tue Nov 09 1999 - 03:50:19 CST