set oralcexe sa password
orapwd file=PWDXE.ora password=iris entries=10install sql 2008 ee version, need pwer shell in win2008 sp2
down load power shell :http://www.microsoft.com/en-us/download/details.aspx?id=20430options(errors=1000)
load datainfile "C:\Users\zhchu\Documents\dbo_einfotable.txt"replace into table EINFOTABLEfields terminated by ","(eid Integer External,edate Date "mm/dd/yyyy hh24:mi:ss",ddate Date "mm/dd/yyyy hh24:mi:ss",eprice ,Eprice2 ,Eprice3 ,Eprice4 ,Eprice5 ,phoneNum,ename,mark)sqlldr control=D:\SybaseTest\oraclexeload.ctl log=D:\SybaseTest\data_load.log
CREATE TABLE einfotable(eid int NOT NULL PRIMARY KEY ,edate datetime not null, ddate datetime not null,eprice money not null,eprice2 money not null,eprice3 money not null,eprice4 money not null,eprice5 money not null,phoneNum varchar(20) not null,ename varchar(20) not null,mark varchar(30) not null);insert into einfotable select * from dbo_einfotable;
select COUNT(1) from einfotable;
cd /d c:\windows
Activation context generation failed for "D:\Sybase\ASE-15_0\bin\syconfig.exe". Dependent Assembly Microsoft.VC80.CRT,processorArchitecture="amd64",publicKeyToken="1fc8b3b9a1e18e3b",type="win32",version="8.0.50727.4053" could not be found. Please use sxstrace.exe for detailed diagnosis.
download(vcredist_x64.exe) and install