Oracle On Top

Blog where you will get many helpful queries to support your day to day work.

Shahid Mohammed

My photo
Shahid Mohammed
View my complete profile

Thursday, January 18, 2018

How to find invalid object in oracle

Query:
===================

set lines 300
col owner for a20
col OBJECT_NAME for a30
select owner,object_name,object_id,object_type,status,last_ddl_time,created from dba_objects where status='INVALID' order by owner;

Posted by Shahid Mohammed at 12:40 PM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Visitors

Total Pageviews

Blog Archive

  • ▼  2018 (15)
    • ►  April (1)
    • ►  February (2)
    • ▼  January (12)
      • How to check the processes limit in oracle
      • How to know patch information in oracle
      • How to get the extent information in oracle
      • How to check RMAN backup status in oracle
      • How to check rman sessions in oracle database
      • How to check SGA components size in oracle
      • How to check the shared pool usage in oracle
      • How to find invalid object in oracle
      • How to check blocking session in database
      • How to check component status in oracle
      • How to check standby lag
      • How to check restore points in oracle
  • ►  2016 (1)
    • ►  September (1)
  • ►  2015 (19)
    • ►  December (19)

Popular Posts

Watermark theme. Powered by Blogger.