|
Re: Import problem [message #255476 is a reply to message #255474] |
Wed, 01 August 2007 00:44 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/136107.jpg) |
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 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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
|
|
|
|
Export problem [message #255488 is a reply to message #255474] |
Wed, 01 August 2007 01:06 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 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/import problem (merged) [message #255683 is a reply to message #255474] |
Wed, 01 August 2007 08:48 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
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.
|
|
|