Tag Archive: Invalid Objects.sql

Sep 04

How do you check particular object of oracle database?

Sql Query: SET PAGESIZE 300 SET LINESIZE 150 COL OWNER FOR A25 COL OBJECT_NAME FOR A30 SELECT OWNER, OBJECT_NAME, OBJECT_TYPE, STATUS FROM DBA_OBJECTS WHERE OBJECT_NAME LIKE ‘%PRVT_WORKLOAD%’; Sample Output: OWNER OBJECT_NAME OBJECT_TYPE STATUS ————————- —————————— ——————- ——- SYS PRVT_WORKLOAD PACKAGE VALID SYS PRVT_WORKLOAD PACKAGE BODY INVALID SYS PRVT_WORKLOAD_NOPRIV PACKAGE VALID SYS PRVT_WORKLOAD_NOPRIV PACKAGE BODY VALID

Permanent link to this article: http://myappsdba.com/how-do-you-check-particular-object-of-oracle-database/

Sep 03

How do you check invalid objects in Oracle Database?

Sql Query: SET PAGESIZE 300 SET LINESIZE 150 col OWNER for a25 col OBJECT_NAME for a30 select OWNER, OBJECT_NAME, OBJECT_TYPE, STATUS from dba_objects where STATUS=’INVALID’; Sample Output: OWNER OBJECT_NAME OBJECT_TYPE STATUS ————————- —————————— ——————- ——- ORDSYS ORDIMG_PKG PACKAGE BODY INVALID ORDSYS ORDIMGEXTCODEC_PKG PACKAGE BODY INVALID SYS PRVT_WORKLOAD PACKAGE BODY INVALID

Permanent link to this article: http://myappsdba.com/how-do-you-check-invalid-objects-in-database/