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

oracle µ¼Èëºó ÔÚÄIJ鿴 - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒ´ÓÁíÍâһ̨»ú×ÓÉϵÄoracleÉϵ¼³öÁËÒ»¸öÓû§A£¬µÃµ½A.DMP£¬µ¼³öÊdzɹ¦µÄ¡£ È»ºó£¬ÔÚÎҵĻú×ÓÉϵ¼ÈëÁËoracleÖУ¬ÎÒÔÚÓû§BϽøÐеÄIMPµ¼È룬ÏÔʾ³É¹¦ÖÕÖ¹µ¼È룬ûÓгöÏÖ¾¯¸æ£¬¿ÉÎҵǼµ½BÒÔºó£¬È´Ã»Óз¢ÏÖÓÐÈκε¼ÈëµÄ¶«Î÷£¬ÓÃPL/SQLÒ²¿´²»¼û¡£Çë¸÷λ°ïæָ½Ìһϣ¬Èç¹û²é¿´µ¼ÈëµÄÓû§¡£¼±£¡

exp/imp Óï¾äÔõôдµÄ£¿¡¡Ìù³öÀ´¿´¿´..


ÄãÊDz»Êǵ¼ÈëÁ˱ðµÄÓû§ÖÐÈ¥ÁË

лл¥ÉϵÄÌáÐÑ£¬ÎÒ¸Õ²ÅÊǰ´×ÅimpµÄÌáʾÃüÁî½øÐеĵ¼È룬½á¹ûÒ²²»ÖªµÀµ¼Èëµ½ÄÄÁË£¬ÏÖÔÚ°´×ÅÄã˵µÄÎÒµ¼Èë½øÈ¥ÁË¡£ÔÙ´Îлл£¡


Ïà¹ØÎÊ´ð£º

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 / ·Ç¼¼ÊõÇø

¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰 
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN ......

JavaÖ®¸¸À뿪Oracle£¬±¯Í´°¡£¡£¡ - Java / ·Ç¼¼ÊõÇø

¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬
ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡
OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Âð£¿
SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......

oracle 10g data guard - Oracle / »ù´¡ºÍ¹ÜÀí

×öÍædata guard ºó
ÔÚPrimary·þÎñÆ÷ Ö´ÐР
SQL>SELECT SEQUENCE#,APPLIED from V$ARCHIVED_LOG ORDER BY SEQUENCE#;
 SEQUENCE# APP
---------- ---
  13 NO
  13 YES ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ