-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|