oracleµ¼ÈëÊý¾Ý¿âÐÅÏ¢²»ÍêÕû
ÓõÄÊÇplsql,ÔÚµ¼Èë±íµÄʱºòÓÐ3ÖÖÑ¡Ôñ·½Ê½£¬ÎÒÒ»°ãÑ¡ÔñplsqlµÄÄǸö£¬¿ÉÊÇÔÚ½«µ¼Èë·þÎñÆ÷ÖеIJ¿·Ö±íµ¼Èëµ½±¾µØµÄʱºò£¬
ÎÞÂÛÑ¡Ôñ3ÖÖ·½Ê½ÖеÄÈκÎÒ»ÖÖ£¬¶¼²»³É¹¦¡£ÓÃplsqlµÄÄÇÖÖ£¬ËµÊDZí»òÕßÊÓͼ£¬±í¿Õ¼ä²»´æÔÚ¡£ÎÒ²»ÏëÒªÕâÐ©Ô¼Êø£¬Ö»Òªµ¼Èë±í½á¹¹ºÍÊý¾Ý¾Í¿ÉÒÔÁË¡£¸ÃÔõô°ì£¿
ÎÒÒ»°ãÓÃoracle Import,²»¹ýµÃ¿´Äãµ¼³öµÄÊÇʲôÎļþ£¬Èç¹ûÊÇsqlÎĵϰ£¬¾ÍµÃÓÃsql inserts
ûÓùýplsqlµÄµ¼È룬µ«ÏëÏñÖÐÓ¦¸Ã¿ÉÒÔÏñimpÄÇÑùÉèÖòÎÊýµÄ£¬±ÈÈçcontains = N
Ç¿ÁÒÖ§³Ö£¡
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#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£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN
......