Database Administration (MOSC)

MOSC Banner

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center