SQL> select distinct segment_type from user_segments; SEGMENT_TYPE ----------------- INDEX TABLE SQL> select segment_name, segment_type, tablespace_name, bytes, extents from use r_segments; SEGMENT_NAME -------------------------------------------------------------------------------- SEGMENT_TYPE TABLESPACE_NAME BYTES EXTENTS ----------------- ------------------------------ ---------- ---------- DIALIN TABLE T01 41943040 8 DIALIN_TEMP TABLE T01 5242880 1 TACACS_USERS TABLE T01 1064960 1 SEGMENT_NAME -------------------------------------------------------------------------------- SEGMENT_TYPE TABLESPACE_NAME BYTES EXTENTS ----------------- ------------------------------ ---------- ---------- TACACS_SERVICE TABLE T01 1064960 1 TACACS_ROUTER TABLE T01 1064960 1 PLAN_TABLE TABLE USERS 40960 1 SEGMENT_NAME -------------------------------------------------------------------------------- SEGMENT_TYPE TABLESPACE_NAME BYTES EXTENTS ----------------- ------------------------------ ---------- ---------- TEST TABLE USERS 40960 1 D_PK INDEX I01 31457280 6 TU_PK INDEX I01 5242880 1 SEGMENT_NAME -------------------------------------------------------------------------------- SEGMENT_TYPE TABLESPACE_NAME BYTES EXTENTS ----------------- ------------------------------ ---------- ---------- TR_PK INDEX I01 5242880 1 TS_PK INDEX I01 5242880 1 D_01 INDEX I01 15728640 3 SEGMENT_NAME -------------------------------------------------------------------------------- SEGMENT_TYPE TABLESPACE_NAME BYTES EXTENTS ----------------- ------------------------------ ---------- ---------- D_02 INDEX I01 26214400 5 D_03 INDEX I01 10485760 2 14 rows selected. SQL>select * from usersegments; SEGMENT_NAME -------------------------------------------------------------------------------- SEGMENT_TYPE TABLESPACE_NAME BYTES BLOCKS ----------------- ------------------------------ ---------- ---------- EXTENTS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE ---------- -------------- ----------- ----------- ----------- ------------ FREELISTS FREELIST_GROUPS ---------- --------------- DIALIN TABLE T01 41943040 5120 8 5242880 5242880 1 505 0 1 1 SEGMENT_NAME -------------------------------------------------------------------------------- SEGMENT_TYPE TABLESPACE_NAME BYTES BLOCKS ----------------- ------------------------------ ---------- ---------- EXTENTS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE ---------- -------------- ----------- ----------- ----------- ------------ FREELISTS FREELIST_GROUPS ---------- --------------- DIALIN_TEMP TABLE T01 5242880 640 1 5242880 5242880 1 505 0 1 1 SEGMENT_NAME -------------------------------------------------------------------------------- SEGMENT_TYPE TABLESPACE_NAME BYTES BLOCKS ----------------- ------------------------------ ---------- ---------- EXTENTS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE ---------- -------------- ----------- ----------- ----------- ------------ FREELISTS FREELIST_GROUPS ---------- --------------- TACACS_USERS TABLE T01 1064960 130 1 1048576 1048576 1 505 0 1 1 SEGMENT_NAME -------------------------------------------------------------------------------- SEGMENT_TYPE TABLESPACE_NAME BYTES BLOCKS ----------------- ------------------------------ ---------- ---------- EXTENTS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE ---------- -------------- ----------- ----------- ----------- ------------ FREELISTS FREELIST_GROUPS ---------- --------------- TACACS_SERVICE TABLE T01 1064960 130 1 1048576 1048576 1 505 0 1 1 SEGMENT_NAME -------------------------------------------------------------------------------- SEGMENT_TYPE TABLESPACE_NAME BYTES BLOCKS ----------------- ------------------------------ ---------- ---------- EXTENTS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE ---------- -------------- ----------- ----------- ----------- ------------ FREELISTS FREELIST_GROUPS ---------- --------------- TACACS_ROUTER TABLE T01 1064960 130 1 1048576 1048576 1 505 0 1 1 SEGMENT_NAME -------------------------------------------------------------------------------- SEGMENT_TYPE TABLESPACE_NAME BYTES BLOCKS ----------------- ------------------------------ ---------- ---------- EXTENTS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE ---------- -------------- ----------- ----------- ----------- ------------ FREELISTS FREELIST_GROUPS ---------- --------------- PLAN_TABLE TABLE USERS 40960 5 1 40960 40960 1 505 50 1 1 SEGMENT_NAME -------------------------------------------------------------------------------- SEGMENT_TYPE TABLESPACE_NAME BYTES BLOCKS ----------------- ------------------------------ ---------- ---------- EXTENTS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE ---------- -------------- ----------- ----------- ----------- ------------ FREELISTS FREELIST_GROUPS ---------- --------------- D_PK INDEX I01 31457280 3840 6 5242880 5242880 1 505 0 1 1 SEGMENT_NAME -------------------------------------------------------------------------------- SEGMENT_TYPE TABLESPACE_NAME BYTES BLOCKS ----------------- ------------------------------ ---------- ---------- EXTENTS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE ---------- -------------- ----------- ----------- ----------- ------------ FREELISTS FREELIST_GROUPS ---------- --------------- TU_PK INDEX I01 5242880 640 1 5242880 5242880 1 505 0 1 1 SEGMENT_NAME -------------------------------------------------------------------------------- SEGMENT_TYPE TABLESPACE_NAME BYTES BLOCKS ----------------- ------------------------------ ---------- ---------- EXTENTS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE ---------- -------------- ----------- ----------- ----------- ------------ FREELISTS FREELIST_GROUPS ---------- --------------- TR_PK INDEX I01 5242880 640 1 5242880 5242880 1 505 0 1 1 SEGMENT_NAME -------------------------------------------------------------------------------- SEGMENT_TYPE TABLESPACE_NAME BYTES BLOCKS ----------------- ------------------------------ ---------- ---------- EXTENTS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE ---------- -------------- ----------- ----------- ----------- ------------ FREELISTS FREELIST_GROUPS ---------- --------------- TS_PK INDEX I01 5242880 640 1 5242880 5242880 1 505 0 1 1 SEGMENT_NAME -------------------------------------------------------------------------------- SEGMENT_TYPE TABLESPACE_NAME BYTES BLOCKS ----------------- ------------------------------ ---------- ---------- EXTENTS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE ---------- -------------- ----------- ----------- ----------- ------------ FREELISTS FREELIST_GROUPS ---------- --------------- D_01 INDEX I01 15728640 1920 3 5242880 5242880 1 505 0 1 1 SEGMENT_NAME -------------------------------------------------------------------------------- SEGMENT_TYPE TABLESPACE_NAME BYTES BLOCKS ----------------- ------------------------------ ---------- ---------- EXTENTS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE ---------- -------------- ----------- ----------- ----------- ------------ FREELISTS FREELIST_GROUPS ---------- --------------- D_02 INDEX I01 26214400 3200 5 5242880 5242880 1 505 0 1 1 SEGMENT_NAME -------------------------------------------------------------------------------- SEGMENT_TYPE TABLESPACE_NAME BYTES BLOCKS ----------------- ------------------------------ ---------- ---------- EXTENTS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE ---------- -------------- ----------- ----------- ----------- ------------ FREELISTS FREELIST_GROUPS ---------- --------------- D_03 INDEX I01 10485760 1280 2 5242880 5242880 1 505 0 1 1 13 rows selected. SQL> delete from dialn where to_char(stop_date), 'mmdd') = '0711'; 41 rows deleted. SQL> select * from user_segments where segment_name = 'dialin'; no rows selected SQL> select * from user_segments; SEGMENT_NAME -------------------------------------------------------------------------------- SEGMENT_TYPE TABLESPACE_NAME BYTES BLOCKS ----------------- ------------------------------ ---------- ---------- EXTENTS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE ---------- -------------- ----------- ----------- ----------- ------------ FREELISTS FREELIST_GROUPS ---------- --------------- DIALIN TABLE T01 41943040 5120 8 5242880 5242880 1 505 0 1 1 SEGMENT_NAME -------------------------------------------------------------------------------- SEGMENT_TYPE TABLESPACE_NAME BYTES BLOCKS ----------------- ------------------------------ ---------- ---------- EXTENTS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE ---------- -------------- ----------- ----------- ----------- ------------ FREELISTS FREELIST_GROUPS ---------- --------------- DIALIN_TEMP TABLE T01 5242880 640 1 5242880 5242880 1 505 0 1 1 SEGMENT_NAME -------------------------------------------------------------------------------- SEGMENT_TYPE TABLESPACE_NAME BYTES BLOCKS ----------------- ------------------------------ ---------- ---------- EXTENTS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE ---------- -------------- ----------- ----------- ----------- ------------ FREELISTS FREELIST_GROUPS ---------- --------------- TACACS_USERS TABLE T01 1064960 130 1 1048576 1048576 1 505 0 1 1 SEGMENT_NAME -------------------------------------------------------------------------------- SEGMENT_TYPE TABLESPACE_NAME BYTES BLOCKS ----------------- ------------------------------ ---------- ---------- EXTENTS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE ---------- -------------- ----------- ----------- ----------- ------------ FREELISTS FREELIST_GROUPS ---------- --------------- TACACS_SERVICE TABLE T01 1064960 130 1 1048576 1048576 1 505 0 1 1 SEGMENT_NAME -------------------------------------------------------------------------------- SEGMENT_TYPE TABLESPACE_NAME BYTES BLOCKS ----------------- ------------------------------ ---------- ---------- EXTENTS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE ---------- -------------- ----------- ----------- ----------- ------------ FREELISTS FREELIST_GROUPS ---------- --------------- TACACS_ROUTER TABLE T01 1064960 130 1 1048576 1048576 1 505 0 1 1 SEGMENT_NAME -------------------------------------------------------------------------------- SEGMENT_TYPE TABLESPACE_NAME BYTES BLOCKS ----------------- ------------------------------ ---------- ---------- EXTENTS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE ---------- -------------- ----------- ----------- ----------- ------------ FREELISTS FREELIST_GROUPS ---------- --------------- PLAN_TABLE TABLE USERS 40960 5 1 40960 40960 1 505 50 1 1 SEGMENT_NAME -------------------------------------------------------------------------------- SEGMENT_TYPE TABLESPACE_NAME BYTES BLOCKS ----------------- ------------------------------ ---------- ---------- EXTENTS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE ---------- -------------- ----------- ----------- ----------- ------------ FREELISTS FREELIST_GROUPS ---------- --------------- D_PK INDEX I01 31457280 3840 6 5242880 5242880 1 505 0 1 1 SEGMENT_NAME -------------------------------------------------------------------------------- SEGMENT_TYPE TABLESPACE_NAME BYTES BLOCKS ----------------- ------------------------------ ---------- ---------- EXTENTS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE ---------- -------------- ----------- ----------- ----------- ------------ FREELISTS FREELIST_GROUPS ---------- --------------- TU_PK INDEX I01 5242880 640 1 5242880 5242880 1 505 0 1 1 SEGMENT_NAME -------------------------------------------------------------------------------- SEGMENT_TYPE TABLESPACE_NAME BYTES BLOCKS ----------------- ------------------------------ ---------- ---------- EXTENTS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE ---------- -------------- ----------- ----------- ----------- ------------ FREELISTS FREELIST_GROUPS ---------- --------------- TR_PK INDEX I01 5242880 640 1 5242880 5242880 1 505 0 1 1 SEGMENT_NAME -------------------------------------------------------------------------------- SEGMENT_TYPE TABLESPACE_NAME BYTES BLOCKS ----------------- ------------------------------ ---------- ---------- EXTENTS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE ---------- -------------- ----------- ----------- ----------- ------------ FREELISTS FREELIST_GROUPS ---------- --------------- TS_PK INDEX I01 5242880 640 1 5242880 5242880 1 505 0 1 1 SEGMENT_NAME -------------------------------------------------------------------------------- SEGMENT_TYPE TABLESPACE_NAME BYTES BLOCKS ----------------- ------------------------------ ---------- ---------- EXTENTS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE ---------- -------------- ----------- ----------- ----------- ------------ FREELISTS FREELIST_GROUPS ---------- --------------- D_01 INDEX I01 15728640 1920 3 5242880 5242880 1 505 0 1 1 SEGMENT_NAME -------------------------------------------------------------------------------- SEGMENT_TYPE TABLESPACE_NAME BYTES BLOCKS ----------------- ------------------------------ ---------- ---------- EXTENTS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE ---------- -------------- ----------- ----------- ----------- ------------ FREELISTS FREELIST_GROUPS ---------- --------------- D_02 INDEX I01 26214400 3200 5 5242880 5242880 1 505 0 1 1 SEGMENT_NAME -------------------------------------------------------------------------------- SEGMENT_TYPE TABLESPACE_NAME BYTES BLOCKS ----------------- ------------------------------ ---------- ---------- EXTENTS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE ---------- -------------- ----------- ----------- ----------- ------------ FREELISTS FREELIST_GROUPS ---------- --------------- D_03 INDEX I01 10485760 1280 2 5242880 5242880 1 505 0 1 1 13 rows selected. SQL>