Skip to Content
0
Former Member
Nov 01, 2012 at 08:32 AM

-4004,Unknown table name or unknown schema

666 Views

Hi,

I want to create statistics for table "SAP<SID>"."D010LINF".

The command in transaction DB13 shown is:

UPDATE STAT "SAP<SID>"."D010LINF" ESTIMATE

But the job aborts with a

rc = -942 (POS(1) Unknown table name)

or

-4004,Unknown table name or unknown schema

Other tables could be refreshed.

But if I start a select * from "SAP<SID>"."D010LINF" I get data (all with the same user).

In se11 and se14 everything is fine.

I droped the index and recreated it but nothing helped!

I reloaded the system tables again, but this did not help.

What could be the problem?

Thanks.

Best regards

Christian