OraFAQ Forum: Server Utilities » Export/import problem (merged)

Home » RDBMS Server » Server Utilities » Export/import problem (merged)

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

Export/import problem (merged) [message #255474]

Wed, 01 August 2007 00:42

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 1781 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

BlackSwan
Messages: 26766
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

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

Report message to a moderator

Re: Import problem [message #255484 is a reply to message #255474]

Wed, 01 August 2007 00:55

BlackSwan
Messages: 26766
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)!

Report message to a moderator

Export problem [message #255488 is a reply to message #255474]

Wed, 01 August 2007 01:06

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

Report message to a moderator

Re: Export problem [message #255494 is a reply to message #255488]

Wed, 01 August 2007 01:12

Michel Cadot
Messages: 68728
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: Export problem [message #255498 is a reply to message #255494]

Wed, 01 August 2007 01:22

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

Report message to a moderator

Re: Export/import problem (merged) [message #255501 is a reply to message #255474]

Wed, 01 August 2007 01:28

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.

Report message to a moderator

Re: Export/import problem (merged) [message #255683 is a reply to message #255474]

Wed, 01 August 2007 08:48

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.

Report message to a moderator

Previous Topic:	import
Next Topic:	importing data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 09:39:21 CST 2024