oracleµÄ10.2dmpÎļþµ¼ÈëÎÊÌâ,Óгêл¡£
ÈçÌâÄ¿, ÎÒÓÐÒ»¸ö±ðÈ˵ÄoracleÊý¾Ý¿âEXP³öÀ´µÄ.DMPÎļþ£¬
ÎÒ×Ô¼ºµ¼Èë,ʧ°Ü£¿´íÎóÐÅÏ¢----->>>
¶ÁÈ¡µ¼ÈëÎļþ ORA-31619: ת´¢Îļþ "c:\ora\PTRC_oracle_database.dmp" ÎÞЧ ʱ³öÏÖÎÊÌâ¡£
ÎÒÅóÓѵ¼Èë,¾Ý˵Ëû´´½¨ÁËÒ»¸ö³¬¼¶Óû§,·¢ÏÖÓкܶàÓû§ºÍ±í¿Õ¼ä.
²»ÖªµÀÕâÀïµÄÅóÓÑÓа취ûÓÐ.×îºÃÊÇÔÚÉϺ£µÄÅóÓÑ, Óгêл,²»¹ý²»ÊǺܶà.
ÊDz»Êǰ汾µÄÎÊÌâ
»Ø¸´ÄÚÈÝÌ«¶ÌÁË£¡
ת´¢Îļþ "c:\ora\PTRC_oracle_database.dmp" ÎÞЧ?
--------------
ÄãÈ·ÈϸÃÎļþºÃʹ£¿
Äãµ¼ÈëµÄÓû§ÒªÓе¼ÈëȨÏÞ¡£¡£¡£
Îļþ·¾¶Òª¶Ô¡£¡£¡£
ÒªÊÇ¿ÉÒÔ²Ù×÷,ÎÒ¸øÄ㿪Զ³Ì. »òÕß°ÑDMP·Åµ½Ò»¸öÍøÂçÓ²ÅÌ¿ÉÒÔÏÂÔØ.
Ö÷ÒªÊÇÏëÔÚÉϺ£·½±ãЩ.
Ö±½ÓÔ¼Ò»¸öµØ·½,ÏÖ³¡¾ÍÄܲÙ×÷ÁË. Ô¶³Ì±È½ÏÂ鷳Ĩ.
±ðÈËÅÂÎÒ²»¶ÒÏÖ, ÎÒÓÖ²»ÖªµÀ±ðÈËÄÜ×öºÃ²».ºÇºÇ.
ÎÒ×Ô¼ºÓõÄsystem, ȨÏÞÈ·ÈϹýÁË¡£
Îļþ·¾¶Ò²ÊǶԵģ¬Òª²»¾ÍÌáʾÕÒ²»µ½ÎļþµÄ´íÎóÁË.
Ïà¹ØÎÊ´ð£º
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°Ñ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 ......
²é¿´ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁ
MySQLʹÓõÄÊÇselect @@tx_isolation;
ÔÚOracleÖв鿴ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁîÊÇÄĸö£¿
SQL code:
SELECT /*+ rule */ s.username,decode(l.type,'TM','TABLE LOCK','TX','ROW LOCK', ......