The views are built IIRC by catalog.sql. This will exist in rdbms/admin in
the oracle8i home. perhaps you have accidentally run the v7 scripts?
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"laLocA" <laloca_at_warum.net> wrote in message
news:52a4685.0112210325.5dbbadaa_at_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:39:22 CST
