헤르메스 LIFE

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

Database

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

헤르메스의날개 2020. 11. 18. 23:38
728x90

참고 : 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 

 

 

 

 

 

 

728x90

'Database' 카테고리의 다른 글

[MySQL] root 패스워드 분실  (0) 2020.11.18
[Oracle] 대량 Insert 예제  (0) 2020.11.18
[Import] Oracle 11g -> Oracle XE 11.2 오류해결  (0) 2020.11.18
[Oracle] 달력 쿼리 셈플  (0) 2016.06.07
[Oracle] 연속된 날짜 생성 쿼리  (0) 2016.04.25