Error
Error Code: ORA-29367

Oracle ORA-29367: Invalid Object Name

📦 Oracle Database
📋

Description

This error indicates that the object name provided to the `CREATE_PLAN_DIRECTIVE` procedure within the `DBMS_RESOURCE_MANAGER` package does not exist. It typically occurs when attempting to create a resource plan directive referencing a non-existent plan or consumer group.
💬

Error Message

ORA-29367: object string does not exist
🔍

Known Causes

3 known causes
⚠️
Typographical Error
A typo in the plan or consumer group name was introduced when calling `CREATE_PLAN_DIRECTIVE`.
⚠️
Object Does Not Exist
The referenced plan or consumer group was never created in the database.
⚠️
Incorrect Schema
The specified object exists, but not in the schema where the `CREATE_PLAN_DIRECTIVE` command is being executed.
🛠️

Solutions

Coming Soon

Detailed step-by-step solutions for this error are being prepared. In the meantime, try these general troubleshooting tips:

General Troubleshooting Tips

  • Check the error message carefully for specific details
  • Review recent changes that might have caused the error
  • Search for the exact error code in the official documentation
  • Check log files for additional context
  • Try restarting the application or service

Find Help

Stack Overflow Google Search Official Docs