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.

Report message to a moderator

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: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
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 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.

Report message to a moderator

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: 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 Go to previous message
Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jan 11 07:43:42 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.