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

  1. DESC on another schema's table without the owner name
  2. The table was created with a quoted mixed-case name
  3. A deploy script drops a procedure that is not there yet

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
Setuprun as lab_b
CREATE TABLE emp (emp_id NUMBER PRIMARY KEY, emp_name VARCHAR2(30), dept_id NUMBER);
GRANT SELECT ON emp TO lab_a;
OUTPUT
Table created.


Grant succeeded.
Reproducerun as lab_a
DESC emp
OUTPUT
ERROR:
ORA-04043: Object emp does not exist.
Help: https://docs.oracle.com/error-help/db/ora-04043/
Checkrun as lab_a
SELECT owner, table_name FROM all_tables WHERE table_name = 'EMP';
OUTPUT
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.

After the fixrun as lab_a
SET LINESIZE 60
DESC lab_b.emp
OUTPUT
 Name                          Null?    Type
 ----------------------------- -------- --------------------
 EMP_ID                        NOT NULL NUMBER
 EMP_NAME                               VARCHAR2(30)
 DEPT_ID                                NUMBER

2The 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
Setuprun as lab_a
CREATE TABLE "Orders" (order_id NUMBER PRIMARY KEY, amount NUMBER);
OUTPUT
Table created.
Reproducerun as lab_a
DESC orders
OUTPUT
ERROR:
ORA-04043: Object orders does not exist.
Help: https://docs.oracle.com/error-help/db/ora-04043/
Checkrun as lab_a
SELECT table_name FROM user_tables WHERE UPPER(table_name) = 'ORDERS';
OUTPUT
TABLE_NAME
------------------------------
Orders

1 row selected.
After the fixrun as lab_a
SET LINESIZE 60
DESC "Orders"
OUTPUT
 Name                          Null?    Type
 ----------------------------- -------- --------------------
 ORDER_ID                      NOT NULL NUMBER
 AMOUNT                                 NUMBER

3A 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
Setuprun as lab_a
CREATE TABLE emp (emp_id NUMBER PRIMARY KEY, sal NUMBER, bonus NUMBER);
OUTPUT
Table created.
Reproducerun as lab_a
DROP PROCEDURE calc_bonus;
OUTPUT
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/
Checkrun as lab_a
SELECT COUNT(*) AS cnt FROM user_objects WHERE object_name = 'CALC_BONUS';
OUTPUT
       CNT
----------
         0

1 row selected.

For a procedure, CREATE OR REPLACE alone already replaces it, so the DROP is often not needed at all.

After the fixrun as lab_a
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';
OUTPUT
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

Related errors