-
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.
-
Your database has recycle bin feature active. These are names Oracle asign to dropped objects.
Do "show parameter recyclebin" in SQL*Plus and see it for yourself.
Sergey
-
thanks sergey
Now how do i proceed about it .....
i don not want that objects when i run the query......
can you guide me through it?
Thanks
-
PURGE'em
PURGE RECYCLEBIN;
-- or --
PURGE DBA_RECYCLEBIN;
-- and --
ALTER SYSTEM SET RECYCLEBIN=OFF;
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
-
THanks LKBrwn,
that was quick....
but i think u have to have the sysdba privalages to run this purge command, which i unfortunately dont :(
anyways thank you so much
-
You can still use the PURGE on your schema.
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
-
if you did not have dba privs, how did you access dba_segments in your query above?
Looking for the greatest evil in the world? Look in the mirror.
-
hey
To LKBrwn
i have used the following commmand but it doesnt work:
sql> purge tablespace tablespace_name;
SP2-0734: unknown command beginning "purge tabl..." - rest of line ignored.
i have no idea why this is happening?
Tuma:
i donot have the sysdba privilages. They created a user with some kind of privilages and gave it to me.
-
Take a moment to read the fine Oracle SQL reference manual on this subject.
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
-
hey DBA
thanks for that document ....
that was helpful
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
|