OraFAQ Forum: Server Utilities » Gather Statistics

Home » RDBMS Server » Server Utilities » Gather Statistics (ORACLE 10.2.0.4.0, Windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Gather Statistics [message #414533]

Wed, 22 July 2009 08:33

srini_thiru
Messages: 133
Registered: May 2008

Senior Member

Hi,

I have used the below query to gather schema statistics for my database.

EXEC dbms_stats.gather_schema_stats('TEST_SCHEMA');

But when i tried to export that particular schema i found logs like

EXP-00091: Exporting questionable statistics

Please share why do i get the above error after collecting statistics for that schema.

Thanks in Advance,
Seenu.

Report message to a moderator

Re: Gather Statistics [message #414534 is a reply to message #414533]

Wed, 22 July 2009 08:37

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

EXP-00091: Exporting questionable statistics.
 *Cause:  Export was able export statistics, but the statistics may not be
          usuable. The statistics are questionable because one or more of
            the following happened during export: a row error occurred, client
            character set or NCHARSET does not match with the server, a query
            clause was specified on export, only certain partitions or
            subpartitions were exported, or a fatal error occurred while
            processing a table.
 *Action: To export non-questionable statistics, change the client character
            set or NCHARSET to match the server, export with no query clause,
            export complete tables. If desired, import parameters can be
            supplied so that only non-questionable statistics will be imported,
            and all questionable statistics will be recalculated.

Regards
Michel

Report message to a moderator

Re: Gather Statistics [message #415230 is a reply to message #414533]

Sun, 26 July 2009 10:21

srini_thiru
Messages: 133
Registered: May 2008

Senior Member

Hi Michel,

I am trying to export the database from the server only and also i gathered statistics for that particular schema which i am doing export then too i got the

EXP-00091: Exporting questionable statistics.

error.

Thanks In Advance,
Seenu.

Report message to a moderator

Re: Gather Statistics [message #415231 is a reply to message #414533]

Sun, 26 July 2009 10:25

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.

post export command & logfile

Report message to a moderator

Re: Gather Statistics [message #415234 is a reply to message #415230]

Sun, 26 July 2009 10:33

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Same error, same answer.
For instance, "the client character set", as you didn't post it (nor the one of the database), we can't help more.
Post the export log file.

Regards
Michel

Report message to a moderator

Previous Topic:	Import takes long time
Next Topic:	impdp

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 12:14:48 CDT 2024