I need some help from Oracle and UNIX expertise point of view.
I have two tables, METADATA_A and METADATA_B. I need to switch loading these tables. If we load METADATA_A today, the following
week we would have to load METADATA_B.
There is a public synonym "METADATA" that sits on top of these two tables.
1) Find out which table is in use right now..
2) Truncate opposite table
3) Load opposite table
4) Validate by doing a count * on the table to check the rows loaded.
5) Finally, switch synonym
Can this be achieved using shell script? Please advice.
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)
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)
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)
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)
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)
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)
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)
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)
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)
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 DEBIAN
freebsd-yyfix
YYFIX(1) BSD General Commands Manual YYFIX(1)NAME
yyfix -- extract tables from y.tab.c
SYNOPSIS
yyfix file [tables]
DESCRIPTION
Programs have historically used a script (often named ``:yyfix'') to extract tables from the yacc(1) generated file y.tab.c. As the names of
the tables generated by the current version of yacc(1) are different from those of historical versions of yacc(1), the shell script yyfix is
provided to simplify the transition.
The first (and required) argument to yyfix is the name of the file where the extracted tables should be stored.
If further command line arguments are specified, they are taken as the list of tables to be extracted. Otherwise, yyfix attempts to deter-
mine if the y.tab.c file is from an old or new yacc(1), and extracts the appropriate tables.
The tables ``yyexca'', ``yyact'', ``yypact'', ``yypgo'', ``yyr1'', ``yyr2'', ``yychk'', and ``yydef'' are extracted from historical versions
of yacc(1).
The tables ``yylhs'', ``yylen'', ``yydefred'', ``yydgoto'', ``yysindex'', ``yyrindex'', ``yygindex'', ``yytable'', ``yyname'', ``yyrule'',
and ``yycheck'', are extracted from the current version of yacc(1).
FILES
y.tab.c File from which tables are extracted.
SEE ALSO yacc(1)HISTORY
The yyfix command first appeared in 4.4BSD.
BSD March 23, 1993 BSD