Xref: alice comp.databases.oracle.misc:26216
Path: alice!news-feed.fnsi.net!netnews.com!newspeer1.nac.net!news.maxwell.syr.edu!newsfeed.gamma.ru!Gamma.RU!news.nevalink.ru!news.wplus.spb.ru!not-for-mail
From: "Serge" <msl@office.peterstar.com>
Newsgroups: comp.databases.oracle.misc
Subject: Re: ORA-01555: snapshot too old
Date: Mon, 15 Feb 1999 13:17:51 +0300
Organization: WEBPlus Ltd.
Lines: 35
Message-ID: <7a8s4e$7qv$1@news.wplus.spb.ru>
References: <7a8q9v$45r$1@nnrp1.dejanews.com>
Mime-Version: 1.0
Content-Type: text/plain;  charset=koi8-r
Content-Transfer-Encoding: 8bit
X-Trace: news.wplus.spb.ru 919073742 8031 194.8.162.104 (15 Feb 1999 10:15:42 GMT)
X-Complaints-To: usenet@news.wplus.spb.ru
NNTP-Posting-Date: 15 Feb 1999 10:15:42 GMT
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.0810.800
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.0810.800

You need:
1. Create a big rollback segment - f.e. big_rs
2. Before copy set transaction - SET TRANSACTION USE ROLLBACK SEGMENT
big_rs;
Serge Malyshev sermal@usa.net

<masseys@my-dejanews.com> wrote in message
news:7a8q9v$45r$1@nnrp1.dejanews.com...
>Hi,
>
>I am trying to copy a large table from one user to another using the
commands
>
>set copycommit 1
>set arraysize 1000
>COPY FROM <us>/<pw>@<cs> append POSTCODE using select * from POSTCODE;
>
>and  I get an error lien stating
>
>ORA-01555: snapshot too old: rollback segment number 5 with name "RB4" too
>small
>
>What does this mean and how do I fix it.
>
>FYI the database I am copying from has 1.55 million records and the above
>command
>fails after 1.35 million records.
>
>
>Thanks
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own