Re: [ORA734] How to avoid rollback segment use when copying data?

From: Eric Parker <eric.parkerthedross_at_virgin.net>
Date: Wed, 6 Aug 2003 11:34:53 +0100
Message-ID: <lR4Ya.5939$Kx1.83690@newsfep4-glfd.server.ntli.net>

"Gert Van Gaever" <gert.vangaever_at_pharmacia.com> wrote in message news:c47691be.0308060057.22607adf_at_posting.google.com...
> Hello,
>
> We're using Oracle 7.3.4. here.
> We have a véry occupied server here, with very little space left.
> We'd like to copy some data to other tables, and then export it, to be
> imported in another database.
> But there's still the error of ORA-1555 'snapshot too old', which
> means the rollback segments are full.
> Unfortunately, it is impossible to increase the rollback segment.
>
> Is there a way to avoid the rollback segment, since it isn't really
> neccessary in this case??
>
> Tnx
> Gert

Gert

What are you using to copy the data ?
Is it PL/SQL by any chance ?

Regards

eric

--
Remove the dross to contact me directly

Received on Wed Aug 06 2003 - 05:34:53 CDT