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.