cancel
Showing results for 
Search instead for 
Did you mean: 

BR0970W Database administration alert - level: WARNING, type: IN_WRONG_TABLESPACE, object: (index)

01-30-2024 1:20 PM
mattsa Explorer
680 views 1 comments
0 Likes
SAP Managed Tags
Subscribe

I have a number of entries in CheckDB job for tables and indexes in wrong tablespaces. I can appreciate that these are only warning and with virtual drives probably not that important. I also know that this alert can be switched off. We are on an oracle database and I have corrected all the database errors using the following command:
alter table SAPSR3.TTREE move tablespace PSAPSR3750;

The command for the index from my old notes does not seem to be working, the command I have is:

alter index "SAPSR3.TTREE^0" rebuild tablespace PSAPSR3750;

The error I am seeing is ORA-01418: specified index does not exist. Does anyone have any idea what the command would be to move the index to the same tablespace?

 

0 Likes

Accepted Solutions (0)

Answers (1)

Answers (1)

JamesZ
Product and Topic Expert
Product and Topic Expert
Normally username and index should all have double quote, like: "SAPSR3"."Indexname" ==> but this is case sensitive Or try sapsr3.indexname