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

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, ȨÏÞÈ·ÈϹýÁË¡£
Îļþ·¾¶Ò²ÊǶԵģ¬Òª²»¾ÍÌáʾÕÒ²»µ½ÎļþµÄ´íÎóÁË.


ÒýÓÃ
Äãµ¼ÈëµÄÓû§ÒªÓе¼ÈëȨÏÞ¡£¡£¡


Ïà¹ØÎÊ´ð£º

oracleÓëaix - Oracle / ¸ß¼¶¼¼Êõ

ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼­¾íºÅlv04 
#lslv -l lv04 ......

OracleµÄblob×Ö¶ÎÎÊÌâ - Oracle / ¿ª·¢

²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......

oracle ×Ô¶¨Òå·Ö×é - Oracle / »ù´¡ºÍ¹ÜÀí

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 °²×° 01092 ´íÎó - Oracle / »ù´¡ºÍ¹ÜÀí

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 / ......

oracle´¥·¢Æ÷²åÈëÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

ÎÒÓÐÁ½¸ö±í£¨A±íºÍB±í£©£¬»ú¹¹ÍêÈ«Ïàͬ£ºA ±í½¨Á¢´¥·¢Æ÷
µ±insert into A(id,name) values('1','zhangsan'); ÎÒÖ»Ï뽫name=zhangsanµÄʱºò½«insertÓï¾ä²åÈëµ½B±íÖжøA±í²»Ö´ÐвÙ×÷Õâ¸ö´¥·¢Æ÷Ó¦¸ÃÔõôʵÏÖÄØ£¿
È磺 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ