SQL*Loader

In this forum you can share stuff related to Oracle 11g, 10g, 9i.
Post Reply
siva sankar
Posts: 130
Joined: Sun Mar 11, 2007 1:47 am
Location: India

SQL*Loader

Post by siva sankar »

Hi All,

I have 1000 records in flatfile.
Using Sql*Loader program,I want to upload 1000 records to my table immediately is it possible?
If possible,give me the solution?
If not possible,Give me the reason?

Please suggest me on this...
Top
arvindmaurya
Posts: 18
Joined: Mon Jan 08, 2007 9:13 am
Location: India

Post by arvindmaurya »

Yes it is possible . You need to create the control file. Using that control file you need to load the data in the table.
visit this link for more information.
http://www.oreilly.com/catalog/orsqlloa ... /ch01.html
Top
sekharkula
Posts: 2
Joined: Wed Apr 25, 2007 9:14 am
Location: India

Post by sekharkula »

yes its possible by selecting direct mode.
Top
Post Reply

Return to “Oracle Databases”



Who is online

Users browsing this forum: No registered users and 1 guest