Oracle SQL Loader
Ò»£ºSQL Loader µÄÌصã
oracle×Ô¼º´øÁ˺ܶàµÄ¹¤¾ß¿ÉÒÔÓÃÀ´½øÐÐÊý¾ÝµÄǨÒÆ¡¢±¸·ÝºÍ»Ö¸´µÈ¹¤×÷¡£µ«ÊÇÿ¸ö¹¤¾ß¶¼ÓÐ×Ô¼ºµÄÌص㡣
±ÈÈç˵expºÍimp¿ÉÒÔ¶ÔÊý¾Ý¿âÖеÄÊý¾Ý½øÐе¼³öºÍµ¼³öµÄ¹¤×÷£¬ÊÇÒ»ÖֺܺõÄÊý¾Ý¿â±¸·ÝºÍ»Ö¸´µÄ¹¤¾ß£¬Òò´ËÖ÷ÒªÓÃÔÚÊý¾Ý¿âµÄÈȱ¸·ÝºÍ»Ö¸´·½Ãæ¡£ÓÐ×ÅËٶȿ죬ʹÓüòµ¥£¬¿ì½ÝµÄÓŵ㣻ͬʱҲÓÐһЩȱµã£¬±ÈÈçÔÚ²»Í¬°æ±¾Êý¾Ý¿âÖ®¼äµÄµ¼³ö¡¢µ¼ÈëµÄ¹ý³ÌÖ®ÖУ¬×Ü»á³öÏÖÕâÑù»òÕßÄÇÑùµÄÎÊÌ⣬Õâ¸öÒ²ÐíÊÇoracle¹«Ë¾×Ô¼º²úÆ·µÄ¼æÈÝÐÔµÄÎÊÌâ°É¡£
sql loader ¹¤¾ßȴûÓÐÕâ·½ÃæµÄÎÊÌ⣬Ëü¿ÉÒÔ°ÑһЩÒÔÎı¾¸ñʽ´æ·ÅµÄÊý¾Ý˳ÀûµÄµ¼Èëµ½oracleÊý¾Ý¿âÖУ¬ÊÇÒ»ÖÖÔÚ²»Í¬Êý¾Ý¿âÖ®¼ä½øÐÐÊý¾ÝǨÒƵķdz£·½±ã¶øÇÒͨÓõŤ¾ß¡£È±µã¾ÍËٶȱȽÏÂý£¬ÁíÍâ¶Ô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
Ïà¹ØÎĵµ£º
²éѯ¼°É¾³ýÖظ´¼Ç¼µÄSQLÓï¾ä
1¡¢²éÕÒ±íÖжàÓàµÄÖظ´¼Ç¼£¬Öظ´¼Ç¼ÊǸù¾Ýµ¥¸ö×ֶΣ¨peopleId£©À´ÅжÏ
select * from people
where peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1)
2¡¢É¾³ý±íÖжàÓàµÄÖظ´¼Ç¼£¬Öظ´¼Ç¼ÊÇ ......
SELECT * from ALL_SOURCE
where TYPE='PROCEDURE' AND TEXT LIKE
'%0997500%';
--²éѯALL_SOURCEÖУ¬£¨½Å±¾´úÂ룩ÄÚÈÝÓë0997500Ä£ºýÆ¥ÅäµÄÀàÐÍΪPROCEDURE£¨´æ´¢¹ý³Ì£©µÄÐÅÏ¢¡£
¸ù¾ÝGROUP
BY TYPE
¸ÃALL_SOURCEÖÐÖ»ÓÐÒÔÏÂ5ÖÖÀàÐÍ
1 FUNCTION
2 JAVA
SOURCE
3 PACKAGE
4 P ......
1.±ÜÃâÔÚwhere×Ó¾äÖжÔ×Ö¶ÎÊ©¼Óº¯Êý£¬ÕâÑù½«µ¼ÖÂË÷ÒýʧЧ£¬±ÈÈ磺
select * from user where
to_char(create_time,'yyyymmdd')='20090101';
ÔÒò£ºÔÚ½¨Á¢indexµÄʱºòÊǸù¾Ý×Ö¶ÎÀ´½¨Á¢µÄ£¬Ò²¾ÍÊÇ˵oracleÔÚinidexµÄʱºòÊÇË÷ÒýµÄ×ֶεÄÖµ£¬Èç¹ûÌṩ¸øoracleµÄÊÇÒ»¸öÐèÒª¾¹ýº¯Êý´¦ÀíµÄ±È½Ï£¬oracle¾Íû°ì·¨Í¨¹ýË÷ÒýÖÐµÄ ......
Ò»¡¢Êý¾Ý¿â´æ´¢¸ÅÊö
1¡¢Êý¾ÝÎļþÀàÐÍ
· Primary data files:ÿ¸öÊý¾Ý¿â¶¼ÓÐÒ»¸öµ¥¶ÀµÄÖ÷ÒªÊý¾ÝÎļþ£¬Ä¬ÈÏÒÔ.mdfÀ©Õ¹Ãû¡£Ö÷ÒªÊý¾ÝÎļþ²»½ö°üº¬Êý¾ÝÐÅÏ¢£¬»¹°üº¬Óë¸ÃÊý¾Ý¿â½á¹¹Ïà¹ØµÄÐÅÏ¢¡£´´½¨Êý¾Ý¿âʱ£¬Êý¾Ý¿â½á¹¹Ïà¹ØÐÅÏ¢²»½ö´æÔÚÓÚmasterÊý¾Ý¿âÖУ¬Í¬Ê ......