How to resolve ORA-06564 Error Message in Oracle database

Learn the cause and how to get to the bottom of the ORA-06564 error message in Oracle.

Description

When you encounter an ORA-06564 error, the following error message will appear:

ORA-06564: object name does not exist

Cause

You tried to reference an object that both does not exist or you do now not have privileges to get right of entry to it.

Resolution

The option(s) to resolve this Oracle error are:

Option #1

If the object does not exist, create this object.

You can use the CREATE TABLE announcement to create a table.

CREATE TABLE table_name
( 
  column1 datatype [ NULL | NOT NULL ],
  column2 datatype [ NULL | NOT NULL ],
  ...
);

For example, you can create a desk known as clients which has three columns as follows:

CREATE TABLE customers
( customer_id number(10) not null,
  customer_name varchar2(50) not null,
  city varchar2(50)
);

Option #2

If you do no longer have privileges to this object, ask the object owner or DBA to grant you get entry to to it.

You can use the GRANT assertion to provide privileges to the object the usage of the following syntax:

GRANT privileges ON object TO user;

For example, if you desired to grant SELECT, INSERT, UPDATE, and DELETE privileges on a desk referred to as clients to the consumer smithj, you would run the following GRANT statement:

GRANT SELECT, INSERT, UPDATE, DELETE ON customers TO smithj;