How to perform DML and DDL statements on a Logical Standby Database with privileged users other than SYS/SYSDBA without getting ORA-01031
(Doc ID 2808047.1)
Last updated on JANUARY 10, 2023
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 and later
Information in this document applies to any platform.
When attempting to perform a Data Definition Language (DDL) or a Data Manipulation Language (DML) statement in a Logical Standby Database with a user other than SYS and/or SYSDBA privileged ones, error ORA-01031 is raised although the correct privileges are in place for the user:
Is it possible to perform these actions in a Logical Standby Database without having to execute them as SYS or grant a user with SYSDBA privilege?
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