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.