Why does this table not show up in USER_SEGMENTS or DBA_SEGMENTS
scatmullAug 11 2009 — edited Aug 12 2009Any idea why there is no entry in either USER_SEGMENTS or DBA_SEGMENTS for this object? The object is just missing from those views...
CREATE TABLE CR_CASE_TEST
(
CASE_ID VARCHAR2(10) NOT NULL,
ADD_DT DATE NOT NULL,
PRIMARY KEY
(CASE_ID)
)
ORGANIZATION INDEX
select * from user_segments where segment_name like 'CR%'
Database: 10.2.0.4 (on AIX) and 10.2.0.4 on Windows
Is it because the segment is stored under the name of the index and not the name of the table? I ask because if I put in "CONSTRAINT CR_CASE_TEST$PK" then I get the row for the named constraint.