우선 imp-0008 에러의 정의에 대해서 말씀드리겠습니다.
아래와 같이 export file이 corrupted 되거나 import의 인터널버그일 경우에
발생합니다. 경험으로는 export file을 다른서버로 옮길 때에 ftp를
사용하는데 default는 ASCII mode인데 그대로 ftp로 옮겼을 경우에는
export dump file이 corrupted됩니다. binary file로 dump file을 옮겨야하겠습니다

IMP-00008: "unrecognized statement in the export file: \n %s"
Cause: Unrecognized statement in export file. This could be due to
corrupted export file or Import internal bug.
Action: If the export file is corrupted, retry with a new export file.
Else report this as Import internal error.

이외에 나오는 에러는 없는지요?
검색을 해보기에는 imp-0008이 발생하는 버그 및 problem으로 등록된 것이
아래의 경우에 나와있습니다.

1) You may have hit Bug 257475.

This bug only occurs if you are exporting snapshots that contain references
to database links. Performing a 'strings' command on the export file will
confirm this.

2) export dump file을 분할했는데 import시 순서에 맞지 않게 지정했을 경우
IMP-00047: unexpected file sequence number; expected 2 but found 3
IMP-00132: first file in the multi-file export is exp_f1.dmp
IMP-00008: unrecognized statement in the export file:
...
IMP-00047: unexpected file sequence number; expected 3 but found 2
IMP-00132: first file in the multi-file export is exp_f1.dmp
IMP-00008: unrecognized statement in the export file:
...

3) export dump file을 분할했는데 import시에 잘못된 이름을 넣었을 경우
- specifying a non existing filename results in:
IMP-00002: failed to open [name_of_file] for read
- specifying a wrong filename results in:
IMP-00048: mismatched file header
IMP-00008: unrecognized statement in the export file:
or import will abort with:
IMP-00048: mismatched file header
IMP-00009: abnormal end of export file
Import terminated successfully with warnings.

3) 테이프 장치를 통해서 export file을 직접 direct로 export할 경우
테이프장치는 ANSI-labeled tapes만 지원됩니다.

" Export file created by via conventional path
. importing CE's objects into CE
IMP-00008: unrecognized statement in the export file:
00
"CREATE SEQUENCE "ASI_CE_ID_SEQ" MINVALUE 1 MAXVALUE
99999999999999999999999"
"9999 INCREMENT BY 1 START WITH 925520 CACHE 20 NOO"
IMP-00008: unrecognized statement in the export file:"

You can see this via the output of SHOW=Y on the import from the tape
directly
The Oracle Export utility is only supported for ANSI-labeled tapes.

4) license_max_users 파라미터에 지정된 값보다 많은 유저를 import하려
할 경우, default는 0으로 license limit을 안합니다.

In this case it was caused by the init.ora parameter license_max_users. The
parameter was set to 55. After increasing the parameter to the correct number
of users, the import was successful.

5) buffer부족시
만약 IMP-00032까지 나올 경우에는 buffer를 충분히 주고 import합니다.
ex) imp system/manager file=test.dmp full=y log=test.log buffer=
10000000

Export file created by EXPORT:V08.00.05 via conventional path
.
import done in US7ASCII character set and US7ASCII NCHAR character set
. importing OPS$ORACLE_CDR's objects into SYSTEM
IMP-00032: SQL statement exceeded buffer length
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file

6) Bug 4656020 - Export / import of schema based XMLType table fails
10.2.0.2 버젼에서 XML을 사용시 IMPORT시에 문제발생
10.2.0.3에서 FIX됨

Import of XML based tables may fail processing ALTER TABLE statements
subsequent to the CREATE TABLE for the subject tables. Import may also
issue "IMP-00008: unrecognized statement in the export file" errors.

7) Bug 2750878 IMPORT does not work for Schema based XMLTable in multibyte
9.2버젼에서 XML데이터를 import시에 발생
IMPORT does not work for Schema based XMLTable with a multibyte database.
Import fails with errors like:

IMP-00017: following statement failed with ORACLE error 6550:
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 13, column 14:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the
IMP-00008: unrecognized statement in the export file:

글 수정:
민천사 (민연홍)

제가 도서관에서 공부중이라..;; 도서관pc실..
이제 공부하러 가야한답니다.~ 저녁때나 글 올릴 수 있겠네요.

2011/06/16 20:43 2011/06/16 20:43

트랙백 주소 :: 이 글에는 트랙백을 보낼 수 없습니다