Re: [External] Space explanation
- From: "Jeffrey Beckstrom" <jbeckstrom@xxxxxxxxx>
- To: "oracle-l-freelist" <oracle-l@xxxxxxxxxxxxx>,<veeeraman@xxxxxxxxx>
- Date: Tue, 05 May 2020 13:51:47 -0400
The insert caused the table to allocate storage. When the insert failed, the
rows were rolled back. However, the storage does not get released.
Ram Raman <veeeraman@xxxxxxxxx> 5/5/20 12:21 PM >>>
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
Other related posts:
- » Re: [External] Space explanation - Jeffrey Beckstrom