Getting error ora 27475
Getting error Ora 27475 unknown database or dest_group SYS.EARLY_MORNING_WINDOW
while executing the below
BEGIN
DBMS_SCHEDULER.CREATE_WINDOW(
window_name => 'EARLY_MORNING_WINDOW',
duration => NUMTODSINTERVAL(1, 'hour'),
resource_plan => 'DEFAULT_MAINTENANCE_PLAN',
repeat_interval => 'FREQ=DAILY;BYHOUR=5;BYMINUTE=0;BYSECOND=0');
DBMS_SCHEDULER.ADD_GROUP_MEMBER(
group_name => 'SYS.MAINTENANCE_WINDOW_GROUP',
member => 'EARLY_MORNING_WINDOW');
END;
I am executing as a user who has DBA role. I checked dba_objects and EARLY_MORNING_WINDOW is owned by sys after creating it. It seems some other grant needs to be granted to this user - any help would be appreciated.