Re: Doubt on Index and Analyze after importing a schema

What version of ORACLE? In any case, look up the "STATISTICS" option for both export and import.

• Jusung Yang

spraveen2001_at_yahoo.com (Praveen) wrote in message news:<98d8ec76.0303170301.48a2e6f6_at_posting.google.com>...
> Hi All,
>
> I have a schema and i have created all necessary indexes and analyzed
> also.
> when i export and import it into new schema. should i rebuild the
> indexes and analyze all the tables again? because after successfull
> import, if i see the last_analyzed of the tables and indexes, it is
> showing the date when i import the schema. Does it mean that if i
> import a schema to new schema, tables and indexes will automatically
> analyzed?
>
> Thanks in Advance,
> Praveen
Received on Mon Mar 17 2003 - 17:14:57 CET