Environment: windows server 2008 ORACLE 126.96.36.199 single instance
Add data file hint
ORA-04045: errors during recompilation/revalidation of MDSYS.SDO_GEOR_ADDL_TRIGGER ORA-01031: insufficient privileges
Query mos says that it needs to authorize
mdsys, the command is as follows
grant administer database trigger to mdsys;
The result is still no permission.
After many twists and turns, it was finally solved. Turn on the Oracle hidden permissions and use it with caution. You can also delete things that cannot be deleted when you turn off.
alter system set "_system_trig_enabled"=falese scope=both;
After closing, recompile the trigger or close the trigger. Then change the hidden parameters
alter system set "_system_trig_enabled"=true scope=both;
Or try the following method, the method has not been tested, and I don’t know the result. The above method is available for pro test
sysdbaexecutes ORACLE_HOME/rdbms/admin/utlrp.sql script There are also two ways to compile invalid objects: 1 Use alter **** compile statement to compile 2 Use the DBMS_UTILITYpackage to compile .