|
|
[ÀϹÝ] export dump ¾ÈµÉ¶§ |
|
È£¼® ´Ô²²¼ ¾´ ±ÛÀÔ´Ï´Ù - 211.¢½.74.31 |
ÀÐÀ½:4294 |
|
|
exp system/test file=1.exp.dmp log=1.exp.log rows=y direct=y compress=n
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user SYSTEM
. 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
SELECT SUBSTR(comp_id,1,15) comp_id, status, SUBSTR(version,1,10) version, SUBSTR(comp_name,1,30) comp_name FROM dba_registry;
³ë¾ÆÄ«À̺ê¸ðµå¿¡¼ export ½Ã ¹ß»ýµÅ´Â ¿¡·¯ÀÔ´Ï´Ù...
character setÀÌ ¹®Á¦ÀÎ°Í °°Àºµ¥..
µ¥ÀÌŸº£À̽º »ý¼ºÇÒ¶§...À߸øÇؼ ´Ù¸¥ character setÀ¸·Î Çß´Ù°¡
US7ASCII À¸·Î ´Ù½Ã ¹Ù²å¾¹´Ï´Ù...
±×¸®°í °è¼Ó ¾Æ¹«¹®Á¦ ¾øÀÌ Àß µÆ¾ú´Âµ¥
export Á» ÇÏ·Á´Ï±î...ÀÌ·± ¹®Á¦°¡ ¹ß»ýÇϳ׿©..
ºÎŹµå¸³´Ï´Ù....
¾î¶»°Ô ÇØ¾ß export ÇÒ ¼ö ÀÖÀ»±î¿ä...
export done in US7ASCII character set US7ASCII NCHAR character set
.....
exp-00008 : oracle error 6552 encountered
ora-06552 : pl/sql : compilation unit analysis terminated
ora-06553 : psl-553 : character set name is not recognized
exp-00000 : export terminated unsuccessfully
ÀÌ ±Û¿¡ ´ëÇÑ ´ñ±ÛÀÌ ÃÑ 1°Ç ÀÖ½À´Ï´Ù.ȯ°æº¯¼öÁß NLS_LANGÀ» ¼¹ö¿Í ¸ÂÃ߽ðí
catproc.sqlÀ» Çѹøµ¹¸®½Å ÈÄ ´Ù½Ã½ÃµµÇغ¸½Ã°í
Á¤¾ÈµÇ¸é userº°·Î ¹Þ¾Æº¸¼¼¿ä.
±×¸®°í ¹öÁ¯È®ÀÎÇÏ½Ã°í ¹ö±×ÀÎÁöÈ®ÀÎÇغ¸¼¼¿ä
¹ö±×·Î ¿Ã¶ó¿ÍÀÖ´Â°Ô ²ÏÀÖ´õ±º¿ä.
$ORACLE_HOME/rdbms/admin/utlrp.sql
[oracle@localhost admin]$ chmod 744 $ORACLE_HOME/rdbms/admin/catalog.sql
[oracle@localhost admin]$ chmod 744 $ORACLE_HOME/rdbms/admin/catproc.sql
|
|
|
|
|
|