Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 sql developer ²éѯÏÔʾÖÐÎÄÂÒÂë

»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£ ......

PHP Á¬½ÓOracle ³ö´í

<?php
  getenv("ORACLE_HOME");
  $conn=ocilogon("test","test","test_db");
  if($conn)  
  echo success;  
&nb ......

½éÉÜOracleºÍmysqlµÄÊé - Oracle / ·Ç¼¼ÊõÇø

ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......

oracleµ¼Èë»Ø¹ö - Oracle / ¿ª·¢

abnormal end of export file
IMP-00028: partial import of previous table rolled back: 3828 rows rolled back
  
ÓÐûÓÐÒ»ÖÖ·½·¨Èõ¼Èë¼ÌÐø½øÐжø²»Òì³£Ìø³ö»Ø¹ö£¿
ignore=y

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