Something in dba_segments but not in dba_objects
Hi,
I think I met a bug. It's Oracle 11.1.0.7.0 Enterprise Edition 64bit on Oracle Enterprise Linux Server Release 5 Update 6.
I tried to drop a tablespace but cannot. The 'drop tablespace' returned error ORA-1561 saying there're some objects in the tablespace. So I checked the dba_segments and dba_extents, and there were some tables owned by SYS in the tablespace. Then I tried to drop the tables manually, but the 'drop table' returned with ORA-942 saying the table did not exist. I checked the dba_tables and dba_objects to ensure the existance of the table, but cannot find them.
I think I met a bug. It's Oracle 11.1.0.7.0 Enterprise Edition 64bit on Oracle Enterprise Linux Server Release 5 Update 6.
I tried to drop a tablespace but cannot. The 'drop tablespace' returned error ORA-1561 saying there're some objects in the tablespace. So I checked the dba_segments and dba_extents, and there were some tables owned by SYS in the tablespace. Then I tried to drop the tables manually, but the 'drop table' returned with ORA-942 saying the table did not exist. I checked the dba_tables and dba_objects to ensure the existance of the table, but cannot find them.
0