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

Popular posts from this blog

Assembly Microsoft.Dynamics.Service.Plugins.dll can not be loaded. Dynamics CRM 365 Engine version 9 - CRM User creation error

Exception caught instantiating TERADATA report server extension SQL Reporting Services

Could not load file or assembly 'System.ServiceModel, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'. The system cannot find the file specified at Configuration class initiation in CrmServiceHelper.cv