Oracle Database Discussions

Hi all ,

oracle 11g.2 under OL 5.6

i'm try to drop all tables from my abs schema by using the below commands

select 'drop table '||table_name||' cascade constraints;' from user_tables;

and all the tables drop just one not dropped i don't know why ?

SQL> select * from tab;

TNAME                          TABTYPE  CLUSTERID
------------------------------ ------- ----------
tamim_ghlrbsvc                 TABLE

SQL>


SQL> drop table tamim_ghlrbsvc;
drop table tamim_ghlrbsvc
           *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> drop table tamim_ghlrbsvc purge;
drop table tamim_ghlrbsvc purge
           *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> select object_type from user_objects where object_name='tamim_ghlrbsvc';

OBJECT_TYPE
-------------------
TABLE


SQL> select * from tamim_ghlrbsvc;
select * from tamim_ghlrbsvc
              *
ERROR at line 1:
ORA-01775: looping chain of synonyms


SQL> drop synonym tamim_ghlrbsvc;
drop synonym tamim_ghlrbsvc
             *
ERROR at line 1:
ORA-01434: private synonym to be dropped does not exist


SQL> drop public synonym tamim_ghlrbsvc;

Synonym dropped.

SQL>
SQL>
SQL>
SQL>
SQL> select * from tab;

TNAME                          TABTYPE  CLUSTERID
------------------------------ ------- ---------
tamim_ghlrbsvc                 TABLE
SQL> drop table tamim_ghlrbsvc;
drop table tamim_ghlrbsvc
           *
ERROR at line 1:
ORA-00942: table or view does not exist