oracleµÄ10.2dmpÎļþµ¼ÈëÎÊÌâ,Óгêл¡£
ÈçÌâÄ¿, ÎÒÓÐÒ»¸ö±ðÈ˵ÄoracleÊý¾Ý¿âEXP³öÀ´µÄ.DMPÎļþ£¬ ÎÒ×Ô¼ºµ¼Èë,ʧ°Ü£¿´íÎóÐÅÏ¢----->>> ¶ÁÈ¡µ¼ÈëÎļþ ORA-31619: ת´¢Îļþ "c:\ora\PTRC_oracle_database.dmp" ÎÞЧ ʱ³öÏÖÎÊÌâ¡£ ÎÒÅóÓѵ¼Èë,¾Ý˵Ëû´´½¨ÁËÒ»¸ö³¬¼¶Óû§,·¢ÏÖÓкܶàÓû§ºÍ±í¿Õ¼ä. ²»ÖªµÀÕâÀïµÄÅóÓÑÓа취ûÓÐ.×îºÃÊÇÔÚÉϺ£µÄÅóÓÑ, Óгêл,²»¹ý²»ÊǺܶà.
ÊDz»Êǰ汾µÄÎÊÌ⠻ظ´ÄÚÈÝÌ«¶ÌÁË£¡ ת´¢Îļþ "c:\ora\PTRC_oracle_database.dmp" ÎÞЧ? -------------- ÄãÈ·ÈϸÃÎļþºÃʹ£¿ Äãµ¼ÈëµÄÓû§ÒªÓе¼ÈëȨÏÞ¡£¡£¡£ Îļþ·¾¶Òª¶Ô¡£¡£¡£ ÒªÊÇ¿ÉÒÔ²Ù×÷,ÎÒ¸øÄ㿪Զ³Ì. »òÕß°ÑDMP·Åµ½Ò»¸öÍøÂçÓ²ÅÌ¿ÉÒÔÏÂÔØ. Ö÷ÒªÊÇÏëÔÚÉϺ£·½±ãЩ. Ö±½ÓÔ¼Ò»¸öµØ·½,ÏÖ³¡¾ÍÄܲÙ×÷ÁË. Ô¶³Ì±È½ÏÂ鷳Ĩ. ±ðÈËÅÂÎÒ²»¶ÒÏÖ, ÎÒÓÖ²»ÖªµÀ±ðÈËÄÜ×öºÃ²».ºÇºÇ. ÒýÓà ÉϺ£µÄÅóÓÑ£¬³å°¡¡£Õ¦ºÃʶ¼ÂÖ²»µ½°³ÄØ¡¡ // *Cause: Either the file was not generated by Export or it was corrupted. // *Action: If the file was indeed generated by Export, report this as an // Import bug and submit the export file to Oracle Customer Support. 1 ¼ì²éÎļþÊÇ·ñË𻵣¨Èç´«Êä¹ý³ÌÖУ©£¬´óСÊÇ·ñÒ»Ö¡£ 2 ¼ì²éIMP°æ±¾ÊÇ·ñ>=EXP°æ±¾¡£ ÎÒ×Ô¼ºÓõÄsystem, ȨÏÞÈ·ÈϹýÁË¡£ Îļþ·¾¶Ò²ÊǶԵģ¬Òª²»¾ÍÌáʾÕÒ²»µ½ÎļþµÄ´íÎóÁË. ÒýÓà Äãµ¼ÈëµÄÓû§ÒªÓе¼ÈëȨÏÞ¡£¡£¡
Ïà¹ØÎÊ´ð£º
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó #topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬ Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04 #lslv -l lv04
......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
select sum£¨a.t)from ta a group by ta.a,ÕâÌõÓï¾ä½«±ítaÖеÄÊý¾Ý°´ÕÕa×ֶηÖ×é»ã×Üt×ֶΡ£ ½á¹û±ÈÈ磺 3 30 4 50 ÎÒÏëµÃµ½Õâ¸ö½á¹û£º 1 0 2 0 3 30 4 50 5 0 Õâ¸ö½á¹û£¬ÇëÎÊsqlÓï¾äÔõôд£¿¶àл nobody ......
oracle 11g °²×° 01092 ´íÎó, ÈÕÖ¾ÐÅÏ¢£º [oracle@linux trace]$ vi alert_orcl.log MMON started with pid=14, OS id=9089 RESETLOGS after incomplete recovery UNTIL CHANGE 522752 Errors in file / ......
ÎÒÓÐÁ½¸ö±í£¨A±íºÍB±í£©£¬»ú¹¹ÍêÈ«Ïàͬ£ºA ±í½¨Á¢´¥·¢Æ÷ µ±insert into A(id,name) values('1','zhangsan'); ÎÒÖ»Ï뽫name=zhangsanµÄʱºò½«insertÓï¾ä²åÈëµ½B±íÖжøA±í²»Ö´ÐвÙ×÷Õâ¸ö´¥·¢Æ÷Ó¦¸ÃÔõôʵÏÖÄØ£¿ È磺 ......