Sponsored Content
Top Forums Shell Programming and Scripting Load Oracle tables and switch public synonym Post 302075750 by madhunk on Tuesday 6th of June 2006 03:20:11 PM
Old 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

copying oracle tables from raw disk

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

To load data from variable to oracle table ....???

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

Reading data from multiple tables from Oracle DB

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

Load data from a flat file to oracle.

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

Oracle 10g tables dumps

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

Scripts for exporting backup from selected tables of Oracle DB

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,

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

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

How to switch back from Oracle Kernel to RedHat?

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

Identify tables from Oracle sql scripts

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
AFWRITEFRAMES(3)														  AFWRITEFRAMES(3)

NAME
afWriteFrames - write sample frames to a track in an audio file SYNOPSIS
#include <audiofile.h> AFframecount afWriteFrames(AFfilehandle file, int track, const void *data, AFframecount count); DESCRIPTION
afWriteFrames attempts to write up to count frames of audio data from the buffer data to the audio file handle file. PARAMETERS
file is a valid file handle returned by afOpenFile(3). track is always AF_DEFAULT_TRACK for all currently supported file formats. data is a buffer of sample frames to be written to the file. count is the number of sample frames to be written. RETURN VALUE
afWriteFrames returns the number of sample frames successfully written to file. ERRORS
afWriteFrames can produce these errors: AF_BAD_FILEHANDLE the file handle was invalid AF_BAD_TRACKID the track is not AF_DEFAULT_TRACK AF_BAD_WRITE writing audio data to the file failed AF_BAD_LSEEK seeking within the file failed SEE ALSO
afReadFrames(3) AUTHOR
Michael Pruett <michael@68k.org> Audio File Library 0.3.6 03/06/2013 AFWRITEFRAMES(3)
All times are GMT -4. The time now is 08:20 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy