sybase中load table什么意思

load in

set temporary option CONVERSION_ERROR = 'OFF'

LOAD TABLE dba.table01

(s1 '|',s2 '|',s3 '\x0a') from

'/home/a.txt'

escapes off

quotes off

notify 100000

Ignore Constraint ALL 5000000

Message Log '/home/error/msg_0203.log'

Row Log '/home/error/error_0203.log'

only log ALL

Log Delimited By '|'

with checkpoint on

commit

load out

set temporary option Temp_Extract_Column_Delimiter = '|'

set temporary option Temp_Extract_Name1 = '/home/sybiq/error/out_iq.txt'

select *

from table01

set temporary option Temp_Extract_Name1 = ''

LOAD TABLE 语句

说明将数据从外部 ASCII 格式文件导入数据库表。

语法LOAD [ INTO ] TABLE [ owner ].table-name

... ( load-specification [, ...] )

... FROM { 'filename-string' | filename-variable } [, ...]

... [ CHECK CONSTRAINTS { ON | OFF } ]

... [ DEFAULTS { ON | OFF } ]

... QUOTES OFF

... ESCAPES OFF

... [ FORMAT { 'ascii' | 'binary' } ]

... [ DELIMITED BY 'string' ]

... [ STRIP { ON | OFF } ]

... [ WITH CHECKPOINT { ON | OFF } ]

... [ { BLOCK FACTOR number | BLOCK SIZE number } ]

... [ BYTE ORDER { NATIVE | HIGH | LOW } ]

... [ LIMIT number-of-rows ]

... [ NOTIFY number-of-rows ]

... [ ON FILE ERROR { ROLLBACK | FINISH | CONTINUE} ]

... [ PREVIEW { ON | OFF } ]

... [ ROW DELIMITED BY 'delimiter-string' ]

... [ SKIP number-of-rows ]

... [ WORD SKIP number ]

... [ START ROW ID number ]

... [ UNLOAD FORMAT ]

... [ IGNORE CONSTRAINT constrainttype [, ...] ]

... [ MESSAGE LOG ‘string’ ROW LOG ‘string’ [ ONLY LOG logwhat [, ...] ]

... [ LOG DELIMITED BY ‘string’ ]

看看最后这句话:Use the ONLINE DATABASE command to bring this database onlineSQL Server will

not bring it online automatically

你先运行命令online database 数据库名

这样才可以使用这个数据库

Backup Server: 4.58.1.1: Database yhxt: 358430 kilobytes LOADed.

你从哪里看到的真正load进去的才20几M?你这个过程很正常

---