ranjan patnaik

• Oct 3rd, 2005

 

Different types of files are Data File,Control File,Discard File,Bad file

Rajesh

• Nov 2nd, 2005

 

Data File,Control File,Discard File,Bad file and Data file

chenna

• Nov 30th, 2005

 

Hi Did u forget about Log file ,which is more important?

Anurag Kehri.

• Dec 29th, 2005

 

There are 5 files are user in SQL Loader.

they are.

1. Data File.

2.Control File.

3.Log file.

4.Bad File.

5.Discard file.

data file and control file are required file.

example

SQL> sqlldr userid=apps/apps  control=XYZ.ctl

This control file contain the referance of data file.

log file and bad file autometically created by sql Loader.

and Discard file is optional.

sameer

• Jan 14th, 2006

 

Hi

there is one more file called parameter file given on command line as parfile that is also used by sqlldr

in this file diff. parameters can be specified

Bonthu

• Feb 11th, 2006

 

1)Control File.

2)Data File.

3)Logfile.

4)Bad File

5)Discard File.

Cheers,

Bonthu.