Error
Error Code: ORA-30091

ORA-30091: Secondary Table Missing

📦 Oracle Database
📋

Description

The ORA-30091 error in Oracle Database indicates that the secondary translation table needed for DST (Daylight Saving Time) patching on TSTZ (Timestamp with Time Zone) data is not loaded. This prevents accurate conversion and manipulation of TSTZ data during DST transitions.
💬

Error Message

secondary translation table not loaded
🔍

Known Causes

3 known causes
⚠️
Missing Patch Application
The DST patch containing the secondary translation table was not applied to the database.
⚠️
Incorrect Patch Application
The DST patch was applied incorrectly, preventing the secondary translation table from being loaded properly.
⚠️
Corrupted Translation Table
The secondary translation table file is corrupted, making it impossible for the database to load it.
🛠️

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