Database Administration (MOSC)

MOSC Banner

ALL_TABLES and RECYCLEBIN

edited Jun 20, 2013 9:49PM in Database Administration (MOSC) 7 commentsAnswered ✓
When a table is dropped and goes to recyclebin it is supposed to be still visible in ALL_TABLES view. I have 11.2.0.3. Can someone explain me the below:

SQL> show recyclebin
SQL> show user
USER is "TABLIS"
SQL> create table testtest (test1 number(1));

Table created.

SQL> select table_name from user_tables;

TABLE_NAME
------------------------------
TESTTEST

SQL> drop table testtest;

Table dropped.

SQL> show recyclebin;
ORIGINAL NAME    RECYCLEBIN NAME                OBJECT TYPE  DROP TIME
---------------- ------------------------------ ------------ ----------

TESTTEST         BIN$t2kXXZKoQNmDSOz3Ug+zEw==$0 TABLE        2013-06-21

SQL> select table_name from user_tables;

no rows selected

Thanking you in advance

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center