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

Thread: strange table names in 10g

  1. #1
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639

    strange table names in 10g

    Hi friends,

    I selected the tables/objects under my userid and i got
    strange table names appearing, where did this come from?
    the tables name that start with "BIN".

    Thanks a lot

    SQL> select object_name,object_type from user_objects;
    DERO_FILE SYNONYM
    DERO_FILE_TEMP SYNONYM
    DERO_FILE_HIST SYNONYM
    DERO_FILE_ALIAS SYNONYM
    DERO_OR_FILE SYNONYM
    LIFT_MASTER SYNONYM
    LIFT_OR_FILE SYNONYM
    ALLOW_MASTER SYNONYM
    ALLOW_OR_FILE SYNONYM
    CITIZENSHIP SYNONYM
    COUNTRY SYNONYM
    AGENCY SYNONYM
    D_PROVINCE SYNONYM
    D_CITY_MUN SYNONYM
    USERTAB SYNONYM
    TD_TYPE SYNONYM
    COMMON SYNONYM
    BRANCH SYNONYM
    DEPARTURE_ALL SYNONYM
    BIN$72xk+BJ5QFLgM8CoADZAUg==$0 TABLE
    ARRIVAL_ALL SYNONYM
    BIN$76XLQbdsQCLgM8CoADZAIg==$0 TABLE
    BIN$76XMrLaEMNTgM8CoADYw1A==$0 TABLE
    BIN$76XPxe1OEKDgM8CoADYQoA==$0 TABLE
    BIN$76ZkX/q7QOzgM8CoADZA7A==$0 TABLE
    BIN$76ZznGMakGzgM8CoADaQbA==$0 TABLE
    BIN$76Z45bP2oNrgM8CoADag2g==$0 TABLE
    BIN$76bVjLgukKjgM8CoADaQqA==$0 TABLE
    BIN$76c9127bQDLgM8CoADZAMg==$0 TABLE
    BIN$76c+k4uDIEDgM8CoADYgQA==$0 TABLE
    BIN$76c/9osxQD7gM8CoADZAPg==$0 TABLE
    BIN$76dzMkN30L7gM8CoADbQvg==$0 TABLE
    BIN$76dz7Hd2QDTgM8CoADZANA==$0 TABLE
    BIN$76d00GPdoDzgM8CoADagPA==$0 TABLE
    BIN$76dzMkN40L7gM8CoADbQvg==$0 TABLE
    BIN$76fGHvPkQD7gM8CoADZAPg==$0 TABLE
    BIN$76fUHTaWIFTgM8CoADYgVA==$0 TABLE
    BIN$76fXFcJPoGTgM8CoADagZA==$0 TABLE
    BIN$76hKwmUXoJDgM8CoADagkA==$0 TABLE
    BIN$76hKwmUWoJDgM8CoADagkA==$0 TABLE
    BIN$76hN5w2eQM7gM8CoADZAzg==$0 TABLE
    BIN$774aDllTsBjgM8CoADawGA==$0 TABLE
    BIN$77+48ftl0AjgM8CoADbQCA==$0 TABLE
    BIN$77+0ZenP4MDgM8CoADbgwA==$0 TABLE
    BIN$7/noYQ2m4J7gM8CoADbgng==$0 TABLE
    BIN$7/npH8UCAMTgM8CoADYAxA==$0 TABLE
    BIN$7/nsN4ZZEErgM8CoADYQSg==$0 TABLE
    BIN$7/oAHSO1AMjgM8CoADYAyA==$0 TABLE
    BIN$7/oCCAt1MKzgM8CoADYwrA==$0 TABLE
    BIN$7/otC73g8E7gM8CoADbwTg==$0 TABLE
    BIN$7/pMOdMb8FLgM8CoADbwUg==$0 TABLE
    TRAVELDB_LNK.WORLD DATABASE LINK

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    They're tables that were dropped and that are in the "recycle bin" -- see http://download-west.oracle.com/docs...htm#ADMIN01511
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

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