Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA-01555: snapshot too old
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_at_usa.net
<masseys_at_my-dejanews.com> wrote in message
news:7a8q9v$45r$1_at_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
Received on Mon Feb 15 1999 - 04:17:51 CST