Re: Analyze in 8.05 on NT

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Mon, 15 Nov 1999 19:59:15 +0100
Message-ID: <942692417.21566.0.pluto.d4ee154e@news.demon.nl>

1 That I don't know
2 Yes!
3 temporary segment. Analyze does use the temporary segment and AFAIK doesn't use rollback segments

Hth

--
Sybrand Bakker, Oracle DBA
ragu sekar <raguc_at_yahoo.com> wrote in message news:38302294_at_www2.iaol.com...
>
> We have a 15 GB db in 8.05 running on NT. When we issue analyze estimate
20% command like we get an error like
> file://quote
> analyze index ORACLE.PK_ORDR_ACCT estimate statistics sample 20 percent
> *
> ERROR at line 1:
> ORA-01041: internal error. hostdef extension doesn't exist
> file://end quote.
> Questions:
>
> 1. Is there a problem with V 8.05 on this??
> 2. When we anlyze tables do the indexes also get anlyzed???
> 3. Do we have to make the temporary table sace bigger or increase the
rollbakc seg size etc for this???
>
> Thanks for your help
>
> ragu
>
>
>
Received on Mon Nov 15 1999 - 12:59:15 CST