Re: Space explanation
Date: Tue, 05 May 2020 14:26:40 -0400
Message-ID: <eface1e6f5917d8100e832231c4dc39578116877.camel_at_gmail.com>
Delete or rollback do not free space. There are ways to free space: *
truncate
> Hi
>
> I created a table for testing and inserting rows into it when the
> insert process failed as the tablespace reached maximum limit of 32G
> - that happened couple of days ago. However, there are no rows in the
> table, but space occupied shows as real high with the tablespace
> itself full. Does anyone have an idea? There are couple of other
> tables in the tablespace but they occupy just few 100 blocks. 12c
>
> 1 select table_name, NUM_ROWS, last_analyzed, blocks from
> dba_tables
> 2* where table_name = upper('wvce')
> 11:14:17 SQL> /
>
> TABLE_NAME NUM_ROWS LAST_ANAL BLOCKS
> ------------------------ -------------------- --------- ----------
> WVCE 0 03-MAY-20 3444463
>
> Elapsed: 00:00:00.09
> 11:14:17 SQL>
> 11:14:28 SQL> select count(*) from WVCE ;
>
> COUNT(*)
> --------------------
> 0
>
> Elapsed: 00:00:00.00
> 11:14:35 SQL>
> --
>
> Thanks
> Ram
--
Mladen GogalaDatabase ConsultantTel: (347) 321-1217Email:gogala.mladen_at_gmail.com
-- http://www.freelists.org/webpage/oracle-lReceived on Tue May 05 2020 - 20:26:40 CEST