Home » SQL & PL/SQL » SQL & PL/SQL » Invalid Objects (Linux)
Invalid Objects [message #335896] Thu, 24 July 2008 02:07 Go to next message
altafhk
Messages: 45
Registered: June 2007
Location: Islamabad
Member

I had checked for invalid objects before. There was no invalid object in any schema. Now, from few days, I am getting them in PUBLIC schema then after recompiling - fine. See attachment.
Can anybody help me out in understanding?

Regards
Re: Invalid Objects [message #335901 is a reply to message #335896] Thu, 24 July 2008 02:16 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Which attachment?

Also always post your version (4 decimals).

Regards
Michel
Re: Invalid Objects [message #335930 is a reply to message #335896] Thu, 24 July 2008 03:24 Go to previous messageGo to next message
altafhk
Messages: 45
Registered: June 2007
Location: Islamabad
Member

Version 10.2.0.1
In public schema:
DBA_HIST_ACTIVE_SESS_HISTORY
DBA_HIST_DB_CACHE_ADVICE
DBA_HIST_DLM_MISC
DBA_HIST_FILESTATXS
DBA_HIST_INST_CACHE_TRANSFER
DBA_HIST_LATCH
DBA_HIST_LATCH_MISSES_SUMMARY
DBA_HIST_OSSTAT
DBA_HIST_PARAMETER
DBA_HIST_ROWCACHE_SUMMARY
DBA_HIST_SERVICE_STAT
DBA_HIST_SERVICE_WAIT_CLASS
DBA_HIST_SGASTAT
DBA_HIST_SQLBIND
DBA_HIST_SQLSTAT
DBA_HIST_SYSSTAT
DBA_HIST_SYSTEM_EVENT
DBA_HIST_SYS_TIME_MODEL
DBA_HIST_TABLESPACE_STAT
DBA_HIST_WAITSTAT

Thank you
Re: Invalid Objects [message #335936 is a reply to message #335930] Thu, 24 July 2008 03:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Check if the referenced objects exist.

Regards
Michel
Re: Invalid Objects [message #335950 is a reply to message #335936] Thu, 24 July 2008 04:15 Go to previous messageGo to next message
altafhk
Messages: 45
Registered: June 2007
Location: Islamabad
Member

There are synonyms of views of sys user but valid in sys and invalid in public schema.
Re: Invalid Objects [message #335974 is a reply to message #335950] Thu, 24 July 2008 05:13 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post the queries you executed and its result.
Before please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter) and align the columns in result.
Use the "Preview Message" button to verify.

Regards
Michel
Previous Topic: SQL Query - help needed
Next Topic: Query
Goto Forum:
  


Current Time: Sat Dec 10 05:17:41 CST 2016

Total time taken to generate the page: 0.06698 seconds