BR0970W Missing index (table)

[vince_laurent]

I am getting this message on our BDE system (BI7.0 Oracle 10.2.0.2):

BR0970W Database administration alert - level: ERROR, type: MISSING_INDEX, object: (table) SAPR3./BI0/1TCTUSERNM

I looked at similar systems (BSN and BQA - same version of stuff) they don't even have a SAPR3./BI0/1TCTUSERNM. BDE does have the table but apparently no associated index.

Where might that have come from? What is that table/index and do I need it? How might I recreate it?

Thanks

Vince

Edited by: Vince Laurent on Jun 3, 2008 7:05 PM

[Former Member]

Hi Vince,

Have you received an answer about the following problem ?

Because I have the same one.

Thanks.

Ludovic

[vince_laurent]

I posted what I did - sorry if it does not help in your situation.

Vince

[vince_laurent]

Created the DDL that created the empty table, filed it away for future reference, dropped table. All with the blessing from our developers.