Re: temporary tablespace problem

Michael Higgins (lnustruk.xzw6cb_at_eds.com) wrote:
: I have a package that performs a bunch of inserts to a table. My problem
: is that if I do too many inserts, I get an ORA-01547 - Failed to allocate
: extent of size 250 in tablespace TEMPORARY (my default temp tablespace).
 

: I'd like more information about what gets written to my temp tablespace
: so that I might be able to solve my problem.
 

: I'm running Oracle 7.0.16.6.0 on a NetWare server.
 

: Thanks.
 

: Higg.

I don't know what is causing the problem. But my suggestion is to either 1) Do a commit after X no. of inserts
2) Increase default setting on next extent in the temp tab.sp.

-- 
    .       !/                                           #######################
    %&     [>    ..               li      ..             #                     #
   #_at_\\  /+}   g8''9c   #\.=-.  .ro£=-  o6''8m   %\.--.  # Morten              #
   _at_o `?' J=  s2   @e   RP'´    "T2T"  m3   %e   H!''#|  # Kristiansen         #