system 有flashback any table 权限
SQL> connect system/oracle;
Connected.
SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod
PL/SQL Release 10.1.0.2.0 - Production
CORE    10.1.0.2.0      Production
TNS for Linux: Version 10.1.0.2.0 - Production
NLSRTL Version 10.1.0.2.0 - Production

SQL> create table ss (id number);

Table created.

SQL> drop table ss;

Table dropped.

SQL>  SELECT object_name as recycle_name, original_name
  2  from USER_RECYCLEBIN;

no rows selected

why?

[zhangleyi@as zhangleyi]$ sqlplus "scott/tiger"

SQL*Plus: Release 10.1.0.2.0 - Production on Wed Mar 17 20:31:27 2004

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 tabs;

TABLE_NAME
------------------------------
BIGEMP
T_TEST
PLAN_TABLE
SALGRADE
BONUS
EMP
DEPT

7 rows selected.

SQL> select count(*) from t_test;

  COUNT(*)
----------
         0

SQL> drop table t_test;

Table dropped.

SQL> show RECYCLEBIN
ORIGINAL NAME    RECYCLEBIN NAME                OBJECT TYPE  DROP TIME
---------------- ------------------------------ ------------ -------------------
T_TEST           BIN$1eFPkRbDw3fgMAB/AQAxTg==$0 TABLE        2004-03-17:20:31:54

SQL> SELECT object_name as recycle_name, original_name
  2  from USER_RECYCLEBIN;

RECYCLE_NAME                   ORIGINAL_NAME
------------------------------ --------------------------------
BIN$1eFPkRbDw3fgMAB/AQAxTg==$0 T_TEST

SQL> column parameter for a30
SQL> column value for a20
SQL> select * from v$option where parameter like 'Flashback%';

PARAMETER                      VALUE
------------------------------ --------------------
Flashback Table                TRUE
Flashback Database             TRUE

SQL> show parameter  compatible   

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
compatible                           string      10.1.0.2.0

[oracle@redhatadv2 oracle]$ uniread sqlplus scott/tiger
[uniread] Loaded history (265 lines)

SQL*Plus: Release 10.1.0.2.0 - Production on Wed Mar 17 23:32:49 2004

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> create table ss as select * from dual;

Table created.

SQL> select table_name from user_tables;

TABLE_NAME
------------------------------
SS
SALGRADE
BONUS
EMP
DEPT

SQL> select count(*) from ss;

  COUNT(*)
----------
         1

SQL> drop table ss;

Table dropped.

SQL> show recyclebin
ORIGINAL NAME    RECYCLEBIN NAME                OBJECT TYPE  DROP TIME
---------------- ------------------------------ ------------ -------------------
SS               BIN$1dYrO3fJP7HgMAB/AQAYdQ==$0 TABLE        2004-03-17:23:34:20

SQL> select object_name,original_name from user_recyclebin;

OBJECT_NAME                    ORIGINAL_NAME
------------------------------ --------------------------------
BIN$1dYrO3fJP7HgMAB/AQAYdQ==$0 SS

SQL> select * from v$option where parameter like 'Flashback%';

PARAMETER                       VALUE
------------------------------ --------------------
Flashback Table                   TRUE
Flashback Database                TRUE

SQL> show parameter compatible

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
compatible                           string      10.1.0.2.0

SQL> select * from session_privs;

PRIVILEGE
----------------------------------------
CREATE SESSION
ALTER SESSION
UNLIMITED TABLESPACE
CREATE TABLE
CREATE CLUSTER
CREATE SYNONYM
CREATE VIEW
CREATE SEQUENCE
CREATE DATABASE LINK
CREATE PROCEDURE
CREATE TRIGGER

PRIVILEGE
----------------------------------------
CREATE TYPE
CREATE OPERATOR
CREATE INDEXTYPE

14 rows selected.
SQL> connect system/oracle
Connected.

SQL> create table ss as select * from dual;

Table created.

SQL> drop table ss;

Table dropped.

SQL> show recyclebin
SQL>  select object_name,original_name from user_recyclebin;

no rows selected


SQL> select * from session_privs;

PRIVILEGE
----------------------------------------
ALTER SYSTEM
AUDIT SYSTEM
CREATE SESSION
ALTER SESSION
RESTRICTED SESSION
CREATE TABLESPACE
ALTER TABLESPACE
MANAGE TABLESPACE
DROP TABLESPACE
UNLIMITED TABLESPACE
CREATE USER

PRIVILEGE
----------------------------------------
BECOME USER
ALTER USER
DROP USER
CREATE ROLLBACK SEGMENT
ALTER ROLLBACK SEGMENT
DROP ROLLBACK SEGMENT
CREATE TABLE
CREATE ANY TABLE
ALTER ANY TABLE
BACKUP ANY TABLE
DROP ANY TABLE

PRIVILEGE
----------------------------------------
LOCK ANY TABLE
COMMENT ANY TABLE
SELECT ANY TABLE
INSERT ANY TABLE
UPDATE ANY TABLE
DELETE ANY TABLE
CREATE CLUSTER
CREATE ANY CLUSTER
ALTER ANY CLUSTER
DROP ANY CLUSTER
CREATE ANY INDEX

PRIVILEGE
----------------------------------------
ALTER ANY INDEX
DROP ANY INDEX
CREATE SYNONYM
CREATE ANY SYNONYM
DROP ANY SYNONYM
CREATE PUBLIC SYNONYM
DROP PUBLIC SYNONYM
CREATE VIEW
CREATE ANY VIEW
DROP ANY VIEW
CREATE SEQUENCE

PRIVILEGE
----------------------------------------
CREATE ANY SEQUENCE
ALTER ANY SEQUENCE
DROP ANY SEQUENCE
SELECT ANY SEQUENCE
CREATE DATABASE LINK
CREATE PUBLIC DATABASE LINK
DROP PUBLIC DATABASE LINK
CREATE ROLE
DROP ANY ROLE
GRANT ANY ROLE
ALTER ANY ROLE

PRIVILEGE
----------------------------------------
AUDIT ANY
ALTER DATABASE
FORCE TRANSACTION
FORCE ANY TRANSACTION
CREATE PROCEDURE
CREATE ANY PROCEDURE
ALTER ANY PROCEDURE
DROP ANY PROCEDURE
EXECUTE ANY PROCEDURE
CREATE TRIGGER
CREATE ANY TRIGGER

PRIVILEGE
----------------------------------------
ALTER ANY TRIGGER
DROP ANY TRIGGER
CREATE PROFILE
ALTER PROFILE
DROP PROFILE
ALTER RESOURCE COST
ANALYZE ANY
GRANT ANY PRIVILEGE
CREATE MATERIALIZED VIEW
CREATE ANY MATERIALIZED VIEW
ALTER ANY MATERIALIZED VIEW

PRIVILEGE
----------------------------------------
DROP ANY MATERIALIZED VIEW
CREATE ANY DIRECTORY
DROP ANY DIRECTORY
CREATE TYPE
CREATE ANY TYPE
ALTER ANY TYPE
DROP ANY TYPE
EXECUTE ANY TYPE
UNDER ANY TYPE
CREATE LIBRARY
CREATE ANY LIBRARY

PRIVILEGE
----------------------------------------
ALTER ANY LIBRARY
DROP ANY LIBRARY
EXECUTE ANY LIBRARY
CREATE OPERATOR
CREATE ANY OPERATOR
DROP ANY OPERATOR
EXECUTE ANY OPERATOR
CREATE INDEXTYPE
CREATE ANY INDEXTYPE
ALTER ANY INDEXTYPE
DROP ANY INDEXTYPE

PRIVILEGE
----------------------------------------
UNDER ANY VIEW
QUERY REWRITE
GLOBAL QUERY REWRITE
EXECUTE ANY INDEXTYPE
UNDER ANY TABLE
CREATE DIMENSION
CREATE ANY DIMENSION
ALTER ANY DIMENSION
DROP ANY DIMENSION
MANAGE ANY QUEUE
ENQUEUE ANY QUEUE

PRIVILEGE
----------------------------------------
DEQUEUE ANY QUEUE
CREATE ANY CONTEXT
DROP ANY CONTEXT
CREATE ANY OUTLINE
ALTER ANY OUTLINE
DROP ANY OUTLINE
ADMINISTER RESOURCE MANAGER
ADMINISTER DATABASE TRIGGER
ON COMMIT REFRESH
RESUMABLE
SELECT ANY DICTIONARY

PRIVILEGE
----------------------------------------
DEBUG CONNECT SESSION
DEBUG ANY PROCEDURE
FLASHBACK ANY TABLE
..............
155 rows selected.

SQL> select owner,object_name,original_name from dba_recyclebin;

OWNER                          OBJECT_NAME
------------------------------ ------------------------------
ORIGINAL_NAME
--------------------------------
SCOTT                          BIN$1dYrO3fJP7HgMAB/AQAYdQ==$0
SS



？？

SQL> desc v$tablespace
Name                                      Null?    Type
----------------------------------------- -------- ----------------------------
TS#                                                NUMBER
NAME                                               VARCHAR2(30)
INCLUDED_IN_DATABASE_BACKUP                        VARCHAR2(3)
BIGFILE                                            VARCHAR2(3)
FLASHBACK_ON                                       VARCHAR2(3)

SQL> select * from v$tablespace;

       TS# NAME                           INC BIG FLA
---------- ------------------------------ --- --- ---
         0 SYSTEM                         YES NO  YES
         1 UNDOTBS1                       YES NO  YES
         2 SYSAUX                         YES NO  YES
         4 USERS                          YES NO  YES
         3 TEMP                           YES NO  YES
         6 SOO2                           YES NO  YES

6 rows selected.

居然前面没注意你是用system登录的，system的默认表空间是SYSTEM。
知道你一定是没看文档啦

The recycle bin functionality is only available for non-system, locally managed tablespaces。

Oracle® Database Backup and Recovery Advanced User's Guide 10g Release 1 (10.1)中的原话。

http://www.itpub.net/showthread.php?s=&threadid=195961

多谢Kamus ！

QUOTE:

---

最初由 海天 发布
[oracle@redhatadv2 oracle]$ uniread sqlplus scott/tiger
[uniread] Loaded history (265 lines)

---

看来uniread 大家都开始用了，呵呵

uniread干什么用的？
    －－－不好意思的问

一个小窍门
alias usqlplus=uniread sqlplus
加在.bash_profile中
呵呵，可以少敲几个字