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
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?
Last edited by chaitanyagoa; 06-12-2008 at 11:52 AM.