Database Administration (MOSC)

MOSC Banner

Trying to drop the table

edited Mar 31, 2010 8:00PM in Database Administration (MOSC) 12 commentsAnswered
Hello Friends,
Im trying to drop/truncate some user  tables in database(10.2.0.2.0).
But im getting error like

ERROR at line 1:
ORA-00942: table or view does not exist

Please give some suggestions on this.


SQL> TRUNCATE TABLE E3SSTG.SYMBOLATTRIBUTE;
TRUNCATE TABLE E3SSTG.SYMBOLATTRIBUTE
                      *
ERROR at line 1:
ORA-00942: table or view does not exist

SQL> DROP TABLE E3SSTG.SymbolAttribute;
DROP TABLE E3SSTG.SymbolAttribute
                  *
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