Skip to Main Content

SQL & PL/SQL

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!

How I Can Open Control File (file.CTL)

user8942603Mar 2 2010 — edited Mar 2 2010
Dear ALL

I Need To Open ctl File
that Contains

load data
infile 'C:\Documents and Settings\pc computer\Desktop\aaa.csv'
into table MSR_CALLING_CODE
fields terminated by "," optionally enclosed by '"'
( CODE ,country)

when open cmd and insert this command (sqlldr username/password@server control=loader.ctl)

this error Occured

SQL*Loader-500: Unable to open file (loader.ctl)
SQL*Loader-553: file not found
SQL*Loader-509: System error: The system cannot find the file specified.
This post has been answered by rbglossip on Mar 2 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 30 2010
Added on Mar 2 2010
8 comments
1,618 views