When exporting data from Oracle DB 9i 9.2.0.5, encountered by the error:
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user QLNS
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user QLNS
EXP-00008: ORACLE error 942 encountered
ORA-00942: table or view does not exist
EXP-00024: Export views not installed, please notify your DBA
EXP-00000: Export terminated unsuccessfully
Solution:
Run catalog.sql,catproc.sql and catexp.sql ( logged in as sys).
Then you should export as normal.
Regards,
Minh Tran