06-02-2008
Problem: Run schedular to copy from one table to other
Check if records of table B are 1 month old. if yes then Truncate table B_SNAPSHOT and then copy data from B to SNAPSHOT_B table otherwise no need to copy.
Run a schedular after every 15 minutes.
The tables B and SNAPSHOT_B has the below structure(same for both):
PROCESS_NAME
MQ_NAME
LAST_UPD_TMS
How I can do that using Unix and Oracle 9i.Need help with example script.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have to create a sheduler to run the shell scripts one by one(dependency).
Suppose i have 10 scripts.
For all the 10 scripts i have a database table containing these scripts_names and status.
Executing the first script.if the first status script is only 'success' then go to next... (4 Replies)
Discussion started by: laknar
4 Replies
2. UNIX for Dummies Questions & Answers
hi
i'm a bit stuck trying to find the correct syntax in order to run a cron job which just truncates all info from a single table in my database
i have a main database - db1
and i have a table in that database - userips
i wish to create a cron job that truncates or removes all the info... (9 Replies)
Discussion started by: wingchun22
9 Replies
3. Shell Programming and Scripting
Hi All,
I need to convert the data from excel to database table in sybase. Please provide some sample script..
thanks,
Royal. (1 Reply)
Discussion started by: royal9482
1 Replies
4. UNIX for Advanced & Expert Users
Hi,
I was looking for a schedular(a simple script would do or a tool) that would invoke jobs on few conditions:
1. Every day
2. Every working day(Considering customized holiday list, from a file or table)
3. Weekly
4. being able to define variable dependency. like on every day run,... (1 Reply)
Discussion started by: ahmedwaseem2000
1 Replies
5. Red Hat
Ok. I screwed up. Using dd, I made a bit-for-bit copy of disk /dev/hda, which contains 3 partitions.
dd if=/dev/hda of=olddrive.iso bs=2048k
However, I neglected to make a copy of the partition table. I'd like to mount partition 3, /dev/hda3, which is an xfs filesystem, but obviously I don't... (2 Replies)
Discussion started by: dangral
2 Replies
6. UNIX for Dummies Questions & Answers
I have found a question from the exercises of my study mat. The question is
"Why are there a in-core copy and a disk-copy of i-node block and super block?"
If any one know the proper answer then please send me..... (1 Reply)
Discussion started by: dearanik
1 Replies
7. UNIX for Dummies Questions & Answers
Hello
I am very new to Unix scripting,
I am using informatica etl,which is schedule by tidal enterprise.
I have a scenario where assume that Tidal only knows how to run jobs at a given time and does not know how to retry.
So i want to know weather can i write a shell script such that... (1 Reply)
Discussion started by: bluestarmoon
1 Replies
8. Shell Programming and Scripting
Hi All,
I need script to perform below task.
1. I have a script in one server and need to copy this script to remote server
2. login in to remote server
3. run the script which i copied to this server.
#!/bin/bash
read a
scp /tmp/script.sh user@hostname:/tmp
ssh user@$a
./scirpt.sh
... (2 Replies)
Discussion started by: bapu1981
2 Replies
9. High Performance Computing
We have a server with 160 hyper-threaded cpu's threads and 2Tb of RAM. I need to implement command line job queue and parallel thread usage for multiple user environment kindly suggest necessary tools to be installed.
I have understanding that sun grid engine like applications are available for... (0 Replies)
Discussion started by: vaibhavvsk
0 Replies
10. Shell Programming and Scripting
I have 100 Scripts, each containing 10-15 SQL's in them.
Each Script run for 40 mins to 1 hour 30 mins.
In the event of Failure in any step, if i re-start the Script, it will start running from the beginning. Which is waste of time. So in order handle this, i made the script to run from the... (7 Replies)
Discussion started by: kiran1992
7 Replies
DTIF(5) File Formats Manual DTIF(5)
Name
DTIF - Digital Table Interchange Format
Description
Digital Table Interchange Format (DTIF) is the standard format for the storage and interchange of documents that contain data tables, for-
mulas, and spreadsheets. You can use DTIF to store and retrieve database information, interchange spreadsheets, and reference table data in
compound documents.
DTIF defines the logical structure and physical layout of a data table, the values within the table (absolute data and/or expressions), and
presentation attributes (formatting) to be used when displaying or printing the table. DTIF works with Digital Document Interchange Format
(DDIF) so that you can store or reference DTIF tables in DDIF-encoded compound documents.
A DTIF document can contain a sequence of one or more tables and is uniquely identified by a product name, a version number, and other
descriptive information such as the document's title and creation date. Each DTIF table is a 2-dimensional display of data values orga-
nized in columns and rows that has its own structure and table data stored in cells.
In DTIF documents, attributes specify the type and format of information pertaining to the data stored in a table. Column attributes
describe information for all the cells in a particular column, whereas generic column attributes can be applied to any column in any table
that references them. Format attributes define the printed and displayed presentation of data stored in the table. Format attributes can
also be redefined at the window, column, or cell level.
See Also
CDA(5), DDIF(5), DTIF(5)
Compound Document Architecture Manual
DTIF(5)