From oracle-l-bounce@freelists.org Wed Jun 2 08:31:25 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i52DVAG08817 for ; Wed, 2 Jun 2004 08:31:20 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i52DV0608793 for ; Wed, 2 Jun 2004 08:31:10 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1EFBF72C4DF; Wed, 2 Jun 2004 08:17:42 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 09077-27; Wed, 2 Jun 2004 08:17:42 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7113872C3EC; Wed, 2 Jun 2004 08:17:41 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 02 Jun 2004 08:16:23 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B123D72C411 for ; Wed, 2 Jun 2004 08:16:22 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 08817-22 for ; Wed, 2 Jun 2004 08:16:22 -0500 (EST) Received: from mail.cybcon.com (mail.cybcon.com [216.190.188.5]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 290DC72C315 for ; Wed, 2 Jun 2004 08:16:22 -0500 (EST) Received: from dsl2-6 (dsl2-6.cybcon.com [208.186.116.6]) by mail.cybcon.com (8.11.6/8.11.6) with ESMTP id i52DYVk31334 for ; Wed, 2 Jun 2004 06:34:31 -0700 Subject: Re: (no subject) From: Jared Still To: Oracle-L Freelists In-Reply-To: <011201c4487b$51190cf0$63000050@newserver> References: <011201c4487b$51190cf0$63000050@newserver> Content-Type: text/plain Message-Id: <1086183837.15792.513.camel@poirot> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 Date: Wed, 02 Jun 2004 06:43:57 -0700 X-CyberConnectics-MailScanner2-Information: Spam/Virus Scanned at CyberConnectics X-CyberConnectics-MailScanner2: Found to be clean X-CyberConnectics-MailScanner2-SpamCheck: X-MailScanner-From: jkstill@cybcon.com X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 1755 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jkstill@cybcon.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org On Wed, 2004-06-02 at 01:26, Computer Centre - NIIPL wrote: > Dear All, > > We are getting the following error during database export. > > ORA-1555 :- snapshot too old. > > How to assign a big RBS to the export session. > There are methods to deal with this. If you are using a third party app, and downtime is not available, fixing the app, as has been suggested already, may not be possible. One method is to create new rollback segments with a very large tablespace, larger than you expect to need during the duration of the export. Assign a transaction to each rollback segment, and do not commit it. This will force the rollback segs to extend rather than wrap. When done, drop the temp RBS, bring the old ones back online, drop the temp RBS tablespace and data files. This has worked very well for me in the past with very long running SAP jobs ( couldn't fix the source code ). Details may be found at ixora.com.au ( of course ) Jared ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------