ORACLE Delete View recovery by mistake

1. Using Dba_views

Fallback to a specific time period to view the definition

Select View_name,text from (SELECT * from Dba_views as of  TIMESTAMP (systimestamp-interval ' 5 ' hour-interval ' "min Ute)) where view_name= ' vp_taskclass_info ';

Note that you have to have DBA authority here.

2, TEXT is a long type, in the Sqlplus to first set the next

Sql> set line 100; Sql> set long 20000000; Sql> set Longchunksize 255; sql> spool c:\test.txtsql> SELECT * from Aaasql>spool off

　　

ORACLE Delete View recovery by mistake