importing unicode text records into Oracle 10G(11G)
if you wanna import data file(s) obtaining from seperate data source with known schema to oracle database.You can use sqlldr prompt command in any Oracle Client.You can also create specific file to define exported data maps such as comma or tab seperation with column,namely blablabla.ctl included some commands that will be executed by sqlldr.exe
basic sample of control file:
file name : tableName.ctl
file inside:
load data
infile 'c:\tableName.txt'
into table tableName
fields terminated by " " optionally enclosed by '"'
(column1,column2,column3,....)
use sqlldr in command prompt like that;
C:\Documents and Settings\sfssrvadmin>sqlldr db_username/db_password@SOURCED
B control='E:\PhysicalDirectory\Sub_Directory\tableName.ctl' ERRORS=200
regards,
P.S:Please do not hesitate to share your comments.
Comments
Post a Comment