Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

[SOLVED] dba_objects, dba_tables, user_tables... do not exist

1060787Dec 17 2013 — edited Dec 17 2013

Hi everyone,

I have an issue with my oracle instance. I do not know if i missed something during install process but i can not list the tables or objects. Not even with sysdba. I have created some tables and i can do it without problems. I can add rows, i can create users, i can work, but i cant list tables on sqldeveloper, i cant query dba_objects, dba_tables...

Maybe this can clarify what i mean:

[oracle@oraarcadia ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 17 12:46:06 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 1068937216 bytes

Fixed Size                  2220200 bytes

Variable Size             683675480 bytes

Database Buffers          377487360 bytes

Redo Buffers                5554176 bytes

Database mounted.

Database opened.

SQL> select * from arcadia.tendercategory;

        ID NAME                 POSID                   ACCC_ID

---------- -------------------- -------------------- ----------

         1 cash                 2                             1

         2 generic              1                             1

SQL> select * from dba_tables;

select * from dba_tables

              *

ERROR at line 1:

ORA-00942: table or view does not exist

SQL> select * from sys.dba_objects;

select * from sys.dba_objects

                  *

ERROR at line 1:

ORA-00942: table or view does not exist



Can you help me?


Thank you very much.

This post has been answered by Srini Chavali-Oracle on Dec 17 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 14 2014
Added on Dec 17 2013
7 comments
6,378 views