on 12-16-2008 9:04 AM
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
export this table's contents using program EXP. then drop this table.
problem fixed.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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'
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.