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

oracle sql loader


SQL*LOADERÊÇORACLEµÄÊý¾Ý¼ÓÔØ¹¤¾ß£¬Í¨³£ÓÃÀ´½«²Ù×÷ϵͳÎļþÇ¨ÒÆµ½ORACLEÊý¾Ý¿âÖС£SQL*LOADERÊÇ´óÐÍÊý¾Ý
²Ö¿âÑ¡ÔñʹÓõļÓÔØ·½·¨¡£
¡¡¡¡ÔÚNTÏ£¬SQL*LOADERµÄÃüÁîΪSQLLDR£¬ÔÚUNIXÏÂÒ»°ãΪsqlldr/sqlload¡£
¡¡¡¡ÈçÖ´ÐУºd:\oracle>sqlldr
SQL*Loader: Release 8.1.6.0.0 - Production on ÐÇÆÚ¶þ 1ÔÂ 8 11:06:42 2002
(c) Copyright 1999 Oracle Corporation.   All rights reserved.
Ó÷¨: SQLLOAD ¹Ø¼ü×Ö = Öµ [,keyword=value,...]
ÓÐЧµÄ¹Ø¼ü×Ö:
     userid -- ORACLE username/password
    control -- Control file name
        log -- Log file name
        bad -- Bad file name
       data -- Data file name
    discard -- Discard file name
discardmax -- Number of discards to allow         (È«²¿Ä¬ÈÏ)
       skip -- Number of logical records to skip   (ĬÈÏ0)
       load -- Number of logical records to load   (È«²¿Ä¬ÈÏ)
     errors -- Number of errors to allow           (ĬÈÏ50)
       rows -- Number of rows in conventional path bind array or between direct p
ath data saves
£¨Ä¬ÈÏ: ³£¹æÂ·¾¶ 64, ËùÓÐÖ±½Ó·¾¶£©
   bindsize -- Size of conventional path bind array in bytes(ĬÈÏ65536)
     silent -- Suppress messages during run (header,feedback,errors,discards,part
itions)
     direct -- use direct path                     (ĬÈÏFALSE)
    parfile -- parameter file: name of file that contains parameter specification
s
   parallel -- do parallel load              &n


Ïà¹ØÎĵµ£º

ÓÃsqlÓï¾äʵÏÖÑôÀúÓëÅ©Àúת»»

 £±.½¨Ò»ÕÅ±í¡¡´æ·ÅÊý¾Ý¡¡ÔÚÏÂÃæ£Ó£Ñ£Ìº¯ÊýÖÐÓÐÓõ½
create  table  solardata  
(  
       yearid  int  not  null,  
       data  char(7)  not  null,   ......

SQL Server 2008ÐÂÌØÐÔ£º¸ü¸Ä¸ú×Ù

ÔÚ´óÐ͵ÄÊý¾Ý¿âÓ¦ÓÃÖУ¬¾­³£»áÓöµ½²¿·ÖÊý¾ÝµÄÍÑ»úºÍ¶à¸öÊý¾Ý¿âµÄºÏ²¢ÎÊÌâ¡£±ÈÈçÏÖÔÚÓÐÒ»¸öȫʡ·¶Î§Ê¹ÓõÄÓ¦ÓóÌÐò£¬Ã¿¸öÊж¼²¿ÊðÁ˵¥¶ÀµÄÏàͬµÄÓ¦ÓóÌÐò·þÎñÆ÷ºÍÊý¾Ý¿â·þÎñÆ÷£¬Ã¿¸öÔÂÐèÒª½«È«Ê¡ËùÓÐÊеÄÊý¾ÝÈ«²¿»ã×ÜÆðÀ´ÓÃÓÚ³öȫʡµÄ±¨±í£¬ÕâÊÇÒ»Öֺܳ£¼ûµÄÊý¾Ý¿âºÏ²¢ÎÊÌâ¡£ÔÙ±ÈÈçÎÒÃÇ×öÁËÒ»¸öSmartClientµÄÓ¦ÓóÌÐò£¬Ã¿¸ö¿ ......

½â¾öMS SQL Server 2005 ÎÞ·¨Ô¶³ÌÁ¬½ÓÎÊÌâ

ÔÚWindows 2003 sp1·þÎñÆ÷ÉÏȱʡ°²×° MS SQL Server 2005 ¼òÌåÖÐÎÄÆóÒµ°æ£¬ÔÚÁ¬½Ó·þÎñÆ÷ʱÏÔʾ“²»ÔÊÐíÔ¶³ÌÁ¬½Ó”¡£
¾ßÌåÏÔʾÈçÏ£º(xxxxxsqlΪ·þÎñÆ÷Ãû£¬ÔÚ±¾µØ²Ù×÷)
C:\Documents and Settings\Administrator>sqlcmd -S xxxxxsql
HResult 0x2£¬¼¶±ð 16£¬×´Ì¬ 1
ÃüÃû¹ÜµÀÌṩ³ÌÐò: ÎÞ·¨´ò¿ªÓë SQL Server ......

Ò»¸öprogrammer¹ØÓÚOracle SQLµÄѧϰС½áÓë˼¿¼

http://www.javaeye.com/topic/366991#
×÷Ϊһ¸ö¿ª·¢ÈËÔ±£¬¿ªÊ¼ÈÏÕæÏµÍ³Ñ§Ï°
Oracle SQLÒ²Ö»ÓÐÔÂÓ֮࣬ǰµÄ
SQLÖª
ʶ½ö½öÊÇÏîÄ¿ÀïÃæÓõ½Ê²Ã´¾ÍÈ¥¿´Ê²Ã´£¬¼òµ¥Ëµ¾ÍÊÇ
Read The Fxxking Guide¡£ÔÚϵͳѧϰ
Oracle
SQL֮ǰ£¬°³µÄÏë·¨¾ÍÊÇ“°´ÕÕÐèÇóÍê³É¹¦ÄÜ£¬Ê£ÏµĽ»¸ø
DBAÀ´´¦À픡£Õâ¸öÏë·¨´ÓÕûÌåÀ´¿´ÏÔ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ