RE: EXP on 9.2.0.3

I will disagree in that I do not think you should ignore the error
completely.  While the exp is fine as a backup of the data, the message
indicates that you should update or remove the statistics on the tables in
question.  After all you probably want the statistics to reflect the actual
data as it is currently and not how it was at the time the statistics were
gathered on another system.  Though there are times when that may indeed be
what you want.

IMHO -- Mark D Powell --


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Denham Eva
Sent: Tuesday, November 09, 2004 8:09 AM
To: jaffu
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: EXP on 9.2.0.3


Thanks Jaffar.

-----Original Message-----
From: jaffu [mailto:sjaffarhussain@xxxxxxxxx]=20
Sent: Tuesday, November 09, 2004 3:06 PM
To: Denham Eva
Subject: Re: EXP on 9.2.0.3

This can be ignorable.

While importing you can say statistics=3Dnone. the same also can be done
while exporting.
This could be due to the different nls_lang. Just ignore it.

Jaffar


On Tue, 9 Nov 2004 15:04:31 +0200, Denham Eva <evad@xxxxxxxxxx> wrote:
> Hello Folks,
>=20
> We have moved our database via the exp73 export utility from 7.3 to
> 9.2.0.3.
>=20
> Only the relevant schema was imported. As an initial backup I made an
> export using export utility for 9.2.0.3.
>=20
> In the log file is the following warning...
>=20
> EXP-00091: Exporting questionable statistics.
>=20
> This is for all the tables in from the old 7.3 system.
>=20
> Does anyone know to "fix" this? Will DBMS_Stats.Gather_Schema_Stats
fix
> this?
>=20
> Many Thanks
>=20
> Denham
>=20
> --
> http://www.freelists.org/webpage/oracle-l
>=20


--=20
Best Regards,
Syed Jaffar Hussain
OCP 8i DBA
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

Other related posts: