Oracle SQL LoaderµÄÏêϸÓï·¨
Oracle
SQL
Loader
µÄÏêϸÓï·¨
Oracle
SQL
Loader
µÄÏêϸÓï·¨
SQL
*LOADER
ÊÇ
ORACLE
µÄÊý¾Ý¼ÓÔØ¹¤¾ß£¬Í¨³£ÓÃÀ´½«²Ù×÷ϵͳÎļþÇ¨ÒÆµ½
ORACLE
Êý¾Ý¿âÖС£
SQL
*LOADER
ÊÇ´óÐÍÊý¾Ý
²Ö¿âÑ¡ÔñʹÓõļÓÔØ·½·¨£¬ÒòΪËüÌṩÁË×î¿ìËÙµÄ;¾¶£¨
DIRECT
£¬
PARALLEL
£©¡£ÏÖÔÚ£¬ÎÒÃÇÅ׿ªÆäÀíÂÛ²»Ì¸£¬ÓÃʵÀýÀ´Ê¹Äú¿ìËÙÕÆÎÕ
SQL
*LOADER
µÄʹÓ÷½·¨¡£
Ê×ÏÈ£¬ÎÒÃÇÈÏʶһÏÂ
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 --
Ïà¹ØÎĵµ£º
´´½¨ÁÙʱ±í¿Õ¼ä
CREATE TEMPORARY TABLESPACE test_temp
TEMPFILE 'C:\oracle\product\10.1.0\oradata\orcl\test_temp01.dbf'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;
´´½¨Óû§±í¿Õ¼ä
CREATE TABLESPACE test_data
LOGGING
DATAFILE 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\TE ......
OracleÖÐÌṩһϵÁÐÀàÐÍ£¬Ã¿¸öÀàÐ͵ÄÌØµãÈçÏ£º
char£º´æ´¢¹Ì¶¨³¤¶ÈµÄ×Ö·û£¬Èç¹û×Ö·û³¤¶È²»¹»»áÔÚÓұ߲¹¿Õ¸ñ¡£±ÈÈ磺name char£¨10£©£¬µ±¸øname¸³ÖµÎª'zhangsan'ʱ»áÔÚÓұ߲¹³ä2¸ö¿Õ¸ñ¡£charÀàÐ͵ÄÈÝÁ¿Îª1¡«2000B£¬Ã»ÓÐÖ¸¶¨ÔòĬÈϳ¤¶ÈΪ1¡£
varchar2£º´æ´¢³¤¶È¿É±äµÄ×Ö·û£¬ºÍcharÀàÐ͵IJ»Í¬£¬Ëü²»»á×Ô¶¯²¹³ä¿Õ¸ñ£¬ÇÒ¶¨ÒåÊ ......
Ò»¡¢Oracle Âß¼½á¹¹¼ò½é
oracleµÄÂß¼½á¹¹°üÀ¨±í¿Õ¼ä(tablespace)£¬¶Î(segment),Êý¾Ý¿é(data block)ÒÔ¼°Ä£Ê½¶ÔÏó(schema)¡£
oracle Êý¾Ý¿âÔÚÂß¼ÉÏÊÇÓɶà¸ö±í¼ä×é³ÉµÄ£¬±í¿Õ¼äÖд洢µÄ¶ÔÏó½Ð¶Î£¬±ÈÈçÊý¾Ý¶Î£¬Ë÷Òý¶Î£¬ºÍ»ØÍ˶Ρ£¶ÎÓÉÇø×é³É£¬ÇøÊÇ´ÅÅÌ·ÖÅäµÄ×îСµ¥Î»¡£ ......
5.1 ÃÜÂë²ßÂÔ
¡¡¡¡ÓÉÓÚsql server²»Äܸü¸ÄsaÓû§Ãû³Æ£¬Ò²²»ÄÜɾ³ýÕâ¸ö³¬¼¶Óû§£¬ËùÒÔ£¬ÎÒÃDZØÐë¶ÔÕâ¸öÕʺŽøÐÐ×îÇ¿µÄ±£»¤£¬µ±È»£¬°üÀ¨Ê¹ÓÃÒ»¸ö·Ç³£Ç¿×³µÄÃÜÂ룬×îºÃ²»ÒªÔÚÊý¾Ý¿âÓ¦ÓÃÖÐʹÓÃsaÕʺš£Ð½¨Á¢Ò»¸öÓµÓÐÓësaÒ»ÑùȨÏ޵ij¬¼¶Óû§À´¹ÜÀíÊý¾Ý¿â¡£Í¬Ê±Ñø³É¶¨ÆÚÐÞ¸ÄÃÜÂëµÄºÃϰ¹ß¡£Êý¾Ý¿â¹ÜÀíÔ±Ó¦¸Ã¶¨ÆÚ²é¿´ÊÇ·ñÓв»·ûºÏ ......
À´Ô´£ºhttp://www.cnblogs.com/jxnuxg/articles/1114418.html
CONVERT(data_type,expression[,style])
Óï¾ä¼°²éѯ½á¹û£º
SELECT CONVERT(varchar(100), GETDATE(), 0): 05 16 2006 10:57AM
SELECT CONVERT(varchar(100), GETDATE(), 1): 05/16/06
SELECT CONVERT(varchar(100), GETDATE(), 2): 06.05.16
SELECT CO ......