Re: Manual analyze 10g

From: Guillermo Alan Bort <>
Date: Mon, 14 Nov 2011 12:57:10 -0300
Message-ID: <>

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

On Mon, Nov 14, 2011 at 11:38 AM, P D <> wrote:

> I've got a 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.
> --

Received on Mon Nov 14 2011 - 09:57:10 CST

Original text of this message