06-06-2006
Thank you X....
If anybody has encountered this situation, please help me with a sample shell script...
Put me in the track and I will work on it...
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
I have been tasked with archiving Oracle tables. The data is on raw devices, and possibly will span multiple logical volumes.
Has anyone ever had to do this? How did you accomplish it?
Any references to accomplish this would be greatly appreciated.
Thanks, (2 Replies)
Discussion started by: isenhart
2 Replies
2. Shell Programming and Scripting
Hi all,
How to load variable value into Oracle table? I have created a file validation shell script. After the validation completes, i need to update a Oracle table with the variable value...
Can someone help me how to do it? I have searched, but not able to get answer.
i have 4 variables... (2 Replies)
Discussion started by: Amit.Sagpariya
2 Replies
3. Shell Programming and Scripting
Hi ,
I want to read the data from 9 tables in oracle DB into 9 different files in the same connection instance (session). I am able to get data from one table to one file with below code :
X=`sqlplus -s user/pwd@DB <<eof
select col1 from table1;
EXIT;
eof`
echo $X>myfile
Can anyone... (2 Replies)
Discussion started by: net
2 Replies
4. Shell Programming and Scripting
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)
Discussion started by: Shivdatta
1 Replies
5. Programming
HI All,
I am using Oracle 10g . Want to take dumps(.dmp log) from many tables with where clause having same schema.
ex :
TB_MTH_ORA_CAB "WHERE TRUNC(dw_entry_dt )= TO_DATE('01-JAN-2011')"
TB_AM_AT_OSS_MAT "WHERE TRUNC(dw_entry_date )>= TO_DATE('01-JAN-2011') AND TRUNC(dw_entry_date )<=... (4 Replies)
Discussion started by: Perlbaby
4 Replies
6. Shell Programming and Scripting
dear all
please help me !
i need a script for exporting the selected tables of oracle database installed on CentOs.
i waiting your response.
thanks and regards (6 Replies)
Discussion started by: amirzargaran
6 Replies
7. Shell Programming and Scripting
multiple files to load into different tables,
I have a script show below, but this script loads data from txt file into a table,
but i have multiple input files(xyzload.txt,xyz1load.txt,xyz2load.txt......) in the unix folder ,
can we load these files in diff tables (table 1, table2... (0 Replies)
Discussion started by: nani1984
0 Replies
8. Shell Programming and Scripting
multiple files to load into different tables,
I have a script show below, but this script loads data from txt file into a table,
but i have multiple input files(xyzload.txt,xyz1load.txt,xyz2load.txt......) in the unix folder ,
can we load these files in diff tables (table 1, table2... (1 Reply)
Discussion started by: nani1984
1 Replies
9. Red Hat
Hello friends,
We have RHEL 7.5 server with latest updates. We needed to install Oracle 12 DB on it so chose "easy method" of installing "oracle-database-server-12cR2-preinstall-1.0-3.el7.x86_64.rpm" and then installed oracle DB. Everything went smooth and all OK but later we noticed that it has... (4 Replies)
Discussion started by: prvnrk
4 Replies
10. UNIX for Advanced & Expert Users
Hi,
Please let me know if you have any thoughts on how to read a table that has all the oracle sql files or shell scripts at the job and step level to identify all the tables that does merge, update, delete, insert, create, truncate, alter table (ALTER TABLE XYZ RENAME TO ABC) and call them out... (1 Reply)
Discussion started by: techmoris
1 Replies
LEARN ABOUT CENTOS
afsetvirtualbyteorder
AFSETVIRTUALSAMPLEFO(3) AFSETVIRTUALSAMPLEFO(3)
NAME
afSetVirtualByteOrder, afSetVirtualChannels, afSetVirtualPCMMapping, afSetVirtualSampleFormat - set the virtual data format for a track in
an audio file
SYNOPSIS
#include <audiofile.h>
int afSetVirtualByteOrder (AFfilehandle file, int track, int byteOrder);
int afSetVirtualChannels (AFfilehandle file, int track, int channels);
int afSetVirtualSampleFormat (AFfilehandle file, int track,
int sampleFormat, int sampleWidth);
int afSetVirtualPCMMapping (AFfilehandle file, int track,
double slope, double intercept, double minclip, double maxclip);
PARAMETERS
o file is an AFfilehandle which refers to an open audio file and is usually created by afOpenFile.
o track is an integer which identifies a particular track in an open audio file. The only valid track is AF_DEFAULT_TRACK for all
currently supported file formats.
o sampleFormat is an integer which denotes a virtual sample format. Valid values are AF_SAMPFMT_TWOSCOMP, AF_SAMPFMT_UNSIGNED,
AF_SAMPFMT_FLOAT, and AF_SAMPFMT_DOUBLE.
o sampleWidth is a positive integer which specifies the number of bits in a sample.
o channels is a positive integer which specifies the number of interleaved audio channels in the given audio track.
o byteOrder is an integer which specifies the virtual byte order of samples in the given audio track. byteOrder can be either
AF_BYTEORDER_BIGENDIAN or AF_BYTEORDER_LITTLEENDIAN.
o slope and intercept are double-precision floating point values which indicate the audio data sample slope and zero-crossing value,
respectively, for the given sample format.
o minclip and maxclip are double-precision floating point values which indicates the minimum or maximum sample values to be returned.
Any values less than minclip will be set to minclip, and any values greater than maxclip will be set to maxclip.
RETURN VALUE
These functions return 0 for success and -1 for failure.
AUTHOR
Michael Pruett <michael@68k.org>
Audio File Library 0.3.6 03/06/2013 AFSETVIRTUALSAMPLEFO(3)