oracle dmpÎļþµ¼Èë³ö´í ²»ÖªµÀΪʲô~
½ñÌìÅóÓѸøÎÒÒ»¸öBMPÎļþ£¬¸æËßÎÒÊÇ oracleµÄÎļþ £¬½á¹ûÎÒÓÃoracleµ¼Èëʱ·¢ÏÖ¸ù±¾µ¼²»½øÈ¥£¬ÓкܶàÌáʾ ¾ßÌåÌáʾ̫¶à ÎÒÓÃÍøÅÌ´åÉÏÁËÇë´óϺ°ïæ~£¡
ÊÇTXTÎļþ£º
http://d.namipan.com/d/252e6ab47367af559f72d0e8ae7ab3ce1f1e609f4acb0200
Ŷ¶Ô ÁË ÎÒÓõĿͻ§¶ËÈí¼þÊÇ TOAD ²»ÖªµÀÊDz»ÊÇÕâ¸öÔÒò
ÊDZ¸·ÝÎļþÂð£¿
ÄãÔõôµ¼ÈëµÄ£¿ËµËµ¾ßÌå²½Öè
ÓÃTOAD µÇ½ DBA--DATA Import/Export--Import Utility Wizard --Ñ¡ÔñImport all tables from user SYSTEM To user SYSTEM -- ÍùϾͶ¼ÊÇĬÈÏÁË È»ºó³öµÄ ÄÇЩ´íÎó ¿´ÉÏÈ¥²»ÏñÊǰ汾²»¼æÈݵÄÎÊÌâ°¡~
Ó¦¸Ã²»ÊDZ¸·ÝÎļþ ÒòΪ Êý¾ÝÎļþÔÀ´ÊÇÈ˵ÄÒ»¸öÈí¼þÓÃµÄ µ½±ðµÄ»úÆ÷ÉÏû·¨ÅäÖÃÈí¼þËùÒÔÖ»ÄÜÖ±½Ó´ò¿ªËûµÄÊý¾Ý¿âÎļþ ÕÒÄÚÈÝ¡£µ±Ê±¸æËßÎÒÁË ÓÃORACLE ÄÜ´ò¿ªµÄ¡£
¶¥µ½100·Ö Çë¸÷λ´óϺ°ïæ°¡
²»ÊDZ¸·ÝÎļþ°¡ Ó¦¸ÃÊÇdmpÎļþ°É
Â¥Ö÷µÄBMPÎļþÓжà´ó£¿¡¡Ã»¼û¹ýÕâÖÖ¸ñʽµÄ±¸·Ý..
Â¥Ö÷È·Èϲ»ÊÇdmp£¿
IMP-00017: ÓÉÓÚ ORACLE µÄ 23327 ´íÎó£¬ÒÔϵÄÓï¾äʧ°Ü
"BEGIN SYS.DBMS_DEFER_IMPORT_INTERNAL.QUEUE_IMPORT_CHECK('ORCL.US.ORACLE.C"
"OM','IBMPC/WIN_NT-8.1.0'); END;"
IMP-00003: Óöµ½ ORACLE ´íÎó 23327
ORA-23327: µ¼ÈëµÄÑÓ³Ù rpc Êý¾ÝÓëµ¼Èë db µÄGLOBAL NAME²»Æ¥Åä
SQL code:
ORA-23327: imported deferred rpc data doe
Ïà¹ØÎÊ´ð£º
oracleÁ¬½ÓɶÕâô¸´ÔÓ°¡.
oracle 10g
ÓÃps/sql devÔõôҲÁ¬²»ÉÏ.
ÓÃsqlplus¿ÉÒԵǽ.net manager֮ǰ²âÊÔÁ¬½ÓÁ˳ɹ¦µÄ.ÏÖÔÚ¸ãµÃÒ²Á¬½Ó²»ÁË.
listener.ora:
SID_LIST_LISTENER =
(SID_LIST =
......
ÏÂÃæ´æ´¢¹ý³ÌÖ´ÐкóÓдíÎó£¬
create or replace procedure test_mail(msg_subject in varchar2,
mes_co ......
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
±íÃû£ºgk_record_new£¨ÕâÊÇÒ»¸ö¿¼ÇÚ±í£¬ËùÓÐÔ±¹¤µÄ¿¼ÇÚÊý¾Ý¶¼´æ·ÅÔÚÕâ¸ö±íÀÖ÷¼üΪ¿¨ºÅºÍʱ¼ä£©
±í½á¹¹£º
¿¨ºÅ£ºNUMBER(10)
»ùÕ¾£ºVARCHAR2(20)
ʱ¼ä£ºDATE
³öÈë±êÖ¾£ºVARCHAR2(1)
±íÊý¾Ý
¿¨ºÅ »ùÕ¾ ʱ¼ä ³ ......
ÎÒÓõÄÊÇNTϵͳ£¬µ±ÎÒÓüÇʱ¾²é¿´¿ØÖÆÎʼþʱ£¬×ÜÊÇÒ»´ó¶ÑÂÒÂ룬ÎÒ¸ÃÔõÑù²éѯ²¢¸Ä±ä¿ØÖÆÎļþÀïµÄÄÚÈÝÄØ£¿
2½øÖÆ ÓüÇʱ¾´ò¿ªµ±È»ÊÇÂÒÂë¿©
ÄÇÓÃʲô´ò¿ªÄØ£¿ÓÖÔõÑù´ò¿ªÄØ
£¿
¿ØÖÆÎļþÊǶþ½øÖÆÎļþ£¡
Ò»°ã ......