@marker_remove.sql fails with "*** Currently logged user does not have SYSDBA privileges!"
(Doc ID 1594311.1)
Last updated on DECEMBER 05, 2019
Applies to:Oracle GoldenGate - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
While performing DDL setup, running marker_remove.sql script fails with ORA-20783: "*** Currently logged user does not have SYSDBA privileges!"
$ sqlplus / as sysdba
Marker removal script.
WARNING: this script removes all marker objects and data.
You will be prompted for the name of a schema for the Oracle GoldenGate database objects.
NOTE: The schema must be created prior to running this script.
Enter Oracle GoldenGate schema name:OGG
ERROR at line 1:
Oracle GoldenGate DDL Replication setup:
*** Currently logged user does not have SYSDBA privileges!
*** Please login as SYSDBA.
ORA-06512: at line 10
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