Results 1 to 2 of 2

Thread: Unwanted Tables

  1. #1
    Join Date
    Jan 2005
    Posts
    1

    Unanswered: Unwanted Tables

    Hi, I'm a new registrant; I teach database with Oracle at a university.

    In a new installation of Oracle 10g, I am accumulating some strange tables, for some reason.
    OBJECT_NAME OBJECT_TYPE CREATED
    -------------------------------- ----------- ----------
    BIN$7YAqGRevGTjgNAADuoQz5Q==$0 TABLE 01/11/2005
    BIN$7eVyNWwLRxzgNAADuoQz5Q==$0 TABLE 01/17/2005
    BIN$7eY2hanLR1ngNAADuoQz5Q==$0 TABLE 01/17/2005
    BIN$7eY2hanMR1ngNAADuoQz5Q==$0 TABLE 01/17/2005
    BIN$7eY2hanNR1ngNAADuoQz5Q==$0 TABLE 01/17/2005

    DESC BIN$7YAqGRevGTjgNAADuoQz5Q==$0
    brings an error message.
    I have been using SQL*Loader so that is probably causing them, but I don't know how to get rid of them.
    Can someone suggest what I need to do?

    Many thanks,

    Bruce

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    Oracle 10g has a recycle bin as windows explorer does
    dig a little deeper into the documentation and either switch it off or set the retention period to a value you like

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •