View not exist
Hi all,
Try to drop schema objects but there is an error...
QL> SELECT 'DROP '|| OBJECT_TYPE || ' ' ||OWNER||'.'||OBJECT_NAME||';'
FROM SYS.DBA_OBJECTS WHERE OWNER = 'EYELITMES' AND OBJECT_TYPE IN ('LOB','INDEX','TABLE','VIEW') 2 ;
'DROP'||OBJECT_TYPE||''||OWNER||'.'||OBJECT_NAME||';'
--------------------------------------------------------------------------------
DROP VIEW EYELITMES.E_A_VIEW_RWK_ADD_VARIABLES ;
DROP VIEW EYELITMES.E_A_VIEW_RWK_RTP_ADD_DCOP ;
SQL> DROP VIEW EYELITMES.E_A_VIEW_RWK_ADD_VARIABLES;
DROP VIEW EYELITMES.E_A_VIEW_RWK_ADD_VARIABLES
*
ERROR at line 1:
ORA-00942: table or view does not exist