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

oracleÅú´¦ÀíÊý¾Ý

ÔÚORACLEÖÐTAB±íÖнṹ£º
A INT ,
B nvarchar2(50)
ÎÒÔÚD:\DATA.TXTÖÐÓдóÁ¿Êý¾Ý£¬¸ñʽÓëTAB±íÏàͬ£¬ÏÖÎÒÏ뽫TXTÎļþµ¼Èëµ½TAB±íÖУ¬
ʵÏÖÕâÖÖÅú´¦ÀíµÄ·½·¨£¬ÎÒÔÚSQL2000ÖÐÓãº
BULK  INSERT  ʼþ¼Ç¼±í from  'D:\DATA.TXT¡®
  WITH  ( 
        DATAFILETYPE  =  'char', 
        FIELDTERMINATOR  =  ',', 
        ROWTERMINATOR  =  '\n' 
  )
¶øÔÚORACLEÖÐʹÓÃÕâÖÖ·½·¨È´ÒѲ»ÐÐÁË£¬ÇëÎÊORACLEÓÃʲô·½·¨À´´¦ÀíÅúÁ¿Êý¾ÝµÄ²åÈë¡£



°ÑÊý¾Ý·ÅÔÚexcel ÖÐ Ö±½ÓÓÃsqlserver ÆóÒµ¹ÜÀíÆ÷¾ÍÄÜÖ±½Óµ¼Èë

´ò¿ªÆóÒµ¹ÜÀíÆ÷  ÓÒ»÷¿â µ¼ÈëÊý¾Ý  Ñ¡ÔñÄ¿±ê¿â

ÔÙÑ¡Ôñµ¼ÈëexeclÓ¦ÓóÌÐò  Ö¸¶¨Îļþ

µ¼Èë  OK

ÒýÓÃ
°ÑÊý¾Ý·ÅÔÚexcel ÖÐ Ö±½ÓÓÃsqlserver ÆóÒµ¹ÜÀíÆ÷¾ÍÄÜÖ±½Óµ¼Èë

´ò¿ªÆóÒµ¹ÜÀíÆ÷  ÓÒ»÷¿â µ¼ÈëÊý¾Ý  Ñ¡ÔñÄ¿±ê¿â

ÔÙÑ¡Ôñµ¼ÈëexeclÓ¦ÓóÌÐò  Ö¸¶¨Îļþ

µ¼Èë  OK
´ó¸ç£¬È˼ÒÎʵÄÊÇoracle£¬ÈÏÕæ¿´ÌûÒ²ÊÇÒ»ÖÖ¸ºÔðÈεÄ̬¶È

1.sqlplus username/password@sid
2.ÔÚÊý¾Ý¿âÖн¨Á¢ºÃÐèÒªµ¼ÈëµÄÊý¾Ý±í½á¹¹
3.ÊÖ¶¯±£´æinput.ctlÎļþ
load data
infile 'test.txt'
append into table system.lin--×·¼Ó¼Ç¼
filelds teminated by X'09'
4.sqlldr userid=


Ïà¹ØÎÊ´ð£º

¼±ÎÊÒ»¸öoracle×Ö¶ÎÉèÖõÄÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷´óÀÏʦºÃ£¬Çë½ÌÒ»¸öÎÊÌ⣮
ÎÒÉèÖÃÁËÒ»¸öoracle×ֶΣ¬varchar(3000),È»ºó²åÈëÒ»ÌõÊý¾Ý³¤¶È²Å1000,¾Í±¨´íÁË£®È磺net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
Caused ......

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

Oracle Êý¾Ýµ¼³öÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......

oracleÊý¾Ý¿âµÄÃû×ÖÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒÔÚ´´½¨Êý¾Ý¿âµÄʱºòÓõÄÃû×ÖΪoracle10£¬µ«ÊÇ´´½¨ºÃºó£¬ÔÚĬÈϵÄĿ¼ÏÂÏÔʾµÄÃû³ÆÈ´ÊÇoracle10g£¬ÕâÊÇΪʲô£¿
Äã¿´µÄ 10gÊǰ²×°Ä¿Â¼°É 

SQL> select name from v$database;
NAME
---------
ORCL ......

ÎÒʹÓÃmyeclipse6.0Ïòoracle 10gÖÐдÊý¾ÝÎÞ·¨Ð´½øÈ¥

[color=#FF0000][/color]ÒÔÏÂÊÇÎÒµÄservlet´úÂë[color=#FF0000][/color]package JDBCExample1.demo1;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ