恢复删除的view

SQL> create view v_test as
  2  select * from user_objects;

View created.

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

TO_CHAR(SYSDATE,'YY
-------------------
2012-01-12 18:12:33

SQL> drop view v_test;

View dropped.

SQL> CONN / AS SYSDBA
Connected.

SQL> SET LONG 1000
SQL> SELECT text
  2     FROM dba_views AS OF TIMESTAMP TO_TIMESTAMP('2012-01-12 18:12:33', 'YYYY-MM-DD HH24:MI:SS')
  3    WHERE OWNER = 'CHF' AND VIEW_NAME = 'V_test';

TEXT
--------------------------------------------------------------------------------
select "OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID","DATA_OBJECT_ID","OBJECT_TYPE"
,"CREATED","LAST_DDL_TIME","TIMESTAMP","STATUS","TEMPORARY","GENERATED","SECONDA
RY","NAMESPACE","EDITION_NAME" from user_objects