Database Database - General Oracle Error Messages ORA ORA-06564: object name does not exist

Oracle Error Messages



Statistics

Content View Hits : 473261

Who's Online

We have 1 guest online
ORA-06564: object name does not exist
User Rating: / 16
PoorBest 

 

ORA-06564:
object name does not exist
Cause:
You tried to reference an object that either does not exist or you do not have privileges to access it.
Action:
The options to resolve this Oracle error are:
1. If the object does not exist, create this object.

2. If you do not have privileges to this object, ask the object owner or DBA to grant you access to it.

 


 

Solutions:

If you got this error when you run Oracle Data Pump (export/import full database), check the directory permissions, The following command show how to make a directory and what permissions you need (In this situation you get this error with ORA-31693 error number):

SQL> create directory PUMP_DIR as '/opt02/app/oracle/oradb_dump'
SQL> grant read,write on  directory PUMP_DIR  to exp_full_database;
SQL> grant read,write on  directory PUMP_DIR to imp_full_database;