Re: Manual analyze 10g
Date: Mon, 14 Nov 2011 12:57:10 -0300
Message-ID: <CAJ2dSGQc9xdvV_tOOTQtOLQrmBTF5jrV0rar1YU+ZVJ2QuR+0Q_at_mail.gmail.com>
You can export the stats of a table.
basically: exp .... rows=n statistics=y
then you can reimport the stats without dropping the table by using imp ignore=y
you should test this before assuming it works, it's been a while since I did anything like it.
You can also use DBMS_STATS to export and import stats. but I don't remember how.
HTH
Cheers
Alan.-
On Mon, Nov 14, 2011 at 11:38 AM, P D <pdba1966_at_hotmail.com> wrote:
> I've got a 10.2.0.4 database and the developers want to run analyze on one
> table even though Oracle automates it in this version. If I run this for
> them and have any issues, is there a way to revert back to the old
> statistics? Are there any other potential side effects of running it on
> one table in this version of Oracle.
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Nov 14 2011 - 09:57:10 CST