I'm traying to run a script on Unix with in it sql +.
In this script I want to load a externall file that stand on my unix system into a tmp table of a oracle db, but for some reason it won't work.
Find below the script.
Code:
#!/bin/ksh
ORACLE_SID=db1
ORACLE_HOME=/user/oracle/product/920
PATH=$PATH:$ORACLE_HOME/bin
INPUT=/tmp/input.txt
export ORACLE_SID
export ORACLE_HOME
sqlplus -s db/db@db1 << xxx
set FEEDBACK ON
set TRIMS ON
set ECHO OFF
set LINESIZE 1500
set PAGESIZE 0
set COLSEP '|'
set TERM OFF
set AUTOCOMMIT ON
whenever sqlerror exit sql.sqlcode
whenever oserror exit sql.oscode
drop table my_table_tmp;
create table my_table_tmp (
field1 VARCHAR2(10),
field2 VARCHAR2(10),
field3 VARCHAR2(15)
) tablespace USERS;
INSERT INTO my_table_tmp
VALUES ('field1', 'field2', 'field3')
FROM $INPUT
commit;
exit
xxx
Last edited by pludi; 11-23-2009 at 04:26 PM..
Reason: code tags, please...
Hi all
I need to input values in a .csv file into my Oracle table running in Unix, I wonder what would be the command to do so...
The values are recorded in an excel file and I tried using a formatted text file to do so but failed because one of the field is simply too large to fit in the... (5 Replies)
Hi all
I need to input values in a .csv file into my Oracle table running in Unix, I wonder what would be the command to do so...
The values are recorded in an excel file and I tried using a formatted text file to do so but failed because one of the field is simply too large to fit in the... (4 Replies)
I'm having a oracle server and i'm having a table in that.
I'm having a linux server which is in network with the oracle server. I need to write a c program in linux env when on execution loads the table with the text file given as input.
Please explain me the flow of process in that and also... (6 Replies)
I have a tab delimited file which has 27 character fields. The file needs to be loaded into an Oracle table. But the challenge is that everytime the file comes it may or may not have values in all 27 fields.
Column Definition of the 27 fields:
TYPE: Char (1)
NAME: Char (30)
CUSTOM_VAL: Char... (8 Replies)
Hi all,
I have a data like,
0,R001,2,D
this wants to be loaded into a oracle database table.
Pl let me know how this has to be done.
Thanks in advance (2 Replies)
I have a flat file with records like
Header
123 James Williams Finance2000
124 Pete Pete HR 1500
125 PatrickHeather Engg 3000
Footer
The structure is:
Eno:4 characters
Name:8 characters
Surname : 9 characters
Dept:7 characters
Sal:4characters
These are sample... (1 Reply)
I have a requirement to upload a file to the MS sharepoint site using unix or any other programming language. Does sharepoint support ftp? I heard it doesn't ...is it true...if yes is it different from what regular ftp we use....is there any other programming way out to upload the file to... (1 Reply)
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 can anyone help me with a script to load output of the .ksh file into an Oracle database. I have attached sample output of the information that i need to load to the database (2 Replies)
Experts.
I have created a oracle table as below.
create table xml_tab
(
File_No number ,
File_content Varchar2(2000),
file_type xmltype
);
Daily we are receiving many XML files as below.
here is our sample xml file.
File1 : (7 Replies)
Discussion started by: vasuvv
7 Replies
LEARN ABOUT HPUX
cmhaltserv
cmhaltserv(1m)cmhaltserv(1m)NAME
cmhaltserv - halt a service from the high availability package halt script
SYNOPSIS
cmhaltserv [-v] service_name
DESCRIPTION
cmhaltserv is used only in the high availability package halt script to halt a service.
To stop a package service, the running package halt script must be running as superuser(UID=0), or as a user with access policy of
FULL_ADMIN allowed in the cluster configuration file. See access policy in cmquerycl(1) or cmmakepkg(1).
If any part of a package is marked down, the package halt script is executed as part of the recovery process.
This command sends a SIGTERM signal to the PID and the corresponding process group of the monitored service. If this signal is caught by
the running application, it is up to the application to ensure that the processes will be terminated.
Options
cmhaltserv supports the following options:
-v Verbose output will be displayed.
RETURN VALUE
cmhaltserv returns the following values:
0 Successful completion.
1 Command failed.
EXAMPLES
To halt the service db1, do the following:
# Halt the service db1
cmhaltserv db1
This line should only be executed within a package halt script.
AUTHOR
cmhaltserv was developed by HP.
SEE ALSO cmmakepkg(1m), cmquerycl(1m), cmmodnet(1m), cmrunserv(1m).
Requires Optional Serviceguard Software cmhaltserv(1m)