Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Role of "str '<EORD>\r\n'" value in control file in sql loader

pnshende_DBEMar 28 2013 — edited Apr 1 2013
Hi All,

Could any one please let me know what is the exact use of "str '<EORD>\r\n'" statement in control file ?, while populating data from .dat file into database table.

When I am trying with this option, I am able to load a single record into a database table. If I remove this statement form control file, complete records from file get populated into table. I am using Linux server for imp data with sqlloader.

Also, Does there any difference to use this statement in control file on Linux server and on AIX server ?

Here is the structure of my ctl file.

load data
infile 'data/EZMAIL/CDSWEB.EZMAIL.dat'
*"str '<EORD>\r\n'"*
into table CDSWEB.EZMAIL
fields terminated by '#<EOFD>#'
trailing nullcols (

Thanks
Pravin
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 29 2013
Added on Mar 28 2013
#database-key-features, #export-import-sql-loader-external-tables
5 comments
1,215 views