»óȲ : ¿À¶óŬ 8.0 ¹× ¿À¶óŬ 8i ¿¡¼ exp ÇÑ dumpÆÄÀÏÀ»
¿À¶óŬ 9i 9.2.0.4 (release 2 ¼³Ä¡ ÈÄ ÆÐÄ¡¼Â 3 Àû¿ë) µ¥ÀÌÅͺ£À̽º¿¡
imp ½ÃŲ ÈÄ....
µ¥ÀÌÅͺ£À̽º Á¤±â¹é¾÷À» À§Çؼ exp¸¦ ½ÇÇàÇÑ ÈÄ ´ÙÀ½°ú °°Àº ¸Þ½ÃÁö¸¦
º¸À̸ç exp°¡ Á¤ÁöÇÑ´Ù.
( ¹®Á¦ 1 )
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 US7ASCII character set and AL16UTF16 NCHAR character set
server uses KO16KSC5601 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
( ¹®Á¦ 1 ÇØ°áÃ¥ )
À§ ¹®Á¦´Â ¿À¶óŬ ÇÏÀ§¹öÀü ´ýÇÁ¸¦ »óÀ§¹öÀü¿¡ imp ½ÃÄ×À» °æ¿ì¿¡
¹ß»ýÇϸç $ORACLE_HOME/rdbms/admin/catexp.sql À»
±¸µ¿½ÃÅ°¸é ÇØ°áµÈ´Ù.
root# su - oracle
oracle$ sqlplus '/ as sysdba'
sql> start rdbms/admin/catexp.sql
( ¹®Á¦ 2 )
À§¿Í °°Àº »óȲ¿¡¼
exp ½ÇÇà½Ã ´ÙÀ½°ú °°Àº ¿¡·¯¸¦ º¸À̸ç exp°¡ Á¤ÁöÇÑ´Ù.
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 US7ASCII character set and AL16UTF16 NCHAR character set
server uses KO16KSC5601 character set (possible charset conversion)
About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions
. exporting system procedural objects and actions
. exporting pre-schema procedural objects and actions
. exporting cluster definitions
EXP-00056: ORACLE error 31600 encountered
ORA-31600: invalid input value EMIT_SCHEMA for parameter NAME in function SET_TRANSFORM_PARAM
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA_INT", line 3926
ORA-06512: at "SYS.DBMS_METADATA_INT", line 4050
ORA-06512: at "SYS.DBMS_METADATA", line 836
ORA-06512: at line 1
EXP-00056: ORACLE error 31600 encountered
ORA-31600: invalid input value EMIT_SCHEMA for parameter NAME in function SET_TRANSFORM_PARAM
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA_INT", line 3926
ORA-06512: at "SYS.DBMS_METADATA_INT", line 4050
ORA-06512: at "SYS.DBMS_METADATA", line 836
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully
À§ ¹®Á¦´Â ÆÐÄ¡¼Â3 Àû¿ëÈÄ¿¡ ¹ß»ýÇϸç
$ORACLE_HOME/rdbms/admin/catpatch.sqlÀ» ½ÇÇà½ÃÅ°¸é ÇØ°áµÈ´Ù.
root# su - oracle
oracle$ sqlplus '/ as sysdba'
sql> start rdbms/admin/catpatch.sql
|