Re: copying a large table

On 14 Sep 2004 19:38:23 -0700, gdas1_at_yahoo.com (gdas) wrote:

>Other advice in regards to snapshot too old says to size the rollback
>segments bigger. I don't want to do that. This 'copy' is a one-time
>maintenance thing and not part of the day to day operation of the
>existing application (which never encounters that error). I don't
>want to change the existing rollback segments for this one time job.
>

As you can shrink rollback segments I don't see any issue here.

>Also, target database is a 24 x 7 production database...so I can't
>shut it down, disable archivelogmode, start it up and then do the
>insert...
>
>Appreciate any advice that anyone has? Other ideas on how to copy
>this big table?

Use sql*plus copy. Allows you to use array fetch and to commit individual arrays.

 If I sound like I am already on the wrong path and
>wasting more time (I'm going to get the snapshot too old error no
>matter what I do!)
>
>Thanks in advance!

--
Sybrand Bakker, Senior Oracle DBA