1、创建用户，并用该用户登录创建表

SQL> create user xjh identified by xjh;

User created

SQL> grant dba to xjh;

Grant succeeded

SQL> create table tt as select * from V$parameter;

Table created

SQL> commit;

Commit complete

SQL> desc tt

Name                  Type          Nullable Default Comments 

--------------------- ------------- -------- ------- -------- 

NUM                   NUMBER        Y                         

NAME                  VARCHAR2(80)  Y                         

TYPE                  NUMBER        Y                         

VALUE                 VARCHAR2(512) Y                         

DISPLAY_VALUE         VARCHAR2(512) Y                         

ISDEFAULT             VARCHAR2(9)   Y                         

ISSES_MODIFIABLE      VARCHAR2(5)   Y                         

ISSYS_MODIFIABLE      VARCHAR2(9)   Y                         

ISINSTANCE_MODIFIABLE VARCHAR2(5)   Y                         

ISMODIFIED            VARCHAR2(10)  Y                         

ISADJUSTED            VARCHAR2(5)   Y                         

ISDEPRECATED          VARCHAR2(5)   Y                         

DESCRIPTION           VARCHAR2(255) Y                         

UPDATE_COMMENT        VARCHAR2(255) Y                         

HASH                  NUMBER        Y                         

SQL> select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') from dual;

TO_CHAR(SYSDATE,'YYYY-MM-DDHH2

------------------------------

2012-01-31 09:13:22

2、删除表

SQL> drop table tt;

Table dropped

SQL> commit;

Commit complete 

3、查看回收站

 show recyclebin ;或

 select * from recyclebin;