Geek Answers Handbook

Oracle - zombie table

I have got such a weird problem since yesterday. I tried several options, and I actually reinstalled ORACLE and the database itself.

Here's the problem: I have this table, which is something like a zombie. Here are the symptoms:

SELECT TABLE_NAME FROM USER_TABLES WHERE TABLE_NAME='MYTABLE'

Returns a record, which means the table exists.

SELECT COLUMN_NAME FROM USER_TAB_COLUMNS WHERE TABLE_NAME = 'MYTABLE'

Returns all columns of MYTABLE. So far so good, the table exists.

SELECT * FROM MYTABLE

Returns ORA-00942: the table or view does not exist . At the moment, I'm completely confused: the table seems to exist on USERTABLES, but I can not select it?

CREATE TABLE MYTABLE (Foo NUMBER) TABLESPACE MYTABLESPACE

Returns: ORA-00604: error at recursive SQL level 1 ORA-00001: unique constraint (SYS.I_OBJ2) violated

I do not understand this error. But the best is yet to come.

SELECT * FROM MYTABLE

, ( 3- ) ! , , Foo : , , - .

DROP TABLE MYTABLE

, :

ORA-00604: SQL 1 ORA-00942: ORA-06512: 19

SELECT * FROM MYTABLE

, -, , , .

: USERTABLES, , , , , SELECT .

? : (

- : . .

, MDSYS.SDO_GEOR_SYSDATA_TABLE , , . .

+5
2

, :

SELECT *
  FROM dba_objects
 WHERE object_name = 'MYTABLE';

, . .

+1

. CURRENT_SCHEMA . ,

select SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA') from dual;

, , / ?

, , - ? , SYSDBA - ....

+1

More articles:


All Articles