[Go to site: main page, start]
Scribd
Upload
4 views1 page

Fixing Invalid Database Objects Queries

The document contains SQL queries that generate commands to validate or resolve invalid database objects. The first two queries focus on validating 'EVALUATION CONTEXT' objects and all invalid objects, respectively, while the last query aims to resolve invalid 'JAVA CLASS' objects. These commands are intended for database maintenance and ensuring object integrity.

Uploaded by

m.mizan031
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
4 views1 page

Fixing Invalid Database Objects Queries

The document contains SQL queries that generate commands to validate or resolve invalid database objects. The first two queries focus on validating 'EVALUATION CONTEXT' objects and all invalid objects, respectively, while the last query aims to resolve invalid 'JAVA CLASS' objects. These commands are intended for database maintenance and ensuring object integrity.

Uploaded by

m.mizan031
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

SELECT 'exec dbms_ruleadm_internal.validate_re_object('||''''||OWNER ||'.

'||
OBJECT_NAME ||''','|| NAMESPACE ||' ) ;'
FROM DBA_OBJECTS
where STATUS='INVALID'
and OBJECT_TYPE='EVALUATION CONTEXT'

SELECT 'exec dbms_ruleadm_internal.validate_re_object('||''''||OWNER ||'.'||


OBJECT_NAME ||''','|| NAMESPACE ||' ) ;'
FROM DBA_OBJECTS
where STATUS='INVALID'

/* Formatted on 3/11/2025 11:20:32 AM (QP5 v5.388) */


SELECT 'ALTER JAVA CLASS "' || object_name || '" RESOLVE;'
FROM user_objects
WHERE object_type = 'JAVA CLASS' AND status = 'INVALID';

You might also like