If I understand you this is effectively a one-time load/data transformation?
If so then you could consider using
insert /*+ APPEND */ into .... select
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"PeterS" <member_at_dbforums.com> wrote in message
news:3d195c43$1_at_usenetgateway.com...
> Hello, everybody. I am working on creating big set of data (~3-8 GB). I
> am using "insert into ... select" statement. I have 4 rollback segments
> with 500 maxextents each. Initial extent =320K, next extent =320K. Here
> is dynamic info:
>
> Rollback Segment Size (KB) Gets Waits % Waits # Shrinks # Extends
> ---------------- ---------- ------------ ---------- ------- ---------
> --------- SYSTEM 4,792 44,146 0 0.00 0 58 RBS01 6,392 97,516 0 0.00 0 0
> RBS02 6,392 96,732 0 0.00 0 0 RBS03 6,392 97,172 0 0.00 0 0 RBS04
> 159,992 132,030 0 0.00 0 480
>
> I inserted ~200000 rows and got the following:
>
> ORA-01562: failed to extend rollback segment number 5 ORA-01628: max #
> extents (500) reached for rollback segment RBS04
>
> I wouldn't like to set maxextents unlimited, since my disk space is
> limited. Could anybody suggest something? Should I increase extents? Or
> number of rollback segments?
>
> I appreciate any help! Thank you. Peter.
>
>
>
> --
> Posted via dBforums
> http://dbforums.com
Received on Wed Jun 26 2002 - 04:40:22 CDT
