Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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Á¬½ÓɶÕâô¸´ÔÓ°¡.
oracle 10g
ÓÃps/sql devÔõôҲÁ¬²»ÉÏ.
ÓÃsqlplus¿ÉÒԵǽ.net manager֮ǰ²âÊÔÁ¬½ÓÁ˳ɹ¦µÄ.ÏÖÔÚ¸ãµÃÒ²Á¬½Ó²»ÁË.
listener.ora:
SID_LIST_LISTENER =
  (SID_LIST =
  ......

oracle ·¢Óʼþ´íÎó

ÏÂÃæ´æ´¢¹ý³ÌÖ´ÐкóÓдíÎó£¬
create or replace procedure test_mail(msg_subject in varchar2,
                            mes_co ......

Oracle Êý¾Ýµ¼³öÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......

Âé·³¸ø¿´¿´Õâ¸öoracleÓï¾ä¸ÃÔõÑùд

±íÃû£ºgk_record_new£¨ÕâÊÇÒ»¸ö¿¼ÇÚ±í£¬ËùÓÐÔ±¹¤µÄ¿¼ÇÚÊý¾Ý¶¼´æ·ÅÔÚÕâ¸ö±íÀÖ÷¼üΪ¿¨ºÅºÍʱ¼ä£©
±í½á¹¹£º
¿¨ºÅ£ºNUMBER(10)
»ùÕ¾£ºVARCHAR2(20)
ʱ¼ä£ºDATE
³öÈë±êÖ¾£ºVARCHAR2(1)
±íÊý¾Ý
¿¨ºÅ »ùÕ¾ ʱ¼ä ³ ......

ÓüÇʱ¾²é¿´Oracle¿ØÖÆÎļþ

ÎÒÓõÄÊÇNTϵͳ£¬µ±ÎÒÓüÇʱ¾²é¿´¿ØÖÆÎʼþʱ£¬×ÜÊÇÒ»´ó¶ÑÂÒÂ룬ÎÒ¸ÃÔõÑù²éѯ²¢¸Ä±ä¿ØÖÆÎļþÀïµÄÄÚÈÝÄØ£¿
2½øÖÆ ÓüÇʱ¾´ò¿ªµ±È»ÊÇÂÒÂë¿©

ÄÇÓÃʲô´ò¿ªÄØ£¿ÓÖÔõÑù´ò¿ªÄØ
£¿

¿ØÖÆÎļþÊǶþ½øÖÆÎļþ£¡

Ò»°ã ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ