I have trouble with RECYCLE-BIN in 10g

From: <dominica_at_gmail.com>
Date: 7 Feb 2006 18:03:16 -0800
Message-ID: <1139362795.815142.220570@g47g2000cwa.googlegroups.com>

Hi Everyone,

I am running 10g on solaris 5.9.
I am doing some testing on my own test instance.

One thing I don't understand is I can't get the RECYCLE-BIN working.

I try to "test" drop a table and I look at the recycle-bin, I did not see anything .
How come??

The following is the "script" to capture what I did.

Thanks,

Dominica

---

Script started on Tue Feb 07 20:35:06 2006
$ sqlplus ddduser/

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Feb 7 20:35:15 2006

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Enter password:

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> select table_name from user_tables;

TABLE_NAME

---

TEST_TABLE1
TEST_TABLE2
TEST_TABLE3
TEST_TABLE4
TEST_TABLE5
TEST_TABLE6
TEST_TABLE7
TEST_TABLE8
TEST_TABLE9

9 rows selected.

SQL>
SQL> drop table TEST_TABLE9;

Table dropped.

SQL> select * from user_recyclebin;

no rows selected

SQL> show user;
USER is "DDDUSER"
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 -
64bit Production
With the Partitioning, OLAP and Data Mining options
$ exit

script done on Tue Feb 07 20:35:55 2006 Received on Tue Feb 07 2006 - 20:03:16 CST