Problem: Run schedular to copy from one table to other


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Problem: Run schedular to copy from one table to other
# 1  
Old 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.
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Run the Script from any stage by updating data from Oracle Table.

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

2. High Performance Computing

Job Schedular for Suse Enterprise SLES 11 SP2

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

3. Shell Programming and Scripting

Copy and run that script in Remote server

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

4. UNIX for Dummies Questions & Answers

Unix Shell Script on Tidal schedular for ETL

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

5. UNIX for Dummies Questions & Answers

What is in-core copy and disk-copy of i-node table?

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

6. Red Hat

mounting a copy of a disk without patition table

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

7. UNIX for Advanced & Expert Users

Schedular

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

8. Shell Programming and Scripting

Sample ksh script for copy the data from excel to database table ?

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

9. UNIX for Dummies Questions & Answers

how to run cron job to truncate database table

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

10. Shell Programming and Scripting

Creating a Schedular to Run the Jobs.

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
Login or Register to Ask a Question
Font::TTF::Loca(3)					User Contributed Perl Documentation					Font::TTF::Loca(3)

NAME
Font::TTF::Loca - the Locations table, which is intimately tied to the glyf table DESCRIPTION
The location table holds the directory of locations of each glyph within the glyf table. Due to this relationship and the unimportance of the actual locations when it comes to holding glyphs in memory, reading the location table results in the creation of glyph objects for each glyph and stores them here. So if you are looking for glyphs, do not look in the "glyf" table, look here instead. Things get complicated if you try to change the glyph list within the one table. The recommendation is to create another clean location object to replace this table in the font, ensuring that the old table is read first and to transfer or copy glyphs across from the read table to the new table. INSTANCE VARIABLES
The instance variables do not start with a space glyphs An array of glyph objects for each glyph. glyphtype A string containing the class name to create for each new glyph. If empty, defaults to Font::TTF::Glyph. METHODS
$t->new Creates a new location table making sure it has a glyphs array $t->read Reads the location table creating glyph objects (Font::TTF::Glyph) for each glyph allowing their later reading. $t->out($fh) Writes the location table out to $fh. Notice that not having read the location table implies that the glyf table has not been read either, so the numbers in the location table are still valid. Let's hope that "maxp/numGlyphs" and "head/indexToLocFmt" haven't changed otherwise we are in big trouble. The function uses the OUTLOC location in the glyph calculated when the glyf table was attempted to be output. $t->out_xml($context, $depth) No need to output a loca table, this is dynamically generated $t->glyphs_do(&func) Calls func for each glyph in this location table in numerical order: &func($glyph, $glyph_num) BUGS
None known AUTHOR
Martin Hosken Martin_Hosken@sil.org. See Font::TTF::Font for copyright and licensing. perl v5.16.3 2012-02-23 Font::TTF::Loca(3)