Do you know about using sqlldr? It is a lot faster than trying to write and run a sql file with thousands of insert statements, and is meant to do exactly what you want.
sqlldr will be in your PATH, if you have your environment variables set so that
connects you to the db you want.
loader1.dat is a control file in the current directory
The log file shows errors. If there are errors this helps you to correct input
and remove the good lines that were entered. Then you can rerun.
Shell command:
This User Gave Thanks to jim mcnamara For This Post:
Guys,
I want to insert some values from a log file into a temporary table. the values in the log file looks like this
SV_NAME CC_NAME CP_DISP_RUN_STATE
------- ------------------- -----------------
sble01 ALLTEL WorkMon24Hrs Running
I want to enter the... (2 Replies)
Where to start?
Ok, I need to pick up a Worldpay exchange rates file from a url such as:
https://select.worldpay.com/wcc/info?op=rates&instId=12345&op=rates-today
the http response returns a exchange rates file with content-type "text/plain" content as below:
#Exchange rates for... (2 Replies)
how to assign values in this date format
a=`date +"%H%M%S"`
how to give value of H=22,here in this format so that i can grep 22nd hour.Below is the script
--------------------------------------------------------------------------
a=`date +"%H%M%S"`
for i in *.log
do
cat $i | grep $a... (3 Replies)
hello all,
I am new to shell scripting and to unix... so the following is my assignment..
here i am trying to insert a values into sqlplus database using shell script.
the following is my shell script
InsertDelete.sh
#! /bin/sh
echo "*********The MENU********
1.Insert The Values... (2 Replies)
Here's the problem.
I have a shell script running for every one minute as cronjob that outputs to a log file. I want to be able to take the data from the log file and insert it into a mysql database. The script needs to run at a set period of time and remove the log file data once the insert is... (7 Replies)
Hi All,
I have a directory containing multiple files.
and also a txt file which contains the list of all filenames and certain values.
I want to read the text file line by line and if its 2nd column is matched with the filename in directory, then it must insert the values in 7th column to... (14 Replies)
hi all,
i have one shell script like this
#!/bin/bash -xv
ENV_NAME=`cat $IB_HOME_DIR/cfg/ibProfile.sh | grep "RDM_CONN" | cut -f 2 -d "@"`
CURRENT_DIR=`pwd`;
string=$IB_HOME_DIR
string1="$string/FRGFOLDER/input"
#sed "s/string3/$string1" frg_event_src.sql > modifiedinsert.sql
sqlplus... (2 Replies)
Hi,
I have a requirement where I have an excel sheet with the below values
COL1 COL2 COL3
Germany URGENT NORMAL
I want to cut the values of this excel in such a way that I get the values and pass it to an insert statement
update tbfin set... (2 Replies)
I have a script working out ink percentages
#!/bin/bash
currentcyan=$'iso.3.6.1.2.1.43.11.1.1.9.1.1 = INTEGER: 990'
currentmagenta=$'iso.3.6.1.2.1.43.11.1.1.9.1.2 = INTEGER: 972'
currentyellow=$'iso.3.6.1.2.1.43.11.1.1.9.1.3 = INTEGER: 972'
currentblack=$'iso.3.6.1.2.1.43.11.1.1.9.1.4 =... (1 Reply)
Discussion started by: leshy93
1 Replies
LEARN ABOUT MOJAVE
db_printlog
db_printlog(1) BSD General Commands Manual db_printlog(1)NAME
db_printlog
SYNOPSIS
db_printlog [-NrV] [-h home] [-P password]
DESCRIPTION
The db_printlog utility is a debugging utility that dumps Berkeley DB log files in a human-readable format.
The options are as follows:
-h
Specify a home directory for the database environment; by default, the current working directory is used.
-N
Do not acquire shared region mutexes while running. Other problems, such as potentially fatal errors in Berkeley DB, will be ignored as
well. This option is intended only for debugging errors, and should not be used under any other circumstances.
-P
Specify an environment password. Although Berkeley DB utilities overwrite password strings as soon as possible, be aware there may be a
window of vulnerability on systems where unprivileged users can see command-line arguments or where utilities are not able to overwrite
the memory containing the command-line arguments.
-r
Read the log files in reverse order.
-V
Write the library version number to the standard output, and exit.
For more information on the db_printlog output and using it to debug applications, see Reviewing Berkeley DB log files.
The db_printlog utility uses a Berkeley DB environment (as described for the -h option, the environment variable DB_HOME, or because the
utility was run in a directory containing a Berkeley DB environment). In order to avoid environment corruption when using a Berkeley DB envi-
ronment, db_printlog should always be given the chance to detach from the environment and exit gracefully. To cause db_printlog to release
all environment resources and exit cleanly, send it an interrupt signal (SIGINT).
The db_printlog utility exits 0 on success, and >0 if an error occurs.
ENVIRONMENT
DB_HOME If the -h option is not specified and the environment variable DB_HOME is set, it is used as the path of the database home, as
described in DB_ENV->open.
SEE ALSO db_archive(1), db_checkpoint(1), db_deadlock(1), db_dump(1), db_load(1), db_recover(1), db_stat(1), db_upgrade(1), db_verify(1)Darwin December 3, 2003 Darwin