OraFAQ Forum: SQL & PL/SQL » how we resolve INVALID object

Home » SQL & PL/SQL » SQL & PL/SQL » how we resolve INVALID object (oracle 9i)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

how we resolve INVALID object [message #564058]

Tue, 21 August 2012 03:05

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.

Report message to a moderator

Re: how we resolve INVALID object [message #564062 is a reply to message #564058]

Tue, 21 August 2012 03:12

Michel Cadot
Messages: 54672
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

Report message to a moderator

Re: how we resolve INVALID object [message #564070 is a reply to message #564062]

Tue, 21 August 2012 04:24

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.

Report message to a moderator

Re: how we resolve INVALID object [message #564071 is a reply to message #564070]

Tue, 21 August 2012 04:42

Michel Cadot
Messages: 54672
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

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

Report message to a moderator

Re: how we resolve INVALID object [message #564109 is a reply to message #564106]

Tue, 21 August 2012 07:50

Michel Cadot
Messages: 54672
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

Report message to a moderator

Re: how we resolve INVALID object [message #570740 is a reply to message #564109]

Thu, 15 November 2012 04:45

umeshchandraseth
Messages: 60
Registered: June 2011
Location: new delhi

Member

hi sir,
how these objects become invalid in database.

Report message to a moderator

Re: how we resolve INVALID object [message #570750 is a reply to message #570740]

Thu, 15 November 2012 06:10

cookiemonster
Messages: 9284
Registered: September 2008
Location: Rainy Manchester

Senior Member

Objects become invalid when any other object they reference is changed.

Report message to a moderator

Re: how we resolve INVALID object [message #570751 is a reply to message #570750]

Thu, 15 November 2012 06:12

Michel Cadot
Messages: 54672
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Or any grant or revoke on it is done.

Regards
Michel

Report message to a moderator

Previous Topic:	Identify table row
Next Topic:	Generate movements

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jun 18 22:01:02 CDT 2013

Total time taken to generate the page: 0.10989 seconds