Home » RDBMS Server » Server Utilities » How commit happens in SQL Loader (oracle 9i)
How commit happens in SQL Loader [message #434946] Fri, 11 December 2009 19:52 Go to next message
tapaskmanna
Messages: 98
Registered: January 2007
Location: Cyprus,Nicosia
Member
Hi,

How commit happens in SQL Loader ?
Is commit can be done partial or only at end of loading?

Please suggest.
Re: How commit happens in SQL Loader [message #434947 is a reply to message #434946] Fri, 11 December 2009 20:11 Go to previous message
BlackSwan
Messages: 24912
Registered: January 2009
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
_testing_ncs_to_clob		test non character scalar to character lob conversion
_parallel_lob_load		allow direct path parallel load of lobs
Previous Topic: EXPORT taking more time
Next Topic: sequence in control file
Goto Forum:
  


Current Time: Thu Sep 29 09:01:54 CDT 2016

Total time taken to generate the page: 0.14816 seconds