ORA-14508: ANALYZE PARTITION TABLE VALIDATE STRUCTURE CASCADE (Doc ID 111990.1)

Last updated on JANUARY 10, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 8.0.3.0 to 11.2.0.3 [Release 8.0.3 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 12-Feb-2016***


Symptoms

You are trying to issue an analyze command on a partition table on version 8.0.x and above of the database.

You are issuing this command:
  analyze table <name> validate structure cascade;
and have tried
  analyze table <name> partition (<partition_name>) validate structure cascade;

and you keep receiving the following error:
ORA-14508: "specified VALIDATE INTO table not found"

Example (11gR2):

SQL> analyze table sh.sales partition (SALES_Q4_2000) validate structure cascade;
analyze table sh.sales partition (SALES_Q4_2000) validate structure cascade
*
ERROR at line 1:
ORA-14508: specified VALIDATE INTO table not found


You tested that on a non-partitioned table the analyze command works without an error.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms