Home » RDBMS Server » Server Utilities » Export/import problem (merged)
Export/import problem (merged) [message #255474] Wed, 01 August 2007 00:42 Go to next message
crussed_sonu
Messages: 51
Registered: July 2007
Location: Delhi
Member
Hi

I am trying to import dump file.
then get error
ORA-000091 :questionable stat


exp userid=jindal/jindal@jindal file='d:\jinaldump\jindal.dmp'
log='c:\jindal.log'

plz go through attactment ..



  • Attachment: orafaq.doc
    (Size: 69.00KB, Downloaded 663 times)

[Updated on: Wed, 01 August 2007 00:45]

Report message to a moderator

Re: Import problem [message #255476 is a reply to message #255474] Wed, 01 August 2007 00:44 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
>plz go through attactment ..
NO. I refuse to open virus infecting file from unknown strangers.

Weird error to get on import

00091, 00000, "LARGE_POOL_SIZE must be at least %s"
// *Cause: The value of LARGE_POOL_SIZE is below the minimum size.
// *Action: Increase the value of LARGE_POOL_SIZE past the minimum size.

[Updated on: Wed, 01 August 2007 00:47] by Moderator

Report message to a moderator

Re: Import problem [message #255481 is a reply to message #255474] Wed, 01 August 2007 00:49 Go to previous messageGo to next message
crussed_sonu
Messages: 51
Registered: July 2007
Location: Delhi
Member
then please ask me



when i am importing my dump file
the database character set of exported file is WE8MSWIN1252

and my database character set is WE8iSO8859P1


then
get a error

ORA-00091:questionable stat


plz reply me soon
Re: Import problem [message #255484 is a reply to message #255474] Wed, 01 August 2007 00:55 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
Have your read & followed ANY of the posting guidelines in the STICKY posts at top of forum?

too few details which matter in your posts.

yes, you have a problem.
If no one can reproduce, then Your On Your Own (YOYO)!
Export problem [message #255488 is a reply to message #255474] Wed, 01 August 2007 01:06 Go to previous messageGo to next message
crussed_sonu
Messages: 51
Registered: July 2007
Location: Delhi
Member
Hi


i am trying to export at the session level but get error

EXP-00091:Exporting questionable statistics

oracle 10g
window plateform


database character set is WE8ISO8859P15
and export done in WE8MSWIN1252


plz reply me soon
Re: Export problem [message #255494 is a reply to message #255488] Wed, 01 August 2007 01:12 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
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: Export problem [message #255498 is a reply to message #255494] Wed, 01 August 2007 01:22 Go to previous messageGo to next message
crussed_sonu
Messages: 51
Registered: July 2007
Location: Delhi
Member
Hi

plz ask me the steps that i follow one by one
with the commands


Thanks

with Regards
Re: Export/import problem (merged) [message #255501 is a reply to message #255474] Wed, 01 August 2007 01:28 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

It is not a matter of that. Follow that instruction that Action indiactes.
Re: Export/import problem (merged) [message #255683 is a reply to message #255474] Wed, 01 August 2007 08:48 Go to previous message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
Or depending on what you are doing, you may not care that the satatisicts are questionable and leave the table as is.

I have many occasions to export tables from a QA instance back to my Development instance, often I get questionable statistics, but all's I really care about is having the data there.

But if you are importing into a production environment and it is a table with performance implications, then it matters.
Previous Topic: import
Next Topic: importing data
Goto Forum:
  


Current Time: Mon Dec 05 21:29:55 CST 2016

Total time taken to generate the page: 0.23902 seconds