Cascading Triggers

2003-06-09 Thread carol . legros
Hi listers... I have a question related to triggers. One of the developers here has created two triggers as follows : Trigger #1 is an AFTER UPDATE trigger on TABLE-A - the trigger has PL/SQL code including an UPDATE dml statement on TABLE-B.COL-2 Trigger #2 is an AFTER UPDATE trigger on

RE: Cascading Triggers

2003-06-09 Thread carol . legros
Thanks for the responses so far... The transactions weren't declaraed as autonomous, so I, too, expect what you suggest. The two columns in question are of the same datatype -- numeric. This is a strange one. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/09/2003 04:14 PM Please

VLDB (oltp) and RMAN

2003-06-20 Thread carol . legros
). I'm aware of the fact that I may bump into hardware limitations, and I'm going to discuss the hardware and tape limitations (if there are any) with my Sun server sys admin. Thanks in advance, Carol Legros

Re: VLDB (oltp) and RMAN

2003-06-23 Thread carol . legros
the hardware and tape limitations (if there are any) with my Sun server sys admin. Thanks in advance, Carol Legros

tuning : file number translation table

2003-07-18 Thread carol . legros
I'm hoping someone out there has experienced this problem... I can't seem to find many posts on MetaLink that discuss this. My environment : - I am running a 500 Gig OLTP database in a Solaris environment. I have some 0+1 disk available, but mostly RAID5 (array) for the

RE: tuning : file number translation table

2003-07-18 Thread carol . legros
Hi Mladen, Thanks for the advice. I *never* would've guessed this! A quick look at the Oracle Install Guide mentions NINODE for an HP environment. But I don't see what the comparable parameter would be in Solaris. (Or, is it the same, but the install guide just doesn't mention it.) Thanks