Home » RDBMS Server » Server Utilities » SQL Loader (oracle 9i)
SQL Loader [message #277782] Wed, 31 October 2007 09:33 Go to next message
Messages: 5
Registered: October 2007
Junior Member

What sqlldr setting do i need to use to load the file regardless of the number of errors? and also how would I include a parameter in my control file?



Re: SQL Loader [message #277783 is a reply to message #277782] Wed, 31 October 2007 09:41 Go to previous message
Messages: 24963
Registered: January 2009
Location: SoCal
Senior Member
 sqlldr help=yes
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

SQLLDR is documented in the Utilities Manual found at http://tahiti.oracle.com
Previous Topic: import issue
Next Topic: importing records
Goto Forum:

Current Time: Tue Oct 25 09:28:45 CDT 2016

Total time taken to generate the page: 0.13813 seconds