DROP VIEW后的恢复

SQL> create view v_xhm as select * from dba_users;

View created.

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

TO_CHAR(SYSDATE,'YY
-------------------
2012-09-17 11:15:24

SQL>
SQL> drop view v_xhm;

View dropped.

SQL> set long 1000
SQL> SELECT TEXT FROM DBA_VIEWS WHERE WNER='SYS' AND VIEW_NAME='V_XHM';

no rows selected

SQL> SELECT TEXT FROM DBA_VIEWS  AS OF TIMESTAMP TO_TIMESTAMP('2012-09-17 11:15:24', 'YYYY-MM-DD HH24:MI:SS') WHERE  VIEW_NAME='V_XHM' AND WNER='SYS';

TEXT
--------------------------------------------------------------------------------
select "USERNAME","USER_ID","PASSWORD","ACCOUNT_STATUS","LOCK_DATE","EXPIRY_DATE
","DEFAULT_TABLESPACE","TEMPORARY_TABLESPACE","CREATED","PROFILE","INITIAL_RSRC_
CONSUMER_GROUP","EXTERNAL_NAME" from dba_users

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26655292/viewspace-743746/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26655292/viewspace-743746/