Oracle FAQ

Your Portal to the Oracle Knowledge Grid

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

Home -> Community -> Usenet -> c.d.o.server -> Re: "snapshot too old" or "cannot extend rollback segment" errors running PL/SQL script

Re: "snapshot too old" or "cannot extend rollback segment" errors running PL/SQL script

From: <kimmel888_at_my-deja.com>
Date: Wed, 25 Aug 1999 22:31:38 GMT
Message-ID: <7q1qsa$i70$1@nnrp1.deja.com>

Oracle processes do not go over to other rollback segments. Have you tried increasing the size of your rollback segments? Try making less rollback segments and increasing their size, that should fix this problem. As for your test table, does the production table have more columns? Triggers? Etc.... All these wil use rollback.

Hope this helps

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Aug 25 1999 - 17:31:38 CDT

This message: [ Message body ]
Next message: kimmel888_at_my-deja.com: "Java stored procedures questions"
Previous message: Dan Benwell: "Re: Import data in an other schema"
In reply to: Jamie Schrumpf: ""snapshot too old" or "cannot extend rollback segment" errors running PL/SQL script"
Next in thread: Sybrand Bakker: "Re: "snapshot too old" or "cannot extend rollback segment" errors running PL/SQL script"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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