Home » RDBMS Server » Server Utilities » SQLLDR
SQLLDR [message #273547] Wed, 10 October 2007 19:26 Go to next message
firsttimer
Messages: 3
Registered: October 2007
Junior Member
I have 3 csv files that I need to append, one after the other, into the same table, can sqlldr handle that?
Re: SQLLDR [message #273548 is a reply to message #273547] Wed, 10 October 2007 19:43 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Yes.
SQLLDR is documented in the Utilities Manual which can be found at http://tahiti.oracle.com
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
Re: SQLLDR [message #273585 is a reply to message #273547] Thu, 11 October 2007 00:59 Go to previous message
Michel Cadot
Messages: 68664
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you use external table, you can specify several files in location clause.

Regards
Michel
Previous Topic: ORA-03237 during import
Next Topic: need to restore dmp file into 9i
Goto Forum:
  


Current Time: Sun Jun 23 14:05:35 CDT 2024