Re: Database Pilot issues analyze statement

Article View: borland.public.jbuilder.database

Article #396

Back to borland.public.jbuilder.database Previous Next

#396

From: Paul Nichols [TeamB]
Date: Wed, 19 Oct 2005 23:03

34 lines
2254 bytes

"Tim Truman" <ttruman@nospam.com> wrote in message
news:43569acb$1@newsgroups.borland.com...
>

> Paul,
>
> You were on the right track. I am no Java expert but I
> managed a small program that connects with the database and
> gathers metadata. I discovered that databaseMetaData.getIndexInfo
> causes the Analyze. Even if Connection.getMetaData()is
> typecast with OracleDatabaseMetaData.
>
> // code snip - causes analyze but should not
> rset = metadata.getIndexInfo(null, "SCOTT","EMP",false,true);
>
> With that info I googled 'DatabaseMetaData.getIndexInfo analyze'
>
> I found this on OTN:
> http://forums.oracle.com/forums/thread.jspa?threadID=210782
>
> I looked up the bug number mentioned on MetaLink. It describes the issue
exactly but the bug has no resolution and has been dormant since
07-FEB-2003.
>
> Good call.
>
Well put one up for me on the educated guess column!!!

I guess you will need to write Oracle a note and ask what gives :)

Glad I could be of service. Take care..

Paul

Technical Details

Message-ID: <4356d001$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!atl-c05.usenetserver.com!news.usenetserver.com!pd7cy2so!shaw.ca!news-out.newsgroups.com!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail

References:

<434d2add$1@newsgroups.borland.com> <434de09f$1@newsgroups.borland.com> <434ec516$1@newsgroups.borland.com> <43502088$1@newsgroups.borland.com> <43550460$1@newsgroups.borland.com> <4355b79f@newsgroups.borland.com> <43569acb$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 1073da,9271f20c522d59c5
X-Google-Attributes: gid1073da,public
X-Google-Language: ENGLISH,ASCII-7-bit
Reply-To: "Paul Nichols [TeamB]" <paul@comp.net>
From: "Paul Nichols [TeamB]" <paul@comp.net>
Newsgroups: borland.public.jbuilder.database
References: <434d2add$1@newsgroups.borland.com> <434de09f$1@newsgroups.borland.com> <434ec516$1@newsgroups.borland.com> <43502088$1@newsgroups.borland.com> <43550460$1@newsgroups.borland.com> <4355b79f@newsgroups.borland.com> <43569acb$1@newsgroups.borland.com>
Subject: Re: Database Pilot issues analyze statement
Date: Wed, 19 Oct 2005 18:03:04 -0500
Lines: 36
Organization: paul@comp.net
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 66.20.208.2
Message-ID: <4356d001$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1129762817 66.20.208.2 (19 Oct 2005 16:00:17 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!atl-c05.usenetserver.com!news.usenetserver.com!pd7cy2so!shaw.ca!news-out.newsgroups.com!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail

Reply to Parent Message