Sponsored Content
Top Forums UNIX for Dummies Questions & Answers SQL loader script - ORACLE environmental variable Post 302498460 by Neo on Monday 21st of February 2011 11:20:19 AM
Old 02-21-2011
You can easily see that your use of "'" is inconsistent. Try cleaning up your syntax.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Set Oracle Environmental Variable !!

Can someone send me a shell script to set all Oracle environment variable which is working. I have the following script which works but not 100%. Please advice what you think is wrong. if # Command executed from a terminal then ORACLE_SID="" ... (4 Replies)
Discussion started by: uuser
4 Replies

2. UNIX for Dummies Questions & Answers

problems running a sql loader script

Hi Folks, I have created a number of unix scripts that i can run from the scheduler on a server-side application that we use (Chordiant Marketing Director). All scripts are working except one. This last script is a user load script which first truncates a table and then loads it using a flat... (2 Replies)
Discussion started by: jibbadiah
2 Replies

3. Shell Programming and Scripting

Shell script for accessing a file in the network drive and invoking oracle sql loader

Hi, Please let me know if anybody is having a solution handy for the below tasks... It would be helpful if somebody can resolve my query. I am new to unix and oracle environment and looking for some online reference for completing a task. Task: Check if the network drive exists Check... (0 Replies)
Discussion started by: sayydevara
0 Replies

4. Shell Programming and Scripting

A SQL Loader Script

Hi Guys, I am looking to develop a SQL Loader script that would bascially allow the user to have a txt file (or such) as an input file containing .sql scripts procedures, triggers, bascially anything against a database that could then be run automatically. Let me break it down a bit more,... (2 Replies)
Discussion started by: LiquidChild
2 Replies

5. Shell Programming and Scripting

sql loader script

hi all i am new to shell scripting. i have 35 flat files delimited files that i have to load in to a table. i was asked to create a shell script that loads the data into the table... could you please help me if you have a script. Also .. how to create logs files...does my sql... (3 Replies)
Discussion started by: rajesh_tns
3 Replies

6. Shell Programming and Scripting

How to get the value of a variable which is having another value in environmental script?

Dear Folks, I am facing an issue in getting a value of a variable.Let me explain the scenario. I am having a list file say files.list in which I have mentioned 1 FILE1 2 FILE2 Then I am having an set_env.ksh in which I mentioned FILE1=/clocal/data/user/userdata.txt... (4 Replies)
Discussion started by: dinesh1985
4 Replies

7. Shell Programming and Scripting

Oracle environmental variables in shells script

Hi, Getting below error on executing the shell script which initiates sqlplus How to set oracle enviornment variables in the shell script ? With Regards (3 Replies)
Discussion started by: milink
3 Replies

8. Shell Programming and Scripting

use of sql loader in the script

All, Below is the code written when sql loader loads the data: $ORACLE_EXEC_PATH/sqlldr userid=$user_passwd control=$CNTR_FILES/invoice.ctl log=$LOG_FILES/$INVOICE_FILE.log bad=$ER ROR_FILES/$INVOICE_FILE.bad data=$DATA_FILES/$INVOICE_FILE silent=FEEDBACK direct=false errors=50000 rc=$?... (1 Reply)
Discussion started by: Oracle_User
1 Replies

9. Homework & Coursework Questions

Write a shell script for SQL loader to load data into a staging table

Hi, I'm new to Linux. I'm working on a database, and need to load data in a database table (which I already created) using shell script. The table has two columns - Acct_number (not nullable) and date (timestamp). I'm not able to write a shell script for that. Can any one help me? ... (3 Replies)
Discussion started by: saisudeep
3 Replies

10. Shell Programming and Scripting

How to call SQL Loader in shell script?

HI Experts, I am pretty new to scripting and i need to create a perl or shell script which should fetch a file from local directory and insert the data into a table using sql loader. This will be later added to chron job to run daily and fetch all files and load them into the table. Also i... (1 Reply)
Discussion started by: sam1234
1 Replies
LOADER.4TH(8)						    BSD System Manager's Manual 					     LOADER.4TH(8)

NAME
loader.4th -- loader.conf processing tools DESCRIPTION
The file that goes by the name of loader.4th is a set of commands designed to manipulate loader.conf(5) files. The default /boot/loader.rc includes loader.4th and uses one of its commands to automatically read and process the standard loader.conf(5) files. Other commands exists to help the user specify alternate configurations. The commands of loader.4th by themselves are not enough for most uses. Please refer to the examples below for the most common situations, and to loader(8) for additional commands. Before using any of the commands provided in loader.4th, it must be included through the command: include loader.4th This line is present in the default /boot/loader.rc file, so it is not needed (and should not be re-issued) in a normal setup. The commands provided by it are: boot boot kernelname [...] boot directory [...] boot -flag ... Boot as specified by the loader.conf(5) files read. Depending on the arguments passed, it can override boot flags and either the kernel name or the search path for kernel and modules. boot-conf boot-conf kernelname [...] boot-conf directory [...] boot-conf -flag ... Works like boot described above, but instead of booting immediately, uses autoboot, so it can be stopped. start Reads /boot/defaults/loader.conf, all other loader.conf(5) files specified in it, then loads the desired kernel and modules (if not already loaded). After which you can use the boot or autoboot commmands or simply exit (provided autoboot_delay is not set to NO) to boot the system. start is the command used in the default /boot/loader.rc file (see loader(8)). initialize Initialize the support library so commands can be used without executing start first. Like start, it reads /boot/defaults/loader.conf and all other loader.conf(5) files specified in it (but does not load kernel or modules). Returns a flag on the stack to indicate if any configuration files were successfully loaded. read-conf filename Reads and processes a loader.conf(5) file. Does not proceed to boot. enable-module module Enables the loading of module. disable-module module Disables the loading of module. toggle-module module Toggles the loading of module on and off. show-module module Shows the information gathered in the loader.conf(5) files about the module module. retry Used inside loader.conf(5) files to specify the action after a module loading fails. ignore Used inside loader.conf(5) files to specify the action after a module loading fails. try-include file [file ...] Process script files if they exist. Each file, in turn, is completely read into memory, and then each of its lines is passed to the command line interpreter. If any error is returned by the interpreter, the try-include command aborts immediately, without reading any other files, and silently returns without error. FILES
/boot/loader The loader(8). /boot/loader.4th loader.4th itself. /boot/loader.rc loader(8) bootstrapping script. /boot/defaults/loader.conf File loaded by the start command. EXAMPLES
Standard /boot/loader.rc: include /boot/loader.4th start Load a different kernel with the standard configuration: set kernel="kernel.old" unload boot-conf Read an additional configuration file and then proceed to boot: unload read-conf /boot/special.conf boot-conf Disable the loading of the splash screen module and bitmap and then proceed to boot: unload disable-module splash_bmp disable-module bitmap boot-conf SEE ALSO
loader.conf(5), loader(8) HISTORY
The loader.4th set of commands first appeared in FreeBSD 3.2. AUTHORS
The loader.4th set of commands was written by Daniel C. Sobral <dcs@FreeBSD.org>. BUGS
A British espionage series. BSD
November 13, 2013 BSD
All times are GMT -4. The time now is 10:02 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy