[Oracle] IMP/EXP 시 에러 발생 (EXP-00008)

참고 : http://tylee82.tistory.com/116

 

export를 실행하는데 아래와 같은 에러가 발생하였다. 

 

[oracle@CentOS5DBserver ~]$ exp ID/pwass@TEST_SERVERfile=TESTDB090617.dmp log=TESTDB090617.log  Export: Release 9.2.0.4.0 - Production on Tue Jun 16 09:24:42 2009    Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.    Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production  With the Partitioning, OLAP and Oracle Data Mining options  JServer Release 9.2.0.1.0 - Production  Export done in US7ASCII character set and AL16UTF16 NCHAR character set  server uses JA16EUC character set (possible charset conversion)    About to export specified users ...  . exporting pre-schema procedural objects and actions  . exporting foreign function library names for user TEST  . exporting PUBLIC type synonyms  . exporting private type synonyms  . exporting object type definitions for user TEST  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

 

위 문제는 오라클 버젼이 다를 경우에 발생하며 $ORACLE_HOME/rdbms/admin/catexp.sql 을 구동시키면 해결된다. 

root# su - oracle   

oracle$ sqlplus '/ as sysdba'   

sql> start /opt/oracle/920/rdbms/admin/catexp.sql