Re: ORA-04030, create text index error

From: lsllcm <lsllcm_at_gmail.com>
Date: Sat, 21 Mar 2009 07:41:28 -0700 (PDT)
Message-ID: <17da58af-5f8c-4fa9-9829-ee6a457477eb_at_j3g2000prh.googlegroups.com>



On Mar 17, 2:45 am, Michael Austin <maus..._at_firstdbasource.com> wrote:
> lsllcmwrote:
> > On Mar 11, 4:28 am,lsllcm<lsl..._at_gmail.com> wrote:
> >> On Mar 11, 1:43 am, jgar the jorrible <joel-ga..._at_home.com> wrote:
>
> >>> On Mar 10, 8:29 am,lsllcm<lsl..._at_gmail.com> wrote:
> >>>> Could you paste the document 233869.1 here?
> >>> No.  That would be a violation of Oracle support terms.  You don't
> >>> have support?
> >>> If you aren't swapping, you might have some pga problem that might
> >>> require serious support help.  What do the pga advisor views tell
> >>> you?  What do you have pga_aggregate_target set to?  I don't have
> >>> linux available so I can't comment on your stack size,http://www.puschitz.com/TuningLinuxForOracle.shtmlisolderbut may
> >>> give you a clue what to look for if you have a stack collision
> >>> problem.  How big is your SGA?  What does your swapinfo look like?
> >>> jg
> >>> --
> >>> _at_home.com is bogus.http://www3.signonsandiego.com/stories/2009/mar/10/1b10scam211015-3-s...
> >> Sorry, I have read the document 233869.1.
>
> >> I have increased pga_aggregate_target to 30g.
>
> >> The stack size is 10g
>
> >> stack size              (kbytes, -s) 10240
>
> >> I have add memory parameter 1g, When we create regular index, it will
> >> use temporary tablespace. But why does not it use when creating text
> >> index? It is very strange.- Hide quoted text -
>
> >> - Show quoted text -
>
> > Can anyone help?
>
> > Thanks
>
> Time to log a call with support.- Hide quoted text -
>
> - Show quoted text -

Thanks, it has been resolved by check if the value is null Received on Sat Mar 21 2009 - 09:41:28 CDT

Original text of this message