Database Administration (MOSC)

MOSC Banner

ora-00942: table or view does not exist

edited Jan 18, 2013 12:08AM in Database Administration (MOSC) 4 commentsAnswered
Recently we have upgraded from oracle 8i database to v10.0.2 after that we had an issue “ora-00942: table or view does not exist” while executing below sql via “radio emulator”( application) but it is working fine via sqlplus and mf cobol program. So we have changed the 07_dictionary_accessibility” value  “true” previously it was “fale” as this a default value of 10g.

 select decode (count (*), 0, 'f', 't') as have_bib_printed from sys.col where tname = 'sm1004_event_dtl' and cname = 'bib_printed’;

please clarify my doubts

1.       What is the impact if the o7_dictionary_accessibility set to “true” in 10.2.0.2.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center