Friday, 13 January 2017

ORA-14508: specified VALIDATE INTO table not found

SQL> analyze table PIN.EVENT_T validate structure cascade;
analyze table PIN.EVENT_T validate structure cascade
*
ERROR at line 1:
ORA-14508: specified VALIDATE INTO table not found

Run the below to create a validate table 

SQL> @?/rdbms/admin/utlvalid.sql;


Table created.


Now run the analyze command

SQL> analyze table PIN.EVENT_T validate structure cascade;


No comments:

Post a Comment