Re: ORA-01555: snapshot too old

In article <7a8q9v$45r$1_at_nnrp1.dejanews.com>,   masseys_at_my-dejanews.com wrote:
> 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
>

The quick & dirty solution would be the following command:

alter system apply buckshot to local DBA;

You have two good solutions:

1. to create larger rollback segments.
2. to commit more frequently.

May the force be with you,
Mladen Gogala

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Feb 16 1999 - 12:19:23 CST