Object does not exist

This topic takes a table object as an example to describe the troubleshooting procedure when the object does not exist.

Error: ORA-04043

Error code

• Error code in OceanBase Database: 5400

• SQLSTATE: HY000

Error message

ORA-04043: object %.*s does not exist

Examples

When you query the student table, this error is returned, indicating that the object does not exist.

obclient> desc dws_ny;
ORA-04043: object SYS.DWS_NY does not exist

Troubleshooting procedure

1. If the table does not exist, we recommend that you check whether the table name is correct. If yes, execute the CREATE TABLE statement to create a table as needed. Examples:

   CREATE TABLE dws_ny(
   id NUMBER,
   name varchar(18),
   sex char(1),
   age NUMBER,
   address varchar(200),
   email varchar(100),
   c_date date,
   PRIMARY KEY (id)
   );
   

2. Query the table again.

   obclient> desc dws_ny;
   +---------+---------------+------+-----+---------+-------+
   | FIELD   | TYPE          | NULL | KEY | DEFAULT | EXTRA |
   +---------+---------------+------+-----+---------+-------+
   | ID      | NUMBER(38)    | NO   | PRI | NULL    | NULL  |
   | NAME    | VARCHAR2(18)  | YES  | NULL | NULL    | NULL  |
   | SEX     | CHAR(1)       | YES  | NULL | NULL    | NULL  |
   | AGE     | NUMBER(38)    | YES  | NULL | NULL    | NULL  |
   | ADDRESS | VARCHAR2(200) | YES  | NULL | NULL    | NULL  |
   | EMAIL   | VARCHAR2(100) | YES  | NULL | NULL    | NULL  |
   | C_DATE  | DATE          | YES  | NULL | NULL    | NULL  |
   +---------+---------------+------+-----+---------+-------+
   7 rows in set