@marker_remove.sql fails with "*** Currently logged user does not have SYSDBA privileges!"
Last updated on JULY 03, 2017
Applies to:Oracle GoldenGate - Version 184.108.40.206.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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms