Sponsored Content
Top Forums Shell Programming and Scripting Shell Script for Data loading in Oracle Post 302080928 by aigles on Friday 21st of July 2006 02:57:36 AM
Old 07-21-2006
Code:
sqlldr control=PAY0001.ctl log_file=mon_gross_det.log  discard=mon_grs_det.dat data=mon_grs_det.dat

Code:
$ 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.

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Need Shell Script to upload data from Text file to Oracle database

Hi Does any one have any idea on uploading the data using Unix Shell script from text file to Oracle database. Requirement:- 1. Need to connect to Oracle database from Unix Shell script. 2. Need to pick Text file from some location on Unix Box. 3. Need to upload the data from text file to... (6 Replies)
Discussion started by: chandrashekharj
6 Replies

2. Shell Programming and Scripting

Function loading in a shell scripting like class loading in java

Like class loader in java, can we make a function loader in shell script, for this can someone throw some light on how internally bash runs a shell script , what happenes in runtime ... thanks in advance.. (1 Reply)
Discussion started by: mpsc_sela
1 Replies

3. Shell Programming and Scripting

Need shell script to extract data from oracle database

shell script (4 Replies)
Discussion started by: frns5
4 Replies

4. Shell Programming and Scripting

unix script for loading a data from a file into database

Hi All, I am trying to load a data from a files in a particular directory to a database.. cd $SCC isql metdb >> ${LOGDATA}/LOAD.LOG < ! load from "${LDATA}/${FORM}.ld" insert into $LOADTABLE ! But it's showing the error "syntax error at line 46 : `<<' unmatched" Can u plz help me... (5 Replies)
Discussion started by: grajesh_955
5 Replies

5. Shell Programming and Scripting

Loading Oracle data to unix in flat file

Hi I would like to know how to load oracle data to unix flat file using a shell script. Can we use sqlldr to import data from oracle, if so can anyone help me with it. (2 Replies)
Discussion started by: raghav288
2 Replies

6. UNIX for Advanced & Expert Users

creating data loading script

asdfasdfasdfasdf??? (2 Replies)
Discussion started by: noorm
2 Replies

7. Shell Programming and Scripting

How to fetch data from oracle in unix shell script

Hi, How to fetch data from oracle database in unix shell scripting. list=`sqlplus -s ds_user/dsuser@EMI <<EOF set feedback off set serveroutput on set heading off set pagesize 0 set tab off select IP_ID from table / exit EOF` The output is not what i expected.I need output in... (4 Replies)
Discussion started by: Anusha_Reddy
4 Replies

8. Shell Programming and Scripting

Shell script to export data from Oracle table .

Hi, I want to write a shell script which will export data from oracle table . I don't want to save that data . I want the queries . Right now i am right clicking on the table and clicking on export as to my desktop . Please let me know if any one have any idea . (2 Replies)
Discussion started by: honey26
2 Replies

9. Shell Programming and Scripting

why do we need UNIX shell script to load data into Oracle database

Hello everyone, I am new to shell scripting/ loading data into a database. I want to load data into Oracle database using SQL loader. Can some one please explain why do we need unix shell script to load the data into the database? Also can someone please explain what has to be in that script?... (5 Replies)
Discussion started by: new_prog
5 Replies

10. Shell Programming and Scripting

Loading data in oracle using shell scripts

Hi , I have a scenario, i have a directory where i receive around 14-15 files at a interval of 20-40 min not fixed, i want to write a unix scripts which invoke sqlldr command to load files into oracle automatically as soon as the file hit the directory. Any help will be appreciated. ... (4 Replies)
Discussion started by: guddu_12
4 Replies
dhcpsvc.conf(4) 														   dhcpsvc.conf(4)

NAME
dhcpsvc.conf - file containing service configuration parameters for the DHCP service The dhcpsvc.conf file resides in directory /etc/inet and contains parameters for specifying Dynamic Host Configuration Protocol (DHCP) ser- vice configuration settings, including the type and location of DHCP data store used. The description of the dhcpsvc.conf file in this man page is informational only. The preferred method of setting or modifying values within the dhcpsvc.conf file is by using dhcpconfig(1M) or the dhcpmgr(1M) utility. Do not edit the dhcpsvc.conf file. The dhcpsvc.conf file format is ASCII; comment lines begin with the crosshatch (#) character. Parameters consist of a keyword followed by an equals (=) sign followed by the parameter value, of the form: Keyword=Value The following Keyword and Value parameters are supported: BOOTP_COMPAT String. automatic or manual. Enables support of BOOTP clients. Default is no BOOTP. Value selects BOOTP address allocation method. automatic to support all BOOTP clients, manual to support only registered BOOTP clients. server mode only parameter. CACHE_TIMEOUT Integer. Number of seconds the server caches data from data store. Used to improve performance. Default is 10 seconds. server mode only parameter. CONVER Integer. Container version. Used by DHCP administrative tools to identify which version of the public module is being used to adminis- ter the data store. CONVER should not be changed manually. DAEMON_ENABLED TRUE/FALSE. If TRUE, the DHCP daemon can be run. If FALSE, DHCP daemon process exits immediately if the daemon is started. Default is TRUE. Generic parameter. HOSTS_DOMAIN String. Defines name service domain that DHCP administration tools use when managing the hosts table. Valid only when HOSTS_RESOURCE is set to nisplus or dns. HOSTS_RESOURCE String. Defines what name service resource should be used by the DHCP administration tools when managing the hosts table. Current valid values are files, nisplus, and dns. ICMP_VERIFY TRUE/FALSE. Toggles ICMP echo verification of IP addresses. Default is TRUE. server mode only parameter. INTERFACES String. Comma-separated list of interface names to listen to. Generic parameter. LOGGING_FACILITY Integer. Local facility number (0-7 inclusive) to log DHCP events to. Default is not to log transactions. Generic parameter. OFFER_CACHE_TIMEOUT Integer. Number of seconds before OFFER cache timeouts occur. Default is 10 seconds. server mode only parameter. PATH Path to DHCP data tables within the data store specified by the RESOURCE parameter. The value of the PATH keyword is specific to the RESOURCE. RELAY_DESTINATIONS String. Comma-separated list of host names and/or IP addresses of relay destinations. relay mode only parameter. RELAY_HOPS Integer. Max number of BOOTP relay hops before packet is dropped. Default is 4. Generic parameter. RESCAN_INTERVAL Integer. Number of minutes between automatic dhcptab rescans. Default is not to do rescans. server mode only parameter. RESOURCE Data store resource used. Use this parameter to name the public module. See the PATH keyword in dhcp_modules(5). RESOURCE_CONFIG String. The private layer provides for module-specific configuration information through the use of the RESOURCE_CONFIG keyword. See dhcp_modules(5). Providers can access RESOURCE_CONFIG using the configure function by specifying an optional service provider layer API function: int configure(const char *configp); If this function is defined by the public module provider, it is called during module load time by the private layer, with the contents of the RESOURCE_CONFIG string acquired by the administrative interface (in the case of the dhcpmgr, through the use of a public module- specific java bean extending the dhcpmgr to provide a configuration dialog for this information. RUN_MODE server or relay. Selects daemon run mode. Default is server. SECONDARY_SERVER_TIMEOUT Integer. The number of seconds a secondary server waits for a primary server to respond before responding itself. Default is 20 sec- onds. This is a server mode only parameter. UPDATE_TIMEOUT Integer. Number of seconds to wait for a response from the DNS server before timing out. If this parameter is present, the DHCP daemon updates DNS on behalf of DHCP clients, and waits the number of seconds specified for a response before timing out. You can use UPDATE_TIMEOUT without specifying a number to enable DNS updates with the default timeout of 15 seconds. If this parameter is not present, the DHCP daemon does not update DNS for DHCP clients. VERBOSE TRUE/FALSE. Toggles verbose mode, determining amount of status and error messages reported by the daemon. Default is FALSE. Set to TRUE only for debugging. Generic parameter. dhcpmgr(1M), in.dhcpd(1M), dhcp(5), dhcp_modules(5) 26 Jun 2003 dhcpsvc.conf(4)
All times are GMT -4. The time now is 10:37 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy