Sponsored Content
Full Discussion: txt file to oracle database
Top Forums Shell Programming and Scripting txt file to oracle database Post 65784 by jorhul on Wednesday 9th of March 2005 05:48:17 AM
Old 03-09-2005
Hi guys, i'm being a bt dumn here but will be great if you can help!

I'm writing this script(named as Jo.sh), now i'm wondering if i need to include the ctl file within the unix script or should the ctl file be called from within the script file. Here are the details:

Should the script look like this:

#jo.sh (this is the script file on my unix machine)
nice grep sent pac.txt |nice grep 'log ins'|nice grep spot_markup|cut -c12-23>jo.txt
nice grep sent pac.txt |nice grep 'log ins'|nice grep spot_markup|cut -c107-113>jo1.txt

paste jo.txt jo1.txt>pir.dat

# pir.ctl

sqlplus -s asasas/asasa@asas.com << ++ > /dev/null

LOAD DATA
INFILE 'pir.dat'
BADFILE 'pir.bad'
DISCARDFILE 'pir.dsc'

INTO TABLE "PIRSUP_GID_ORDERS"
INSERT
(GID_ID,DEAL_TIME)


cheers,
Jo
 

6 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how to extract the data from database (oracle) and send the output as an .xls file?

Hi, How to extract the data from Oracle database and sent the output data to mails using mailx command with .xls attachement? Here i know how to connect the database using unix shell script and how to use the mailx command in UNIX script But i don't know how to use the .xls format file (i... (1 Reply)
Discussion started by: psiva_arul
1 Replies

2. Shell Programming and Scripting

Find similar entry in a .txt file acting as a database.

May i know how do i go along finding similar entry in a .txt file, which is used a as a "database" and post and error saying the entry existed when we key in the entry. ---------- Post updated at 05:18 PM ---------- Previous update was at 05:16 PM ---------- i mean post an error saying the... (5 Replies)
Discussion started by: santonio
5 Replies

3. Solaris

Can't create database after Oracle Database installation

I installed Oracle 10 software on Solaris 11 Express, everything was fine execpt I can't create database using dbca.rsp file. I populated file with following options. OPERATION_TYPE = "createDatabase" GDBNAME = "solaris_user.domain.com" SID = "solaris_user" TEMPLATENAME = "General... (0 Replies)
Discussion started by: solaris_user
0 Replies

4. Shell Programming and Scripting

Using csh / awk / sed to compare database sizes in a txt file

Hello, I have an output file showing database sizes across the 3 environments that I use (LIVE, TEST & DEVELOPMENT). I am trying to write a script that lets me know if the size of a db on one environment is different to its corresponding db on the other environments. Here is an example... (4 Replies)
Discussion started by: stevie_g
4 Replies

5. Shell Programming and Scripting

shellscript to read data from txt file and import to oracle db

Hi all, Help needed urgently. I am currently writing a shellscript to read data/record from a flat file (.txt) file, and import/upload the data to oracle database. The script is working fine, but it takes too long time (for 18000 records, it takes around 90 mins). I guess it takes so long... (1 Reply)
Discussion started by: robot_mas
1 Replies

6. UNIX and Linux Applications

Identify a specific environment Oracle variable to connect a remote Oracle database ?

Good evening I nned your help pls, In an unix server i want to connect to a remote oracle databse server by sqlplus. I tried to find out the user/passwd and service name by env variable and all Ive got is this: ORACLE_SID_REPCOL=SCL_REPCOL ORACLE_SID=xmeta ORACLE_SID_TOL=SCL_PROTOLCOL... (2 Replies)
Discussion started by: alexcol
2 Replies
NOTMUCH-HOOKS(5)						File Formats Manual						  NOTMUCH-HOOKS(5)

NAME
notmuch-hooks - hooks for notmuch SYNOPSIS
$DATABASEDIR/.notmuch/hooks/* DESCRIPTION
Hooks are scripts (or arbitrary executables or symlinks to such) that notmuch invokes before and after certain actions. These scripts reside in the .notmuch/hooks directory within the database directory and must have executable permissions. The currently available hooks are described below. pre-new This hook is invoked by the new command before scanning or importing new messages into the database. If this hook exits with a non- zero status, notmuch will abort further processing of the new command. Typically this hook is used for fetching or delivering new mail to be imported into the database. post-new This hook is invoked by the new command after new messages have been imported into the database and initial tags have been applied. The hook will not be run if there have been any errors during the scan or import. Typically this hook is used to perform additional query-based tagging on the imported messages. SEE ALSO
notmuch(1), notmuch-config(1), notmuch-count(1), notmuch-dump(1), notmuch-new(1), notmuch-reply(1), notmuch-restore(1), notmuch-search(1), notmuch-search-terms(7), notmuch-show(1), notmuch-tag(1) Notmuch 0.13.2 2012-06-01 NOTMUCH-HOOKS(5)
All times are GMT -4. The time now is 09:25 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy