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

oracleÅúÁ¿TXTµ¼ÈëÇó¾È£¡ - Oracle / »ù´¡ºÍ¹ÜÀí

ʹÓÃSQLLDRÃüÁîµ¼È룺


CTLÎļþÈçÏ£º

SQL code:

load data
infile 'e:\20100507.txt'
into table gd_car_info
(
COMPID char terminated by ',' ,
VID char terminated by ',' ,
CITY char terminated by ',' ,
CARNUM char terminated by ',' ,
CARP char terminated by ',' ,
VIN char terminated by ',' ,
CARFADONG char terminated by ',',
BAOAN char terminated by ',',
TIMESTA char terminated by ',',
MEY char terminated by ',',
ZE char terminated by ',',
DIE char terminated by ',',
TIMEEND char terminated by whitespace
)



'e:\20100507.txt' Õâ¸öÎļþÈç¹ûÖ»Óм¸°ÙÌõÊý¾ÝÊÇ¿ÉÒÔÕý³£µ¼ÈëµÄ£¬Ò²Ìáʾ³É¹¦ÁË£»

µ«ÊÇÎÒÒªµ¼ÈëµÄ¼Çʱ¾ÓÐ205M´óС£¬Ö´ÐÐÁËÃüÁîÒÔºó¾Íû·´Ó¦ÁË£¡Ã»Ìáʾ³É¹¦Ò²Ã»Ìáʾʧ°Ü£¡

ÇëÎÊÎªÊ²Ã´ÄØ?
205MÓÃÍⲿ±íµÄ·½Ê½µ¼Èë

ÓÃÍⲿ±íµ¼Èë

¿É·ñÏêϸ½éÉÜһϣ¬Ðֵܣ¡

http://blog.itpub.net/post/6134/32274

205M ȷʵ²»Ð¡...ʱ¼ä³¤Ò²ÊÇÄܽÓÊܵġ£

µ¼ÈëʱʹÓÃÏÂÃæµÄ²ÎÊý
sqlldr username/password control=youcontrol.ctl direct=true streamsize=10485760

¶¥Â¥ÉϵÄ

ѧϰѧϰ¡­¡­

ÎÒÒ²ÏëÖªµÀ£¬Çë½Ì¸ßÊÖ£¡

ÒýÓÃ
µ¼ÈëʱʹÓÃÏÂÃæµÄ²ÎÊý
sqlldr username/password control=youcontrol.ctl direct=true streamsize=10485760




Ïà¹ØÎÊ´ð£º

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......

javaÁ¬²»ÉÏoracle£¿ - Java / Java EE

java.sql.SQLException: Io Òì³£: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=186646784)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBErro ......

OracleÁÙʱ±íʹÓÃÎÊÌâ - Oracle / ¿ª·¢

ÎҵĴ¦ÀíÊÇÕâÑùµÄ£º
ÎÒÓÐÒ»¸öºÜ´óµÄÊý¾Ý¼¯ºÏ£¬´¦ÓÚÐÔÄÜ·½ÃæµÄ¿¼ÂÇÐèҪʹÓÃÁÙʱ±í¹ý¶É£¬²¢ÇÒʹÓ÷ÖÒ³µÄ·½Ê½ÏòÁÙʱ±íÖвåÈëÊý¾Ý£¬Êý¾ÝʹÓÃÍê±Ïºó£¬É¾³ýÁÙʱ±íµÄÊý¾Ý¡£
³öÏÖµÄÏÖÏ󣺵±OracleÖØÐÂÆô¶¯ºó£¬µÚÒ»Ò³²åÈëµÄ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ