ORA-14508: specified VALIDATE INTO table not found
|
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