Oracle Can a Dropped View Be Recovered?
Sure. For example: use flashback query on DBA_VIEWS.

SQL&gt; alter session set nls_date_format='YYYY-MM-DD HH24:MI:SS';

Session altered.

SQL&gt; create or replace view v1 as select * from dual;

View created.

SQL&gt; select sysdate from dual;

SYSDATE
-------------------
2019-11-29 12:30:48

SQL&gt; select count(*) from dba_views where view_name = 'V1';

  COUNT(*)
----------
         1

SQL&gt; select text from dba_views where view_name = 'V1';

TEXT
--------------------------------------------------------------------------------
select "DUMMY" from dual

SQL&gt; drop view v1;

View dropped.

SQL&gt; select count(*) from dba_views where view_name = 'V1';

  COUNT(*)
----------
         0

SQL&gt; select text from dba_views where view_name = 'V1';

no rows selected

SQL&gt; select sysdate from dual;

SYSDATE
-------------------
2019-11-29 12:32:17

SQL&gt; select text from dba_views as of timestamp timestamp'2019-11-29 12:30:48' where view_name = 'V1';

TEXT
--------------------------------------------------------------------------------
select "DUMMY" from dual


This may or may not work, depending on whether you still have the required unto to perform the above flashback query.