SQL & PL/SQL

I am receiving the error message the object already exist. However, I cannot find the object. Where else should I look for an existing object with the same name?

I looked in DBA_OBJECTS and ALL_TABLES.

Thanks.

 

SELECT DB.OBJECT_NAME, DB.OBJECT_TYPE, DB.OWNER 
FROM DBA_OBJECTS DB 
WHERE DB.OBJECT_NAME LIKE '%GTAS_ACCOUNTS%' 
ORDER BY DB.OBJECT_NAME; 

The only object returned is GTAS_ACCOUNTS_BACKUP which is a table. 

 
SELECT AT.TABLE_NAME 
                FROM ALL_TABLES AT 
                 WHERE UPPER(AT.TABLE_NAME) = Upper('GTAS_ACCOUNTS'); 

no rows returned. 

 

--DROP table 
BEGIN 
        EXECUTE IMMEDIATE  'ALTER TABLE gtas_accounts DROP PRIMARY KEY CASCADE'; 
            EXCEPTION WHEN OTHERS THEN NULL; 
END; 

declare 
           v_table_name varchar2(30); 

BEGIN 
           EXECUTE IMMEDIATE  ' DROP TABLE gtas_accounts CASCADE CONSTRAINTS'; 
            
            SELECT AT.TABLE_NAME 
                INTO :v_table_name 
                FROM ALL_TABLES AT 
                 WHERE UPPER(AT.TABLE_NAME) = Upper('GTAS_ACCOUNTS'); 
            EXCEPTION 
            WHEN NO_DATA_FOUND 
                    THEN NULL; 
            WHEN OTHERS 
                    THEN NULL; 
END; 


BEGIN 
            EXECUTE IMMEDIATE  'DROP TYPE FORCE GL260_ATTRIBUTES_TBL_TYP'; 
            EXCEPTION WHEN OTHERS THEN NULL; 
END; 


BEGIN       
              EXECUTE IMMEDIATE  'DROP TYPE FORCE GL260_REC_TYP';               
              EXCEPTION WHEN OTHERS THEN NULL; 
END; 

CREATE OR REPLACE TYPE  gl260_ATTRIBUTES_REC_TYP as object  -- GL260_ATTRIBUTES_REC_TYP 
(attribute    varchar2(40), 
  domain       varchar2(100)) 
/ 

-- CREATE  TABLE  OF TYPE 
CREATE OR REPLACE TYPE GL260_ATTRIBUTES_TBL_TYP as table of gl260_ATTRIBUTES_REC_TYP ;  -- GL260_ATTRIBUTES_TBL_TYP 
/ 
BEGIN 
             EXECUTE IMMEDIATE  'DROP PUBLIC SYNONYM GL260_ATTRIBUTES_TBL_TYP'; 
             EXCEPTION WHEN OTHERS THEN NULL; 
END; 

CREATE OR REPLACE PUBLIC SYNONYM GL260_ATTRIBUTES_TBL_TYP FOR GL260_ATTRIBUTES_TBL_TYP; 

GRANT EXECUTE ON GL260_ATTRIBUTES_TBL_TYP TO &&connect_identifier; 

--****************************************************************** 
-- create GTAS_ACCOUNTS TABLE 
--****************************************************************** 

CREATE TABLE GTAS_ACCOUNTS 
( 
  USSGL_ACCOUNT_NO    VARCHAR2(6 BYTE), 
  DESCRIPTION         VARCHAR2(140 BYTE), 
  ATTRIBUTE_LIST      CAMSADM.GL260_ATTRIBUTES_TBL_TYP, 
  TAS_ATTRIBUTE_LIST  CAMSADM.GL260_ATTRIBUTES_TBL_TYP 
) 
NESTED TABLE ATTRIBUTE_LIST STORE AS ATTRIBUTE_LIST_TBL, 
NESTED TABLE TAS_ATTRIBUTE_LIST STORE AS TAS_ATTRIBUTE_LIST_TBL; 

ERROR MESSAGE

 

*CREATE TABLE GTAS_ACCOUNTS* 
*(* 
  *USSGL_ACCOUNT_NO    VARCHAR2(6 BYTE),* 
  *DESCRIPTION         VARCHAR2(140 BYTE),* 
  *ATTRIBUTE_LIST      CAMSADM.GL260_ATTRIBUTES_TBL_TYP,* 
  *TAS_ATTRIBUTE_LIST  CAMSADM.GL260_ATTRIBUTES_TBL_TYP* 
*)* 
*NESTED TABLE ATTRIBUTE_LIST STORE AS ATTRIBUTE_LIST_TBL,* 
*NESTED TABLE TAS_ATTRIBUTE_LIST STORE AS TAS_ATTRIBUTE_LIST_TBL* 
*Error at line 57* 
*ORA-00955: name is already used by an existing object*