| Snapshot too old [message #369230] |
Thu, 20 July 2000 11:39  |
Sitarama C Peruvel
Messages: 3
Registered: July 2000
|
Junior Member |
|
|
Hi,
I am getting the error 'SNAPSHOT TOO OLD' when i am running a query in the folloing scenario.
I have two databases A and B. I have a database link D from database B to A. Now, when i run a query "Insert into table x select * from y', i am getting the error snapshot too old. Table x is in databse B under one user while table y is in databse A under some other user. Can anyone please give a justification for this. Thanks in advance.
|
|
|
|
| Re: Snapshot too old [message #369246 is a reply to message #369230] |
Tue, 25 July 2000 19:39  |
Sam
Messages: 255
Registered: April 2000
|
Senior Member |
|
|
Create a big rollback segment (Eg: large_rbs with initial 10m next 10m optimal 20m ---sorry I don't have any idea of the size of your transaction)
set transaction use rollback segment large_rbs;
then execute your transaction....
Will it coming again?
rgds
sam
|
|
|
|
| Re: Snapshot too old [message #369357 is a reply to message #369230] |
Mon, 04 September 2000 06:35 |
Rohit Chandra
Messages: 1
Registered: September 2000
|
Junior Member |
|
|
|
looks like the timestamp at the datafile and the time stamp at the rollback segement have miss match Do execute the same query again might solve the problem...
|
|
|
|
| Re: Snapshot too old [message #369358 is a reply to message #369230] |
Mon, 04 September 2000 06:39 |
Naveen Kumar V
Messages: 16
Registered: February 2000
|
Junior Member |
|
|
|
Are u doing any big transactions in your code. If you want to get rid of this, either increase rollback segment size or commit after certain number of rows depending upon your requirement.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
