|
|
IOTN :: Field Book :: ORACLE 
|
|
ORA-04045: errors during recompilation/revalidation of XSERVER.CO_NO_DROP
|
|
최길호
[LIST]
|
2021-09-15 19:43:55, 조회 : 899 |
SQL> @$ORACLE_HOME/rdbms/admin/catcmprm.sql ORDIM
SELECT dbms_registry_sys.removal_script('ORDIM')
*
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of XSERVER.CO_NO_DROP
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_REGISTRY_SYS", line 196
ORA-04045: errors during recompilation/revalidation of XSERVER.CO_NO_DROP
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_REGISTRY_SYS", line 257
ORA-06512: at "SYS.DBMS_REGISTRY_SYS", line 1001
select
lpad(' ', 2*level) || granted_role "User, his roles and privileges"
from
(
select null grantee, username granted_role from dba_users
where username like upper('XSERVER')
union
select grantee, granted_role
from dba_role_privs
union
select grantee, privilege
from dba_sys_privs
)
start with grantee is null
connect by grantee = prior granted_role;
조치:
grant ADMINISTER DATABASE TRIGGER to XSERVER ;
출처: ORA-04045: errors during recompilation/revalidation of MDSYS.SDO_ST_SYN_CREATE, ORA-01031: insufficient privileges (Doc ID 2144698.1)
|
216.73.216.200
|
|
|
|
Copyright 1999-2025 Zeroboard / skin by 최길호(gilho.kr@gmail.com)
|
|
|
07/03 