| Alter user [message #251861] |
Tue, 17 July 2007 00:27  |
crussed_sonu
Messages: 51
Registered: July 2007
Location: Delhi
|
Member |
|
|
Hi
oracle 9i
windows platform
I am trying to change the password but i get the following error.
SQL> alter user system identified by manager;
alter user system identified by manager
*
ERROR at line 1:
ORA-04098: trigger 'SYS.CDC_ALTER_CTABLE_BEFORE' is invalid and failed
re-validation
SQL> show user
USER is "SYS"
Reply me soon
thanks
|
|
|
|
|
|
|
|
|
|
| Re: Alter user [message #251883 is a reply to message #251861] |
Tue, 17 July 2007 01:24  |
 |
Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
You should also investigate why this trigger is invalid.
First, try to recompile it but with the following conditions:
- put your instance in restricted session to avoid any user: "alter system enable restricted session" (or better "shutdown immediate" and "startup restrict")
- execute: alter system set "_system_trig_enabled"=true;
- execute: alter trigger SYS.CDC_ALTER_CTABLE_BEFORE compile;
- execute: alter system set "_system_trig_enabled"=false;
- execute: alter system disable restricted session;
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
