Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 10g webµÇ½EMµÄÎÊÌ⣿ - Oracle / »ù´¡ºÍ¹ÜÀí

°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿

1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

oracle²¢·¢´¦ÀíSOS - Oracle / ¿ª·¢

ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾ­ºÜ³ÉÊìÁË

ÒýÓÃ
oracle ......

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ÊÂÎñ¸ôÀë¼¶±ðÎÊÌâ - Oracle / ·Ç¼¼ÊõÇø

²é¿´ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁ
MySQLʹÓõÄÊÇselect @@tx_isolation;
ÔÚOracleÖв鿴ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁîÊÇÄĸö£¿

SQL code:

SELECT /*+ rule */ s.username,decode(l.type,'TM','TABLE LOCK','TX','ROW LOCK', ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ