Hello All,
I logged into Oracle 10 using sqlplus / as sysdba
I am trying to alter user SYS or SYSMAN, and each time I am getting the following error:
SQL> alter user sys identified by password;
alter user sys identified by password
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-04045: errors during recompilation/revalidation of
OGGDEMO_ADMIN.DDLREPLICATION
ORA-04064: not executed, invalidated
ORA-04064: not executed, invalidated package body
"OGGDEMO_ADMIN.DDLREPLICATION"
ORA-06508: PL/SQL: could not find program unit being called:
"OGGDEMO_ADMIN.DDLREPLICATION"
ORA-06512: at line 60
ORA-06508: PL/SQL: could not find program unit being called:
"OGGDEMO_ADMIN.DDLREPLICATION"
ORA-06512: at line 60
Please help, and thank you for your help in advance.
I logged into Oracle 10 using sqlplus / as sysdba
I am trying to alter user SYS or SYSMAN, and each time I am getting the following error:
SQL> alter user sys identified by password;
alter user sys identified by password
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-04045: errors during recompilation/revalidation of
OGGDEMO_ADMIN.DDLREPLICATION
ORA-04064: not executed, invalidated
ORA-04064: not executed, invalidated package body
"OGGDEMO_ADMIN.DDLREPLICATION"
ORA-06508: PL/SQL: could not find program unit being called:
"OGGDEMO_ADMIN.DDLREPLICATION"
ORA-06512: at line 60
ORA-06508: PL/SQL: could not find program unit being called:
"OGGDEMO_ADMIN.DDLREPLICATION"
ORA-06512: at line 60
Please help, and thank you for your help in advance.