need some notes about sql loder

[sonajain]

Hi,
i want to know what is sql loader and how is work, and how to export full database and import it again .plz send me the snytex. waiting fro reply asap.
from
sona

[goudelly]

Hi,

The sql*loader is a utility you load the text,csv data into you oracle database.

The Ex :

emp.ctl (control file)

options(direct=true)
load data
infile 'd:\utl_dir\emp2.txt'
badfile 'd:\utl_dir\emp.bad'
discardfile 'd:\utl_dir\emp.dsc'
into table emp
fields terminated by "|"
trailing nullcols
(empno,ename..,...)

from dosprompt : sqlldr scott/tiger control=emp.ctl

It will insert the data from emp2.txt file to oracle emp table.

For exporting the oracle database :

exp userid=system/manager@orcl file=c:\backup.dmp log=c:\backup.log full=y rows=y owner=scott;

It will export the scott schema objects into backup.dmp file.

For more gothrough the export utility


For Import :

imp userid=system/manager@orcl fromuser=scott touser=scott file=c:\backup.dmp log=c:\backup.log

It will import the data from backup.dmp to oralce database.

Thanks,

Mohan Reddy G

Hi,
i want to know what is sql loader and how is work, and how to export full database and import it again .plz send me the snytex. waiting fro reply asap.
from
sona

[sonajain]

[quote=goudelly]Hi,

Hi, mohanji
Thanks for your help. it really help me in my ocp exams

from
sona

[dwhramana]

http://www.oreilly.com/catalog/orsqlloader/chapter/ch01.html#43545

go to this u will find good description

rams