Search: For:
Browsing Single Category

ORA-14508: specified VALIDATE INTO table not found

Topic ID: 1655
Created By: 2007-FEB-14 13:53:05 [Vitaliy]
Updated By: 2007-FEB-14 13:53:05 [Vitaliy]
Status: Open
Severity: Normal
Read Only: No
5259
2007-FEB-14 13:53:05
Moderator
 
 
Registered On: Mar 2006
Total Posts: 195
When validating partitioned tables you can get the following error:

   ORA-14508: specified VALIDATE INTO table not found

SOLUTION:

Create table "invalid_rows" by running $ORACLE_HOME/rdbms/admin/utlvalid.sql 
then run a regular command to validate structure cascade:

   analyze table <table_name> validate structure cascade;

you do NOT have to use a special partition clause:

   analyze table <table_name> partition <part_name> 
      validate structure cascade into invalid_rows;

REFERENCE:
   Metalink Note:111990.1 and Note:120538.1