Database Administration (MOSC)

MOSC Banner

DESCRIBE and ORA-00942

edited Oct 15, 2009 10:34PM in Database Administration (MOSC) 4 commentsAnswered ✓
 I connect as user SYSTEM and try to query a user schema (US) : SELECT * FROM US.USER_TABLES; --> error ORA-00942

But, DESCRIBE US.USER_TABLES works fine.

I can understand why SELECT fails, but not why DESC succeeds.
Any explanation ?

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