Home » RDBMS Server » Backup & Recovery » Questionable Statistics
icon14.gif  Questionable Statistics [message #230441] Thu, 12 April 2007 00:50 Go to next message
rtskrajan
Messages: 43
Registered: March 2007
Member
Hello
While Exporting Database following message displayed in each table...

EXP-00091: Exporting questionable statistics.
. . exporting table SCPROFRGHT1 1966 rows exported

Anyone help...
Re: Questionable Statistics [message #230444 is a reply to message #230441] Thu, 12 April 2007 00:53 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
go through below link
http://dbataj.blogspot.com/2007/01/exp-00091-exporting-questionable.html

Oracle Version ?
OS ?

Regards
Taj
Re: Questionable Statistics [message #230446 is a reply to message #230444] Thu, 12 April 2007 01:00 Go to previous messageGo to next message
rtskrajan
Messages: 43
Registered: March 2007
Member
Thanks for your Prompt Reply....

Where can i set the OS Character Set...

Oracle Ver 10gR2
OS Server = Win2003SP2
OS Client = Win XPSP2
Please Advice....

Once Again Thanks....

[Updated on: Thu, 12 April 2007 01:01]

Report message to a moderator

Re: Questionable Statistics [message #230450 is a reply to message #230446] Thu, 12 April 2007 01:08 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
Before Export on command prompt.
try like

First check "NLS_CHARACTERSET" of database through below query
SQL> select VALUE
  2  from nls_database_parameters
  3  where PARAMETER = 'NLS_CHARACTERSET';

VALUE
----------------------------------------
WE8MSWIN1252


On command prompt
c:\> set NLS_LANG=.WE8MSWIN1252


before set anything are you check all related point for this error on above link.

Regards
Taj

[Updated on: Thu, 12 April 2007 01:08]

Report message to a moderator

Re: Questionable Statistics [message #230452 is a reply to message #230450] Thu, 12 April 2007 01:13 Go to previous message
rtskrajan
Messages: 43
Registered: March 2007
Member
Ohhh...Thanks for your reply...
Its working Fine..
Thanks....
Previous Topic: Import dmp in 10g express
Next Topic: Recover datafile
Goto Forum:
  


Current Time: Tue May 14 16:22:45 CDT 2024