Re: DBA_tables REPOST

kkc_at_nauvax.ucc.nau.edu writes:
: YES! I have tried every combination of single, double, wildcard, like
: phrases, and everything else that works for a regular table that I have
: created. The thing is - there were scripts that were delivered with our
: application, written by someone else, that were designed to help us
: size our database and such. Well, none of them work because of this
: problem!
: select table_name from all_tables; (this works!)
: select table_name from all_tables where table_name = 'NBRBJLH';
: (this doesn't!)
: It only happens on the base tables and it always returns the line with
: the where statement in it. If you need any more clarification or examples
: please let me know!
:
: Thanks!
: Kathy Carmichael
: kcarmich_at_coco.cc.az.us

If you are getting an ORA-904, it is most likely not TABLE_NAME that it is complaining about.
Remember, that DBA_TABLES is a view not a table, and it is based upon the underlying DATA DICTIONARY OBJECTS owned by SYS.

It is possible that you may have recently upgraded your database, and the definitions of some of the underlying tables may have changed, necessitating the re-creation of your data dictionary views.s

I would recommend, that while connected as SYS, you run the CATALOG.SQL script(located in $ORACLE_HOME/rdbms/admin on UNIX systems).

This will re-create your dictionary views.

--
regards,
Carl
+-----------------------------------------------------------------------------+
Carl Gohringer, 
Oracle UK, The Oracle Centre, The Ring, Bracknell, Berkshire, England, RG121BW
Internet   : cgohring_at_uk.oracle.com    
+-----------------------------------------------------------------------------+