Home » RDBMS Server » Server Utilities » Gather Statistics (ORACLE 10.2.0.4.0, Windows)
Gather Statistics [message #414533] Wed, 22 July 2009 08:33 Go to next message
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.

Re: Gather Statistics [message #414534 is a reply to message #414533] Wed, 22 July 2009 08:37 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
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

Re: Gather Statistics [message #415230 is a reply to message #414533] Sun, 26 July 2009 10:21 Go to previous messageGo to next message
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.
Re: Gather Statistics [message #415231 is a reply to message #414533] Sun, 26 July 2009 10:25 Go to previous messageGo to next message
BlackSwan
Messages: 25050
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
Re: Gather Statistics [message #415234 is a reply to message #415230] Sun, 26 July 2009 10:33 Go to previous message
Michel Cadot
Messages: 64152
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
Previous Topic: Import takes long time
Next Topic: impdp
Goto Forum:
  


Current Time: Sat Dec 10 22:51:13 CST 2016

Total time taken to generate the page: 0.18885 seconds