how to enable supplemental logging?
(pardon the double posting - I originally posted this in the ATP forum, but I discovered this forum appears to be more active)
how do I enable supplemental logging in an Oracle Cloud database (ATP)?
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
ORA-01031: insufficient privileges
01031. 00000 - "insufficient privileges"
I know that Amazon RDS for Oracle provides rdsadmin_util functions for doing some system-type functions like this e.g.
rdsadmin.rdsadmin_util.alter_supplemental_logging(p_action => 'ADD');
rdsadmin.rdsadmin_util.set_configuration(name => 'archivelog retention hours', value => '24');
I am hoping that Oracle Cloud provides something similar, but so far I have been finding nothing.