Database Administration (MOSC)

MOSC Banner

Question Ask A New Question Analyze structure validate table and then analyzing the index was

edited Jun 16, 2012 5:06PM in Database Administration (MOSC) 1 commentAnswered
Hi experts.
Oracle version 10.2.0.3

I run the analyze validate structure for a table and then for an index, but it run way too fast for a table with millions of records. Is this ok?
The running of the dbv for the datafiles of the table and indexes run ok.

Here the log:

Subject: Speedprd Analyze Structure

23:00:01 SQL> analyze table srsuser.cdrs validate structure online;

Table analyzed.

23:00:02 SQL> commit;

Commit complete.

23:00:02 SQL> analyze index srsuser.cdrs_pk validate structure online;

Index analyzed.

23:00:09 SQL> commit;

Commit complete.

23:00:09 SQL> exit

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center