|
|
[ÀϹÝ] export dump ¾ÈµÉ¶§ |
|
È£¼® ´Ô²²¼ ¾´ ±ÛÀÔ´Ï´Ù - 211.¢½.74.31 |
ÀÐÀ½:5129 |
|
|
export¿¡·¯ EXP-00008 ORA-06552 | ¹é¾÷ 2005/12/06 19:38
http://blog.naver.com/addibuddi/20146193
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user AAAA
. exporting PUBLIC type synonyms
EXP-00008: ORACLE error 6552 encountered
ORA-06552: PL/SQL: Compilation unit analysis terminated
ORA-06553: PLS-553: character set name is not recognized
EXP-00000: Export terminated unsuccessfully
jvmÀ» Áö¿ì¸é µÈ´Ù´Âµ¥... ¤Ñ¤Ñ;;
¹æ¹ý1>> Àû¿ëÀ» ÇßÀ»¶§ ÇØ°áµÈ ¹æ¹ý.. jvmÀ» »èÁ¦Çϸé java¿ÀºêÁ§Æ®¸¦ ¸ø¾²Áö ¾ÊÀ»±î¶ó´Â °ÆÁ¤..
export ¹é¾÷ ¹Þ´Ù°¡...
-------------------------------------------------------------------------------
exp USERID=userid/userpw FILE=/oracle/test.dmp INDEXES=N ROWS=Y OWER=userid LOG=/oracle/test.log
Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit
Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
Export done in ZHS16GBK character set and UTF8 NCHAR character set
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user GMCC_EDIS
. exporting PUBLIC type synonyms
EXP-00008: ORACLE error 6552 encountered
ORA-06552: PL/SQL: Compilation unit analysis terminated
ORA-06553: PLS-553: character set name is not recognized
EXP-00000: Export terminated unsuccessfully
-------------------------------------------------------------------------------
¹é¾÷ÇÏ´Ù°¡ À§¿Í °°ÀÌ ¿¡·¯°¡ ³¯¶§°¡ ÀÖ½À´Ï´Ù.
¤Ñ¤Ñ; »ðÁú ¸¹ÀÌ Çߴµ¥... ã¾Æº¸´Ï ÀÌ·± ¹æ¹ýÀÌ ÀÖ´õ±º¿ä.
sysdba·Î µé¾î°¡¼
@/home/oracle/ora81/javavm/install/rmjvm.sql
ÀÌ·¸°Ô Çؼ JVM µå·Ó½ÃÄÑÁÖ¸é µË´Ï´Ù.
½Ã°£ÀÌ Á» °É¸®´Ï ±â´Ù·ÁÁֽʽÿÀ.
¹æ¹ý2>>
9.2.0.1¿¡¼ 9.2.07 ÆÐÄ¡ ÈÄ ¹ß»ýÇÏ´Â ¹®Á¦Áß °æÇèÇÑ ³»¿ë
export ¾ÈµÉ¶§ ... $ORACLE_HOME/Rdbms/admin/catexp.sql½ÇÇàÇÒ°Í
¹®Á¦Á¡:
exp-00008 : ¿À¶óŬ ¿À·ù 4020°¡ ¹ß»ýÇß½À´Ï´Ù.
ora-04020 : °´Ã¼ sys.dbms_refresh_xp_sites.schema_info_exp(À»)¸¦ È£ÃâÇÒ ¶§ ¹ß»ýµÇ¾ú½À´Ï´Ù. exp-00083 : ÀÌÀü ¹®Á¦°¡ sys.dbms_refresh_xp_sites.schema_info_exp(À»)¸¦ È£ÃâÇÒ ¶§ ¹ß»ýµÇ¾ú½À´Ï´Ù.
sys.cdc_alter_ctable_before ÀÇ Àá±Ý ½ÃµµÁß ±³Âø »óÅ°¡ °ËÃâµÇ¾ú½À´Ï´Ù.
µîÀÇ ¿À·ù·Î ¹é¾÷ÀÌ ¾ÈµÇ´Â °æ¿ì
ÇØ°áÃ¥
ÆÐÄ¡½Ã catalog.sql , catproc.sqlÀÌ µ¹¸é¼ ÀϺΠÆÐÅ°ÁöµéÀÌ invalid »óÅ°¡ µÇ±â ¶§¹«
±âº»ÀûÀ¸·Î ¿À¶óŬÀÌ ÀÚµ¿À¸·Î ÄÄÆÄÀÏÇϴµ¥ À̶§ ÇØ´ç ÆÐÅ°Áö¸¦ ¶ô(lock)ÇÏ°Ô µË´Ï´Ù.
À̶§ ´Ù¸¥ ¸î¸î À¯ÀúµéÀÌ invalid µÈ ÇØ´ç ÆÐÅ°Áö¸¦ »ç¿ëÇÏ·Á°í ÇÏ¸é¼ dead lock(±³Âø»óÅÂ)ÀÌ ¹ß»ýÇÒ ¼öµµ ÀÖ½À´Ï´Ù.
1. select count(*) from dba_objects where status='invalid';
¸¦ ¼öÇàÇؼ invalid µÈ object¸¦ ã¾Æ compileÀ» ´Ù½Ã ÇØÁÖ´Â ¹æ¹ý
2. $ORACLE_HOME/rdbms/admin/utlrp.sql ½ÇÇà
¹æ¹ý3>>
export½Ã EXP-00008 ORA-06553 PLS-00213 EXP-00222 Error¿¡ °üÇÏ¿©
PLS-00213: package STANDARD not accessibleÀÇ °æ¿ì
PL/SQL Compiler°¡ ÇöÀç DB¿¡¼ STANDARD Package
¸¦ ãÀ»¼ö ¾øÀ»¶§ ³ª´Â ¿¡·¯ÀÔ´Ï´Ù.
Á¶Ä¡¹æ¹ýÀº ¾Æ·¡¿Í ??½À´Ï´Ù.
1. ÀÏ´Ü $ORACLE_HOME/rdbms/admin Directory·Î À̵¿
cd $ORACLE_HOME/rdbms/admin
2. SYS User³ª Connect internal·Î DBÁ¢¼Ó
sqlplus sys/<password>
3. catproc.sqlÀ» ½ÇÇà
SQL> @catproc
|
|
|
|
|
|