OS환경 : Oracle Linux6.8(64bit)
DB 환경 : Oracle Database 11.2.0.4
에러 : exp 실행 시 에러 발생
1 2 3 4 5 6 7 8 9 10 11 12 13 | $ exp system/oracle file=jsh.dmp owner=jsh; Export: Release 11.2.0.4.0 - Production on Tue Apr 24 14:38:37 2018 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. EXP-00056: ORACLE error 6550 encountered ORA-06550: line 1, column 15: PLS-00201: identifier 'SYS.DBMS_EXPORT_EXTENSION' must be declared ORA-06550: line 1, column 15: PL/SQL: Statement ignored EXP-00000: Export terminated unsuccessfully |
해결 방법 : catproc.sql 스크립트를 실행시켜 PL/SQL을 사용하는데 필요한 패키지 및 프로시져를 생성한다.
1 2 3 4 5 6 7 8 9 10 11 | $ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Tue Apr 24 16:42:23 2018 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, Real Application Clusters and Data Mining options SQL> @?/rdbms/admin/catproc.sql |
catproc.sql 정상 실행 후 exp 재실행
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 | $ exp system/oracle file=jsh.dmp owner=jsh; Export: Release 11.2.0.4.0 - Production on Tue Apr 24 16:44:23 2018 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP, Data Mining and Real Application Testing options Export done in US7ASCII character set and AL16UTF16 NCHAR character set server uses KO16MSWIN949 character set (possible charset conversion) About to export specified users ... . exporting pre-schema procedural objects and actions . exporting foreign function library names for user JSH . exporting PUBLIC type synonyms . exporting private type synonyms . exporting object type definitions for user JSH About to export JSH's objects ... . exporting database links . exporting sequence numbers . exporting cluster definitions . about to export JSH's tables via Conventional Path ... . . exporting table DEPT 4 rows exported . . exporting table EMP 14 rows exported . . exporting table EMP99 917504 rows exported . . exporting table SALGRADE 5 rows exported . exporting synonyms . exporting views . exporting stored procedures . exporting operators . exporting referential integrity constraints . exporting triggers . exporting indextypes . exporting bitmap, functional and extensible indexes . exporting posttables actions . exporting materialized views . exporting snapshot logs . exporting job queues . exporting refresh groups and children . exporting dimensions . exporting post-schema procedural objects and actions . exporting statistics Export terminated successfully without warnings. |
정상 수행됨
원인 : exp 관련 패키지가 설치되어 있지 않아서 발생하는 오류
참조 : http://positivemh.tistory.com/107
'ORACLE > Trouble Shooting' 카테고리의 다른 글
| ORA-01652: unable to extend temp segment by 128 in tablespace TEMP 해결 (0) | 2018.05.29 |
|---|---|
| ORA-00031: session marked for kill (0) | 2018.05.28 |
| $GRID_HOME/crf/db/<node name>/crfclust.bdb의 용량이 비정상적으로 커졌을 때 (0) | 2018.04.11 |
| ORA-00600, ORA-07445 를 만드는 방법 (2) | 2018.04.10 |
| ORA-19502: write error on file "/oracle/app/oracle/backup/orcl_08sv3j09_1_1", block number 154240 (block size=8192) (0) | 2018.03.30 |