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 -> invalid sys.views after installation

invalid sys.views after installation

From: laLocA <laloca_at_warum.net>
Date: 13 Dec 2001 09:27:14 -0800
Message-ID: <52a4685.0112130927.2477a859@posting.google.com>

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 Received on Thu Dec 13 2001 - 11:27:14 CST

Original text of this message

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