Database Administration (MOSC)

MOSC Banner

View not exist

edited Nov 20, 2018 5:31AM in Database Administration (MOSC) 6 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center