cancel
Showing results for 
Search instead for 
Did you mean: 

Table: USR02BKP Table has no index

Former Member
0 Kudos

Hello,

During weekly checkdb sheduled jobs from DB13 transaction we are getiing below mentioned warning/error again and again

MISSING_INDEX :: Table: SAPDEV.USR02BKP # Table has no index

But in Se11 or Sm30 i am unable to fine any table with name USR02BKP

But this table is present in database in PSAPDEVUSR tablespace.

How to resolve this issue.

Regards,

RR

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member204746
Active Contributor
0 Kudos

export this table's contents using program EXP. then drop this table.

problem fixed.

Former Member
0 Kudos

Thanks to all.

Former Member
0 Kudos

Hello,

my crystal ball is showing me this:

Your Oracle database administrator wanted to keep a backup of the current state of table USR02 and therefor created table USR02BKP as a copy of this table. He did this with Oracle tools, and so SAP does not know about this new table.

Ask him whether this table is still needed.

Former Member
0 Kudos

How should i rebuild an index then ...may be Brtools

BRTOOLS can be used to rebuild index.

BRTOOLS->SEGMENT MGT->REBUILD INDEX. ??

Former Member
0 Kudos

Imho it will not be possible to use SAP tools for building an index for a table that is not known to SAP...

(You may try, of course.)

Did you ask whether the table is still needed?

I would prefer to drop the table at Oracle level.

Edited by: Joe Bo. on Dec 16, 2008 11:08 AM

'to drop' rather than 'to delete'