Database Administration (MOSC)

MOSC Banner

Weird Situation

edited Jul 9, 2010 6:16PM in Database Administration (MOSC) 4 commentsAnswered ✓
 Ok, in sqlplus I did the following query:

SQL> select table_name from dba_tables where owner='ACCESSECO';

TABLE_NAME
------------------------------
Table1
ITEMS

This is the results I got. However, when I try to analyze the table for statistics, I got the following error:

SQL> analyze table accesseco.Table1 compute statistics;
analyze table accesseco.Table1 compute statistics
                        *
ERROR at line 1:
ORA-00942: table or view does not exist

Did I miss something here?

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