Oracle SQL Loader
Ò»£ºSQL Loader µÄÌØµã
oracle×Ô¼º´øÁ˺ܶàµÄ¹¤¾ß¿ÉÒÔÓÃÀ´½øÐÐÊý¾ÝµÄÇ¨ÒÆ¡¢±¸·ÝºÍ»Ö¸´µÈ¹¤×÷¡£µ«ÊÇÿ¸ö¹¤¾ß¶¼ÓÐ×Ô¼ºµÄÌØµã¡£
±ÈÈç˵expºÍimp¿ÉÒÔ¶ÔÊý¾Ý¿âÖеÄÊý¾Ý½øÐе¼³öºÍµ¼³öµÄ¹¤×÷£¬ÊÇÒ»ÖֺܺõÄÊý¾Ý¿â±¸·ÝºÍ»Ö¸´µÄ¹¤¾ß£¬Òò´ËÖ÷ÒªÓÃÔÚÊý¾Ý¿âµÄÈȱ¸·ÝºÍ»Ö¸´·½Ãæ¡£ÓÐ×ÅËٶȿ죬ʹÓüòµ¥£¬¿ì½ÝµÄÓŵ㣻ͬʱҲÓÐһЩȱµã£¬±ÈÈçÔÚ²»Í¬°æ±¾Êý¾Ý¿âÖ®¼äµÄµ¼³ö¡¢µ¼ÈëµÄ¹ý³ÌÖ®ÖУ¬×Ü»á³öÏÖÕâÑù»òÕßÄÇÑùµÄÎÊÌ⣬Õâ¸öÒ²ÐíÊÇoracle¹«Ë¾×Ô¼º²úÆ·µÄ¼æÈÝÐÔµÄÎÊÌâ°É¡£
sql loader ¹¤¾ßȴûÓÐÕâ·½ÃæµÄÎÊÌ⣬Ëü¿ÉÒÔ°ÑһЩÒÔÎı¾¸ñʽ´æ·ÅµÄÊý¾Ý˳ÀûµÄµ¼Èëµ½oracleÊý¾Ý¿âÖУ¬ÊÇÒ»ÖÖÔÚ²»Í¬Êý¾Ý¿âÖ®¼ä½øÐÐÊý¾ÝÇ¨ÒÆµÄ·Ç³£·½±ã¶øÇÒͨÓõŤ¾ß¡£È±µã¾ÍËٶȱȽÏÂý£¬ÁíÍâ¶ÔblobµÈÀàÐ͵ÄÊý¾Ý¾ÍÓеãÂé·³ÁË¡£
¶þ. sqlldr °ïÖú£º
C:\Documents and Settings\David>sqlldr
SQL*Loader: Release 10.2.0.1.0 - Production on ÐÇÆÚËÄ 7ÔÂ 2 08:54:06 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Ó÷¨: SQLLDR keyword=value [,keyword=value,...]
ÓÐЧµÄ¹Ø¼ü×Ö:
userid -- ORACLE Óû§Ãû/¿ÚÁî
control -- ¿ØÖÆÎļþÃû
log -- ÈÕÖ¾ÎļþÃû
bad -- ´íÎóÎļþÃû
data -- Êý¾ÝÎļþÃû
discard -- ·ÏÆúÎļþÃû
discardmax -- ÔÊÐí·ÏÆúµÄÎļþµÄÊýÄ¿ (È«²¿Ä¬ÈÏ)
skip -- ÒªÌø¹ýµÄÂß¼¼Ç¼µÄÊýÄ¿ (ĬÈÏ 0)
load -- Òª¼ÓÔØµÄÂß¼¼Ç¼µÄÊýÄ¿ (È«²¿Ä¬ÈÏ)
errors -- ÔÊÐíµÄ´íÎóµÄÊýÄ¿ (ĬÈÏ 50)
rows -- ³£¹æÂ·¾¶°ó¶¨Êý×éÖлòÖ±½Ó·¾¶±£´æÊý¾Ý¼äµÄÐÐÊý
(ĬÈÏ: ³£¹æÂ·¾¶ 64, ËùÓÐÖ±½Ó·¾¶)
bindsize -- ³£¹æÂ·¾¶°ó¶¨Êý×éµÄ´óС (ÒÔ×Ö½Ú¼Æ) (ĬÈÏ 256000)
silent -- ÔËÐйý³ÌÖÐÒþ²ØÏûÏ¢ (±êÌâ,·´À¡,´íÎó,·ÏÆú,·ÖÇø)
direct -- ʹÓÃÖ±½Ó·¾¶ &nb
Ïà¹ØÎĵµ£º
ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)
2007Äê11ÔÂ02ÈÕ ÐÇÆÚÎå 16:03
¸ÅÒª
1¡¢Á˽âʲôÊDZ¸·Ý
2¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
3¡¢Àí½âÊý¾Ý¿âµÄÁ½ÖÖÔËÐз½Ê½
4¡¢Àí½â²»Í¬µÄ±¸·Ý·½Ê½¼°ÆäÇø±ð
5¡¢Á˽âÕýÈ·µÄ±¸·Ý²ßÂÔ¼°ÆäºÃ´¦
Ò»¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
¿ÉÒÔ˵£¬´Ó¼ÆËã»úϵͳ³öÊÀµÄÄÇÌìÆð£¬¾ÍÓÐÁ˱¸·ÝÕâ¸ö¸ÅÄ ......
extent--×îС¿Õ¼ä·ÖÅ䵥λ --tablespace management
block --×îСi/oµ¥Î» --segment management
create tablespace james
datafile '/export/home/oracle/oradata/james.dbf'
size 100M ¡¡¡¡¡¡¡¡¡¡¡¡--³õʼµÄÎļþ´óС¡¡
autoextend On¡¡¡¡¡¡¡¡ --×Ô¶¯Ôö³¤
next 10M¡ ......
²éѯ¼°É¾³ýÖØ¸´¼Ç¼µÄSQLÓï¾ä
1¡¢²éÕÒ±íÖжàÓàµÄÖØ¸´¼Ç¼£¬Öظ´¼Ç¼ÊǸù¾Ýµ¥¸ö×ֶΣ¨peopleId£©À´ÅжÏ
select * from people
where peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1)
2¡¢É¾³ý±íÖжàÓàµÄÖØ¸´¼Ç¼£¬Öظ´¼Ç¼ÊÇ ......
sql serverµÄËæ»úº¯ÊýnewID()ºÍRAND()¡¡¡¡
¡¡¡¡SELECT * from Northwind..Orders ORDER BY NEWID()
¡¡¡¡--Ëæ»úÅÅÐò
¡¡¡¡SELECT TOP 10 * from Northwind..Orders ORDER BY NEWID()
¡¡¡¡--´ÓOrders±íÖÐËæ»úÈ¡³ö10Ìõ¼Ç¼¡¡¡¡
¡¡¡¡Ê¾Àý¡¡¡¡
¡¡¡¡A.¶Ô±äÁ¿Ê¹Óà NEWID º¯Êý
¡¡¡¡ÒÔÏÂʾÀýʹÓà NEWID() ¶ÔÉùÃ÷Ϊ uniq ......