Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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




Ïà¹ØÎÊ´ð£º

javaÔõôÁ¬½ÓOracle£¬¼±°¡ - Java / JavaÏà¹Ø

private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......

oracleÓëaix - Oracle / ¸ß¼¶¼¼Êõ

ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼­¾íºÅlv04 
#lslv -l lv04 ......

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 / »ù´¡ºÍ¹ÜÀí

Ð»Ð»ÌÆÈËÀÏ´óµÄÖ¸µã£¬Ð»Ð»¸÷λ¸ßÊÖµÄÖ¸µã£¡
°²×°10g Enterprise¡£ÉÏÍøÏÂÁËMLDNµÄOracleÊÓÆµ£¬¸ú×ÅÊÓÆµÉϵÄÅäÖÃ×ߣ¬°²×°³É¹¦ÁË£¬µ«ÊÇûÍêÕûµØÅäÖá£
µã»÷½øÈ룺Database Configuration Assistant
1. ´´½¨Êý¾Ý¿â£» ......

OracleÈÏÖ¤ - Oracle / ÈÏÖ¤Ó뿼ÊÔ

ORACLEÅàѵ(OCA)ÈÏÖ¤½éÉÜ 
Oracle10g Certified Associate (OCA) Oracle ÈÏ֤רԱ¡£
¿¼ÊԳɼ¨Í¨¹ýÄÜ»ñµÃOracle¹«Ë¾ÎªÄú°ä·¢µÄÈ«ÇòÈÏÖ¤µÄÓ¢ÎÄOCAÖ¤Êé¡£OCAÓÉOracle¹«Ë¾³öÌâ¡£
¸ÃÖ¤Êé¿É×÷Ϊ¸÷ÆóÊÂÒµµ¥Î»Êý¾Ý¿ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ