08-07-2015
It was not accidentally tagged.
Solution is :
By using the positional character numbers. i have loaded the records into staging table.
This User Gave Thanks to arun888 For This Post:
10 More Discussions You Might Find Interesting
1. Solaris
i want to export a database (full schema) so that I can import the database to a windows 2000 server. The database is sitting on a unix-sun solaris box ver 8.. What are the commands...
I am a bit rusty at unix at the moment!
Cheers
E (4 Replies)
Discussion started by: etravels
4 Replies
2. Shell Programming and Scripting
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)
Discussion started by: madhunk
8 Replies
3. Shell Programming and Scripting
Hi ,
Can anyone help me regarding loading a unix file data to oracle database table using shell scripts?
I wanted to grep only this data from a spool file
sql_test.txt
99
00:00:00:01
but if I use grep I am getting format
sql_test.txt
99 rows selected.
Elapsed:... (2 Replies)
Discussion started by: ran16
2 Replies
4. UNIX for Advanced & Expert Users
I am having a file which has the following data
123424
2354235
142424
43423
1434
.
.
.
.
etc
i want to pass these values to oracle at a time by using a file.. can someone suggest me a answer...
waiting...... (1 Reply)
Discussion started by: vidyadhar85
1 Replies
5. UNIX for Advanced & Expert Users
The binary file is
ELF-64 executable object file - IA64.
How i know that the source is
Is there any comamnd in unix i can read these kind of files or use a thirty party software?
Thanks for your help (8 Replies)
Discussion started by: alexcol
8 Replies
6. Shell Programming and Scripting
Dear All
I am trying to write one shell which will be running through Cron which contain one SQL query. But I want to draw/fetch the Username password and Instance name (required to loging to the database) from one single file to run that SQL query . Also this file contain details of multiple... (2 Replies)
Discussion started by: jhon
2 Replies
7. Shell Programming and Scripting
Hi all,
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.
#!/bin/ksh
ORACLE_SID=db1... (7 Replies)
Discussion started by: Tuut-Tuut
7 Replies
8. Shell Programming and Scripting
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
9. Shell Programming and Scripting
Hi everyone,
Simple question.
I have a comma-delimited file, aux.txt, with the following contents (all in one line):
'value1','value2','value3',...,'valueN'
I would like to know if there's a way I can use that file inside a sql script in a where clause, like so:
select myfield1 from mytable... (6 Replies)
Discussion started by: gacanepa
6 Replies
10. Shell Programming and Scripting
Hi,
Is it possible to pass oracle connection information from a configuration file and use that to connect to oracle database in my unix shell scripts. Following is the scenario:
(1) I would like to save oracle connection string details in a configuration file (ex., dbconfig.txt)
(2) from my... (6 Replies)
Discussion started by: sudhakaratp
6 Replies
LEARN ABOUT DEBIAN
xen-update-image
XEN-UPDATE-IMAGE(8) Perl Programmers Reference Guide XEN-UPDATE-IMAGE(8)
NAME
xen-update-image - Update the software installed upon offline Xen images.
SYNOPSIS
xen-update-image [options] imageName1 imageName2 .. imageNameN
Help Options:
--help Show this scripts help information.
--manual Read this scripts manual.
--version Show the version number and exit.
General Options:
--dir Specify the directory which contains the image(s).
--lvm Specify the LVM volume group which contains the image(s).
--evms Specify the EVMS container which contains the image(s).
OPTIONS
--dir Specify the directory which contains the image(s).
--evms Specify the EVMS container which contains the image(s).
--help Show the script help.
--lvm Specify the LVM volume group which contains the image(s).
--manual Read the manual.
--version Show the version number and exit.
DESCRIPTION
xen-update-image is a simple script which allows you to update
a Xen image of Debian which has been created with xen-create-image.
It does this by mounting the image inside a temporary directory
then running:
apt-get update
apt-get upgrade
NOTE If the image is already running within Xen this will cause
corruption otherwise it will allow you to update your image without
booting it.
EXAMPLES
The following assumes there are two images which are not currently
running. The images are called 'test.my.flat', and 'x11.my.flat'.
Updating both images can be accomplished by executing:
xen-update-images --dir=/home/xen test.my.flat x11.my.flat
AUTHORS
Steve Kemp, http://www.steve.org.uk/
Axel Beckert, http://noone.org/abe/
StA~Xphane Jourdois
LICENSE
Copyright (c) 2005-2009 by Steve Kemp, (c) 2010 by The Xen-Tools Development Team. All rights reserved.
This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself. The LICENSE file contains the
full text of the license.
4.3.1 2012-06-30 XEN-UPDATE-IMAGE(8)