Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> sanpshot too old

sanpshot too old

From: Francis Wong <wongfrancis_at_home.com>
Date: Sat, 25 Mar 2000 20:27:37 GMT
Message-ID: <Zi9D4.2379$q5.98627@news1.rdc2.on.home.com>


This is the situation. During batch processing, the UNIX shell script calls a Pro*C program to extract data from a remote database and then insert the data into a local table A. Once it is finished(commited), the shell script then calls another one in background(using nohup) to create index for the table A. It then continues running by updating another table. The program uesd to create index return the error 'snapshot too old'. Sine the server is dedicated to run one application and I am sure there is no other program running to update table A at the same time, why will this error happen? Received on Sat Mar 25 2000 - 14:27:37 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US