Re: ORA-04030, create text index error

From: lsllcm <lsllcm_at_gmail.com>
Date: Mon, 16 Mar 2009 08:36:36 -0700 (PDT)
Message-ID: <d4104043-5076-4b7b-889a-518aaf4ef7e8_at_k36g2000pri.googlegroups.com>

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.shtmlisolder but 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 Received on Mon Mar 16 2009 - 10:36:36 CDT