Thanks Kirti. I'll give that a go.
RC
> -Original Message-
> From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 17 October 2002 14:29
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Actual table size (Has been posted/discussed before)
>
You can try this:
REM == From Oracle-l posting
set echo off term on feed on pause off verify off
prompt Username to check space for:
col cobjuser noprint new_value uobjuser
set term off feed off
select upper('&1') cobjuser from dual;
set term on feed on
prompt Object to check space on ( for &
Hi All,
It has previously been discussed in this list regarding the actual size of a
table. Can someone re-post the SQL to get this?
I've got a table that has been ANALYZED. It has only 1 extent (INITIAL
50M). There's been a lot of deletes and insert on it. I wanted to know how
much of the 50M
