Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Status is not 'VALID' for one TYPE in SYS !!!

Re: Status is not 'VALID' for one TYPE in SYS !!!

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Tue, 17 Sep 2002 18:53:44 +0200
Message-ID: <jeneou852jn973r2oqjmbh7i2dl63oe2li@4ax.com>


On Tue, 17 Sep 2002 09:48:09 +0200, "Epicentre team A" <oracle_at_epicentre.fr> wrote:

>Hi
>
>
>AQ$_SUBSCRIBERS type in SYS isn't VALID !!!
>It's curious. Problem is that full export is not working properly
>
>Info: Oracle version is 8.0.5
>Platform: NT4 Server
>
>
>Thanks for your ideas
>Denis Jeanneret
>

My idea is you are running a version of Oracle that has been desupported more than a year ago.
Also you can easily compile invalid views. Please refer to the ALTER VIEW command for details.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Sep 17 2002 - 11:53:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US