In sweet memories of my ever loving brother "kutty thambi " ARUN KUMAR

Saturday, August 8, 2009

SQL*Loader



The SQL*Loader environment




SQL*Loader (sqlldr) is an Oracle-supplied utility that allows you to load data from a flat file(external file) into one or more database tables.

To view the available command in sqlldr using help command

ORACLE:/home/oracle>sqlldr help=y
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
skip Number of logical records to skip
load Number of logical records to load
errors Number of errors to allow
rows Number of rows in conventional path bind array or between direct path data saves
bindsize Size of conventional path bind array in bytes
silent Suppress messages during run (header,feedback,errors,discards,partitions)
direct use direct path
_synchro internal testing
parfile parameter file: name of file that contains parameter specifications
parallel do parallel load
file File to allocate extents from
skip_unusable_indexes disallow/allow unusable indexes or index partitions
skip_index_maintenance do not maintain indexes, mark affected indexes as unusable
commit_discontinued commit loaded rows when load is discontinued
_display_exitcode Display exit code for SQL*Loader execution
readsize Size of Read buffer
external_table use external table for load; NOT_USED, GENERATE_ONLY, EXECUTE
columnarrayrows Number of rows for direct path column array
streamsize Size of direct path stream buffer in bytes
multithreading use multithreading in direct path
resumable enable or disable resumable for current session
resumable_name text string to help identify resumable statement
resumable_timeout wait time (in seconds) for RESUMABLE
date_cache size (in entries) of date conversion cache



1 comment:

Anonymous said...

Hi Rajesh, you may also try the sql 2000 database suspect recovery tool program. I periodically use this application in our company to fix database errors

 
Share/Bookmark