Oracle database恢复被修改的视图实现方式

select * from all_objects  where object_name='cv_sr_part';
owner                          object_name                    subobject_name                  object_id data_object_id object_type         created     last_ddl_time timestamp           status  temporary generated secondary  namespace edition_name
------------------------------ ------------------------------ ------------------------------ ---------- -------------- ------------------- ----------- ------------- ------------------- ------- --------- --------- --------- ---------- ------------------------------
siebel                         cv_sr_part                                                        287957                view                2016/7/7 2: 2018/6/8 11:5 2018-06-08:11:52:16 valid   n         n         n                  1 

select * from dba_views where view_name='cv_sr_part'

select text from dba_views as of timestamp to_date('201806081100','yyyymmddhh24miss') where view_name='cv_sr_part';