DB13 - Validating Tables

[Former Member]

When I am validating the strucure of tables in DB13 I get a few of these errors:

BR0301E SQL error -14508 at location stats_tab_validate-2

ORA-14508: specified VALIDATE INTO table not found

BR0893E Validating structure failed for table/cluster SAPDWP./BI0/F0FIAP_C03

It says the validate table into table is not there, but it seems to be there for 98% of the tables I validate? How can it be missing for a few tables and there for almost all the tables?

[fidel_vales · Accepted solution]

Hello,

I think I'm going to create a signature with the recommendation of use the "search" function first

Take a look at the note:

SAP Note 514178 ORA-14508 when validating partitioned tables

Probably is what you are looking for

[Former Member]

Hi!

Oracle says "The specified table either does not exist or user does not have the proper privileges".

Use transaction DB02 to find out if there are any objects missing in DB and/or DDIC or if there are inconsistent objects.

If there are such objects try to find out why they are missing and if they are missing in all systems of the landscape DEV, QA, PROD.

Regards,

Volker