weird table names..Help
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: weird table names..Help

  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.

  2. #2
    Join Date
    Mar 2000
    Location
    Atlanta, GA,USA
    Posts
    155
    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

  3. #3
    Join Date
    Jan 2008
    Posts
    45

    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

  4. #4
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,470

    Talking 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

  5. #5
    Join Date
    Jan 2008
    Posts
    45
    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

  6. #6
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,470

    Cool

    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

  7. #7
    Join Date
    Apr 2007
    Location
    USA
    Posts
    110
    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.

  8. #8
    Join Date
    Jan 2008
    Posts
    45
    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.

  9. #9
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,470

    Exclamation

    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

  10. #10
    Join Date
    Jan 2008
    Posts
    45

    Smile 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
  •  



Click Here to Expand Forum to Full Width