RE: EXP on 9.2.0.3

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Tue, 9 Nov 2004 09:11:37 -0500
Message-ID: <564DE4477544D411AD2C00508BDF0B6A2133DF8B@usahm018.exmi01.exch.eds.com>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Denham Eva Sent: Tuesday, November 09, 2004 8:09 AM To: jaffu
Cc: oracle-l_at_freelists.org
Subject: RE: EXP on 9.2.0.3

Thanks Jaffar.

-----Original Message-----
From: jaffu [mailto:sjaffarhussain_at_gmail.com]=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_at_tfmc.co.za> 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

Received on Tue Nov 09 2004 - 08:07:39 CST