Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Rebuilding Indexes and Analyzing schema in 9i

user12000301Mar 30 2012 — edited Mar 30 2012

Hi,

We can Rebuild the index and analyze the same on 10g as follows :

1. SQL> alter index INDEX_NAME rebuild online;

2. SQL>exec dbms_stats.gather_schema_stats(ownname=>'SCHEMA_NAME',estimate_percent=>dbms_stats.auto_sample_size,cascade=>true);

Now I want to perform the same for a 9.2.0.8 database (on Windows 2003 server OS).

Thanks in advance

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 27 2012

Added on Mar 30 2012

#general-database-discussions

2 comments

546 views