Hi All
I am new to unix.
I need a shell script to load a datafile in to oracle.
I already have a control file, and data file. all I need is if i execute the shell it must load the data using the ctl file to table.
Control file : PAY0001.ctl
Datafile : mon_grs_det.dat
log file : mon_gross_det.log
discard_file: mon_gross_det.dis
i will be calling the shell from Appworx Scheduler
sqlldr control=PAY0001.ctl log_file=mon_gross_det.log discard=mon_grs_det.dat data=mon_grs_det.dat
$ sqlldr
SQL*Loader: Release 8.1.6.3.0 - Production on Fri Jul 21 08:34:33 2006
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Usage: SQLLOAD keyword=value [,keyword=value,...]
Valid Keywords:
userid -- ORACLE username/password
control -- Control file name
log -- Log file name
bad -- Bad file name
data -- Data file name
discard -- Discard file name
discardmax -- Number of discards to allow (Default all)
skip -- Number of logical records to skip (Default 0)
load -- Number of logical records to load (Default all)
errors -- Number of errors to allow (Default 50)
rows -- Number of rows in conventional path bind array or between direct path data saves
(Default: Conventional path 64, Direct path all)
bindsize -- Size of conventional path bind array in bytes (Default 65536)
silent -- Suppress messages during run (header,feedback,errors,discards,partitions)
direct -- use direct path (Default FALSE)
parfile -- parameter file: name of file that contains parameter specifications
parallel -- do parallel load (Default FALSE)
file -- File to allocate extents from
skip_unusable_indexes -- disallow/allow unusable indexes or index partitions (Default FALSE)
skip_index_maintenance -- do not maintain indexes, mark affected indexes as unusable (Default FALSE)
commit_discontinued -- commit loaded rows when load is discontinued (Default FALSE)
readsize -- Size of Read buffer (Default 1048576)
PLEASE NOTE: Command-line parameters may be specified either by
position or by keywords. An example of the former case is 'sqlload
scott/tiger foo'; an example of the latter is 'sqlload control=foo
userid=scott/tiger'. One may specify parameters by position before
but not after parameters specified by keywords. For example,
'sqlload scott/tiger control=foo logfile=log' is allowed, but
'sqlload scott/tiger control=foo log' is not, even though the
position of the parameter 'log' is correct.
AppWorx runs any shell script as long as you put magic on the first line -
e.g.,
#!/bin/sh
The following is the script whic you need to put in sh file..and this command should be in one line.
And i Don't agree that it is to mandatory to add that magical line #!/bin/sh for appworx.Because my scripts runs fine...with appworx.But it is good practice to include that line.
sqlldr userid= "user/password@host" control= PAY0001.ctl data= mon_grs_det.dat log=mon_gross_det.log bad=mon_gross_det.bad errors=15000