Database Administration (MOSC)

MOSC Banner

Map spatial index table to base table?

edited Sep 17, 2015 7:19AM in Database Administration (MOSC) 1 commentAnswered

I've got a segment that has grown unexpectedly large.  One segment has 7086 extents in the a single data file. 

Select owner, segment_name, sum(1)
  From dba_extents
Where file_id=202
   And segment_name=’SYS_LOB0022735055C00002$$’
Group by owner, segment_name;

OWNER  SEGMENT_NAME  SUM(1)
proj1  SYS_LOB0022735055C00002$$ 7086

Select table_name, column_name
  From dba_lobs
Where owner=’proj1’
   and segment_name=’SYS_LOB0022735055C00002$$’;

TABLE_NAME  COLUMN_NAME
MDXT_46D32F$BKTS  MBRCOORDS

I know the segment and table are part of a spatial index.  But, how do I find out what data table they apply to?  (This database has thousands of tables with spatial columns.  I can’t just browse for it.)

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center