DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: weird table names..Help

Threaded View

  1. #1
    Join Date
    Jan 2008
    Posts
    45

    weird table names..Help

    hey guys

    i wanted to find the objects present in the 4 dataspaces and i run the following query....

    SELECT OWNER,TABLESPACE_NAME, SEGMENT_NAME,SEGMENT_TYPE,round(sum(bytes)/1024/1024) USED
    FROM DBA_SEGMENTS
    WHERE OWNER='HQAUAT1'
    AND (TABLESPACE_NAME='LETTER_DATA'
    OR TABLESPACE_NAME='LETTER_INDEX'
    OR TABLESPACE_NAME='USERS'
    OR TABLESPACE_NAME='MAX2_INDEX_S_TS')
    GROUP BY OWNER,TABLESPACE_NAME,SEGMENT_NAME,SEGMENT_TYPE
    ORDER BY SEGMENT_NAME;

    Now the problem is with the output .....
    i am getting weird object names....
    owner tablespace_name segment_name segmen_type space_used
    HQAUAT1 LETTER_INDEX BIN$R+eo/M1NZbvgRAAXpHb+mQ==$0 INDEX 1
    HQAUAT1 LETTER_DATA BIN$R+eo/M1OZbvgRAAXpHb+mQ==$0 TABLE 1
    HQAUAT1 LETTER_INDEX BIN$R+eo/M1QZbvgRAAXpHb+mQ==$0 INDEX 1

    Now my question is what is these present under segment name... as they r not the object names present in the database......

    Can someone help me with it?

    Thanks
    Last edited by chaitanyagoa; 06-12-2008 at 11:52 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width