Home » SQL & PL/SQL » SQL & PL/SQL » how we resolve INVALID object (oracle 9i)
how we resolve INVALID object [message #564058] Tue, 21 August 2012 03:05 Go to next message
umeshchandraseth
Messages: 60
Registered: June 2011
Location: new delhi
Member
Hi All,

i am using oracle 9i database.i have face one problem their
when i am running this query i got one increment in object type.
query is this

select do.owner,count(do.owner) from dba_objects do where do.status='INVALID' group by do.owner

i got one increment in count of owner group by owner
this object type is MATERIALIZED VIEW.
how can we solve it parmanently.

please help
thanks.
Re: how we resolve INVALID object [message #564062 is a reply to message #564058] Tue, 21 August 2012 03:12 Go to previous messageGo to next message
Michel Cadot
Messages: 57601
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
i got one increment in count of owner group by owner


What does that mean?

Quote:
how can we solve it parmanently.


Drop the materialized view.

Regards
Michel
Re: how we resolve INVALID object [message #564070 is a reply to message #564062] Tue, 21 August 2012 04:24 Go to previous messageGo to next message
umeshchandraseth
Messages: 60
Registered: June 2011
Location: new delhi
Member
hello sir,
here many materlized view .we can't drop it
it may particular materlized view important for us.
Re: how we resolve INVALID object [message #564071 is a reply to message #564070] Tue, 21 August 2012 04:42 Go to previous messageGo to next message
Michel Cadot
Messages: 57601
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If there are invalid then you can't use them so they can't be so important.

Regards
Michel

[Updated on: Tue, 21 August 2012 04:43]

Report message to a moderator

Re: how we resolve INVALID object [message #564106 is a reply to message #564071] Tue, 21 August 2012 07:31 Go to previous messageGo to next message
umeshchandraseth
Messages: 60
Registered: June 2011
Location: new delhi
Member
it is not solution sir,
you are expert and i hope you can solve it.
thanks
Re: how we resolve INVALID object [message #564109 is a reply to message #564106] Tue, 21 August 2012 07:50 Go to previous messageGo to next message
Michel Cadot
Messages: 57601
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Insufficient information to compute.
Gave the only solution with the information you gave.

Regards
Michel
Re: how we resolve INVALID object [message #570740 is a reply to message #564109] Thu, 15 November 2012 04:45 Go to previous messageGo to next message
umeshchandraseth
Messages: 60
Registered: June 2011
Location: new delhi
Member
hi sir,
how these objects become invalid in database.
Re: how we resolve INVALID object [message #570750 is a reply to message #570740] Thu, 15 November 2012 06:10 Go to previous messageGo to next message
cookiemonster
Messages: 10571
Registered: September 2008
Location: Rainy Manchester
Senior Member
Objects become invalid when any other object they reference is changed.
Re: how we resolve INVALID object [message #570751 is a reply to message #570750] Thu, 15 November 2012 06:12 Go to previous message
Michel Cadot
Messages: 57601
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Or any grant or revoke on it is done.

Regards
Michel
Previous Topic: Identify table row
Next Topic: Generate movements
Goto Forum:
  


Current Time: Wed Apr 16 09:51:36 CDT 2014

Total time taken to generate the page: 0.09474 seconds