OracleµÄÍⲿ±í
Íⲿ±í×÷ÓÃ:¼ÓÔغÍжÔØÊý¾Ý
Íⲿ±í¶¼ÊÇÖ»¶Á±í,²»ÄܽøÐÐupdate,insert,delete²Ù×÷.
Oracle ÌṩÁ½ÖÖ·ÃÎÊÇý¶¯: ORACLE_LOADER, ORACLE_DATAPUMP(oracle 10.2ºóÐÂÔöµÄÇý¶¯)
ORACLE_LOADER: ËüÀûÓÃoracle loader¼¼Êõ´ÓÍⲿ±í¶ÁÈ¡Êý¾Ý. Ëü»¹¾ßÓÐÀàËÆSQL*Loader¹¤¾ß¿ØÖÆÎļþÓï·¨µÄÊý¾ÝÓ³ÉäÄÜÁ¦.
ORACLE_DATAPUMP: ËüÌṩжÔØÊý¾ÝµÄÄÜÁ¦,¼´°ÑÊý¾Ý´ÓÊý¾Ý¿âÀïµ¼ÈëÒ»¸öÍⲿ±í,ÔÙÓÉÒ»¸ö»ò¼¸¸öÍⲿ±íµ¼Èëµ½Êý¾Ý¿âÀï.
¶ÔÓÚAS subqueryµÄ×Ó¾ä±ØÐëʹÓÃORACLE_DATAPUMP
.´´½¨ÓÃÓÚжÔØÊý¾ÝµÄÍⲿ±íʱ£¬²»ÄÜÖƶ¨ÁÐÃû¡£
ͬʱ£¬²»Ö§³Öbadfile¡¢discardfile²ÎÊý£¬ÒòΪÆäÎÞЧ»òÕ߶ªÆúÊý¾Ý½«²»ÓèÒÔ¼Ç¼Ϊ²Ù×÷ϵͳÎļþ,
ûÓÐfields terminated by(»òÕßmissing field values are null)²ÎÊý
ORACLE_DATAPUMPÒ»°ãʹÓÃÔÚ½øÐÐÈÕÖ¾±íµÈ´óÊý¾Ý±íµÄ±¸·ÝºÍÊý¾ÝתÒÆÉÏ.Ψһ²»×ãµÄÊÇOracleÖ»Äܽ«Êý¾Ýд³É¶þ½øÖƸñʽ,
ËùÒÔÓÃÍⲿ±íÀ´Éú³ÉExcel±¨±íÖ®ÀàµÄÊÇÐв»Í¨µÄ.²»¹ýÔÚwebÓ¦ÓÃÖÐÓÃÍⲿ±í¼ÓÔØExcelÊý¾ÝÈ´ÊÇ¿ÉÒԵĶøÇҺܴó³Ì¶ÈÉÏÌá
¸ßÓ¦ÓõÄÐÔÄÜ,ºóÃæ»á½øÐÐÏà¹Ø¾ÙÀý.
ORACLE_DATAPUMP ʹÓþÙÀý(±¸·Ý±íÊý¾Ýµ½Æ½ÃæÎļþ):
CREATE TABLE external_dx_sms_bak0127 (
school_id,
user_id,
object_mobile,
stu_sequence
)
ORGANIZATION EXTERNAL
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
root@hardy:~# cd /bin
root@hardy:/bin# ls -l /bin/sh
lrwxrwxrwx 1 root root 4 2008-04-28 19:59 /bin/sh -> dash
root@hardy:/bin# ln -sf bash /bin/sh
root@hardy:/bin# ls -l /bin/sh
lrwxrwxrwx 1 root root 4 2008-05-01 22:51 /bin/sh -> bash
# echo "Red Hat Linux release 4" > /etc/redhat- ......
OracleÊý¾Ý¿âSCNºÅÏê½â:
¡¡¡¡ÏµÍ³¼ì²éµãscn(v$database(checkpoint_change#))
¡¡¡¡Êý¾ÝÎļþ¼ì²éµã(v$datafile(checkpoint_change#))
¡¡¡¡Êý¾ÝÎļþÖÕÖ¹scn(v$datafile(last_change#))
¡¡¡¡Êý¾ÝÎļþÖдæ·ÅµÄ¼ì²éµã
¡¡¡¡Æô¶¯scn (v$datafile_header(checkpoint_change#)
¡¡¡¡1¡¢ÏµÍ³¼ì²éµãscn
¡¡¡¡µ±Ò»¸ö¼ì²éµã¶¯×÷Íê³ ......
¡¡¡¡ÔÚ´óÁ¿ÒµÎñÊý¾Ý´¦ÀíµÄÏîÄ¿ÖУ¬¿ÉÒÔ¿¼ÂÇʹÓ÷ÖÇø±íÀ´Ìá¸ßÓ¦ÓÃϵͳµÄÐÔÄܲ¢·½±ãÊý¾Ý¹ÜÀí£¬±¾ÎÄÏêϸ½éÉÜÁË·ÖÇø±íµÄʹÓá£
¡¡¡¡
¡¡¡¡ÔÚ´óÐ͵ÄÆóÒµÓ¦ÓûòÆóÒµ¼¶µÄÊý¾Ý¿âÓ¦ÓÃÖУ¬Òª´¦ÀíµÄÊý¾ÝÁ¿Í¨³£¿ÉÒÔ´ïµ½¼¸Ê®µ½¼¸°ÙGB£¬ÓеÄÉõÖÁ¿ÉÒÔµ½TB¼¶¡£ËäÈ»´æ´¢½éÖʺÍÊý¾Ý´¦Àí¼¼ÊõµÄ·¢Õ¹Ò²ºÜ¿ì£¬µ«ÊÇÈÔÈ»²»ÄÜÂú×ãÓû§µÄÐèÇó£¬ÎªÁË ......