Re: invalid sys.views after installation

From: laLocA <laloca_at_warum.net>
Date: 21 Dec 2001 03:25:40 -0800
Message-ID: <52a4685.0112210325.5dbbadaa@posting.google.com>

>
>
> ALTER VIEW <viewname> COMPILE
>
> Hth
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address

I already tried to do:

SQL> alter view all_histograms compile;

Warning: View altered with compilation errors.

SQL> select name, text from all_errors;

NAME                           TEXT
------------------------------ ------------------------------
ALL_HISTOGRAMS                 ORA-00904: invalid column name
DBA_HISTOGRAMS                 ORA-00904: invalid column name
DEFCALLDEST                    ORA-00904: invalid column name
LOADER_COL_INFO                ORA-00904: invalid column name
LOADER_IND_INFO                ORA-00904: invalid column name
USER_HISTOGRAMS                ORA-00904: invalid column name

6 rows selected.

I also started the cat-scripts again - with no result. Any ideas where I can find the sources for this views to check which columns are invalid?

Thanks anyway and Merry Christmas!!!

Susanne Received on Fri Dec 21 2001 - 05:25:40 CST