Re: Urgent prb - unable to allocate an extent

Hi,

  The problem is that the embedded select uses hash join and the size of the left side is too big.

> > > insert into webpro.component_characteristic
> > > select c.componentseq, 'XJE014', m.des
> > > from desmond.main_onsemi_info m, webpro.component c
> > > where c.statusno = 25
> > > and c.part_number = m.upartno
> > > and m.statusno=10

Use the USE_NL hint to disable HASH_JOIN or increase the next storage parameter of temp tablespace.

Greetings,

-- 
  -+==-.
   |   |                      |
   |==-+-=-+- -+===- -+==+- -=+==-         G o m b o s  B e r t a l a n
   |       |   |=-    |  '    |
  -|-=====-+- -+===-  |      -+==-          mailto:bgombos_at_freemail.hu
   '       '   '      '       '                 GSM:+36 20 9293612