ORA-04043: object does not exist
ORA-04043: Object emp does not exist.DESC or DROP could not find an object with that name in the place Oracle looked.
Lab-verifiedReproduced and fixed on Oracle AI Database 26ai Free 23.26.3.0.0 · 2026-11-15
ORA-04043 mostly comes from DESC (DESCRIBE) and DROP. Oracle looks for the name, converted to upper case, in your own schema (or via a synonym). If it is not there, you get this error. In 23ai the message includes the name: ORA-04043: Object emp does not exist.
The object may still exist: in another schema, or with a name created in double quotes. all_objects / all_tables tell you the real owner and spelling.
Causes and fixes
1DESC on another schema's table without the owner name
emp was created by LAB_B and SELECT was granted to LAB_A. Still, DESC emp as LAB_A gave Object emp does not exist, because Oracle only looked in LAB_A's schema.
all_tables showed the owner was LAB_B. DESC lab_b.emp printed the columns EMP_ID, EMP_NAME, DEPT_ID. (SET LINESIZE 60 only narrows the SQL*Plus output so the Type column fits.)
Setup
CREATE TABLE emp (emp_id NUMBER PRIMARY KEY, emp_name VARCHAR2(30), dept_id NUMBER);
GRANT SELECT ON emp TO lab_a;Table created.
Grant succeeded.DESC empERROR:
ORA-04043: Object emp does not exist.
Help: https://docs.oracle.com/error-help/db/ora-04043/SELECT owner, table_name FROM all_tables WHERE table_name = 'EMP';OWNER TABLE_NAME
------------------------------ ------------------------------
LAB_B EMP
1 row selected.This is the same cause as ORA-00942 on a SELECT: always add the owner (or use a synonym) for other schemas' objects.
SET LINESIZE 60
DESC lab_b.emp Name Null? Type
----------------------------- -------- --------------------
EMP_ID NOT NULL NUMBER
EMP_NAME VARCHAR2(30)
DEPT_ID NUMBER2The table was created with a quoted mixed-case name
The table was created as "Orders" in double quotes, so its name is stored exactly as Orders. DESC orders looks for ORDERS and fails.
Searching with UPPER(table_name) = 'ORDERS' in user_tables showed the real name Orders. DESC "Orders" with the same quotes worked.
Setup
CREATE TABLE "Orders" (order_id NUMBER PRIMARY KEY, amount NUMBER);Table created.DESC ordersERROR:
ORA-04043: Object orders does not exist.
Help: https://docs.oracle.com/error-help/db/ora-04043/SELECT table_name FROM user_tables WHERE UPPER(table_name) = 'ORDERS';TABLE_NAME
------------------------------
Orders
1 row selected.SET LINESIZE 60
DESC "Orders" Name Null? Type
----------------------------- -------- --------------------
ORDER_ID NOT NULL NUMBER
AMOUNT NUMBER3A deploy script drops a procedure that is not there yet
A script starting with DROP PROCEDURE calc_bonus; failed on a fresh schema with Object CALC_BONUS does not exist. user_objects had 0 rows for CALC_BONUS.
23ai supports DROP PROCEDURE IF EXISTS. On the same schema it printed Procedure dropped. with no error, then CREATE OR REPLACE PROCEDURE created it and user_objects showed status VALID.
Setup
CREATE TABLE emp (emp_id NUMBER PRIMARY KEY, sal NUMBER, bonus NUMBER);Table created.DROP PROCEDURE calc_bonus;DROP PROCEDURE calc_bonus
*
ERROR at line 1:
ORA-04043: Object CALC_BONUS does not exist.
Help: https://docs.oracle.com/error-help/db/ora-04043/SELECT COUNT(*) AS cnt FROM user_objects WHERE object_name = 'CALC_BONUS'; CNT
----------
0
1 row selected.For a procedure, CREATE OR REPLACE alone already replaces it, so the DROP is often not needed at all.
DROP PROCEDURE IF EXISTS calc_bonus;
CREATE OR REPLACE PROCEDURE calc_bonus AS
BEGIN
UPDATE emp SET bonus = sal * 0.1;
END;
/
SELECT object_name, object_type, status FROM user_objects WHERE object_name = 'CALC_BONUS';Procedure dropped.
Procedure created.
OBJECT_NAME OBJECT_TYPE STATUS
------------------------------ ------------------------------ ------------------------------
CALC_BONUS PROCEDURE VALID
1 row selected.FAQ
What does ORA-04043 object does not exist mean?
DESC or DROP could not find the object under that name. It may not exist, or it may be in another schema or have a case-sensitive name.
I was granted access to the table, so why does DESC give ORA-04043?
Check the owner. If the table is in another schema, use DESC owner.table. all_tables shows the owner.
How do I DROP only if the object exists in Oracle?
In 23ai use DROP PROCEDURE IF EXISTS name;. It finishes without error when nothing is there.
The table is listed in user_tables but DESC fails. Why?
It was probably created with a quoted name like "Orders". Use the exact name in double quotes: DESC "Orders".
How we verify
Each scenario starts from fresh database users. A script runs the setup, confirms the exact error code, applies the fix and runs the statement again. The output shown is what the database printed, saved by the script.
lab_a and lab_b are ordinary users created for the test; system is the DBA account. Oracle AI Database 26ai Free Release 23.26.3.0.0 - Develop, Learn, and Run for Free