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)
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)
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)
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)
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)
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)
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)
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
LEARN ABOUT POSIX
dhcpsvc.conf
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)