Hi there,

Starting with Oracle 10gR1, you're suplied with a recycle bin, which
prevents you from losing data if you dropped some table by mistake.

For example, if you issue:
SQL> drop table t1;

The table is not dropped, but instead goes to the recycle bin (the table
is now named BIN#something). You can "undo" the drop command using
SQL> flashback table t1 to before drop;

You can also purge you recycle bin using
SQL>purge recyclebin;

And you can drop some table permanently using
SQL>drop table t1 purge;

Hope this helps,

Juliano
> Hi all,
>
> I just want to know if anyone knows where did this BIN$ table came from?
> Is it 'coz I ran the EXPLAIN PLAN scripts and ran EXPLAIN PLAN?
>
>
> ===================================================================================================================
>
> [Email Address Removed] sqlplus scott/[Email Address Removed] SQL*Plus: Release 10.1.0.2.0 - Production on Thu Jan 5 12:18:19 2006
>
> Copyright (c) 1982, 2004, Oracle. All rights reserved.
>
>
> Connected to:
> Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
> With the Partitioning, OLAP and Data Mining options
>
> SQL> select table_name from dba_tables;
> select table_name from dba_tables
> *
> ERROR at line 1:
> ORA-00942: table or view does not exist
>
>
> SQL> select table_name from user_tables;
>
> TABLE_NAME
> ------------------------------
> PLAN_TABLE
> EMP1
> SALGRADE
> BONUS
> BIN$BySV8aUEUrLgQBisDOADmA==$0
> DEPT
>
> 6 rows selected.
>
> SQL>
>
> ===================================================================================================================
>
>
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>



Oracle LazyDBA home page