I have a table, let's call it
In SQLDeveloper, I can see the data in the table using:
SELECT * FROM MYTABLE
However, when I do
DESC MYTABLE, it gives me an error:
ERROR: object MYTABLE does not exist.
If I try the same thing from sqlplus, there is no error and I get a listing of the columns in the table.
dba_all_tables and there is a row for the table.
select * from dba_all_tables where table_name = 'MYTABLE';
returns 1 row as expected.
Any ideas as to what I'm missing?
The command works fine with a different table (
MYSCHEMA.MYTABLE2), so it's likely not a sql developer bug.
The same table exists in several schemas:
select owner, object_type, count(*) from dba_objects where object_name='MYTABLE' and owner='MYSCHEMA' group by owner, object_type; MYSCHEMA TABLE SUBPARTITION 128 MYSCHEMA TABLE PARTITION 16 MYSCHEMA TABLE 1
Unfortunately, I can't provide a set of steps to reproduce this independently because these tables already exist in the schema I'm working on. My best guess right now is that something went wrong during the table creation long ago, and I can't go back and look at the source code that was executed back then because of a SCCS change in the company.
MYTABLE is not a synonym or mview.