Re: invalid sys.views after installation

From: Sybrand Bakker <oradba_at_sybrandb.demon.nl>
Date: Wed, 19 Dec 2001 22:52:32 +0100
Message-ID: <b0322usjnjknnn1m4icecrl47s45ch3kjm@4ax.com>

On 13 Dec 2001 09:27:14 -0800, laloca_at_warum.net (laLocA) wrote:

>We moved (export/import) our 7.3.4 database to a new box with 8.1.7.
>(both NT)- everything worked fine - but I found some views invalid:
>
>ALL_HISTOGRAMS
>DBA_HISTOGRAMS
>USER_HISTOGRAMS
>DDAL_USERAUTH2
>DEF$_TRAN
>LOADER_COL_INFO
>LOADER_IND_INFO
>
>I checked the rdbms/admin - dir for the sql-scripts, but can't find
>the create view statements. I already searched on metalink, but can't
>find a solution.
>
>Any idea how to fix this would be highly appreciated.
>
>Thanks,
>
>Susanne

ALTER VIEW <viewname> COMPILE

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Dec 19 2001 - 15:52:32 CST