ALTER SYSTEM Executed By A Database Trigger Fails With ORA-1031 After The Upgrade To 220.127.116.11
(Doc ID 1636481.1)
Last updated on OCTOBER 10, 2022
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 and later
Information in this document applies to any platform.
- You are using version 22.214.171.124
- You have a trigger defined as after startup on database
- It is owned by another user than SYS (for example SYSTEM)
- Inside the trigger body an ALTER SYSTEM command is issued using dynamic sql (for example to set use_stored_outlines)
Upgrade to version 126.96.36.199 from a previous release.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document