DBcheck completed with warnings

[Former Member]

HI All,

Our jobs dbcheck completed with warnings on in_wrong_tablespace:

BR0969I Checking database administration...

BR0970W Database administration alert - level: WARNING, type: IN_WRONG_TABLESPACE, object: (index) SAPJA6.RSDMFACTAB~0, value: PSAPJA6FACT

BR0970W Database administration alert - level: WARNING, type: IN_WRONG_TABLESPACE, object: (index) SAPJA6.RSMDMCNVTAB~0, value: PSAPJA6FACT

BR0970W Database administration alert - level: WARNING, type: IN_WRONG_TABLESPACE, object: (index) SAPJA6.RSMDMCNVTAB~CHA, value: PSAPJA6FACT

BR0970W Database administration alert - level: WARNING, type: IN_WRONG_TABLESPACE, object: (index) SAPJA6.RSMDMCNVTAB~SID, value: PSAPJA6FACT

Anyone can help on this. Some notes said to do reorg the table. Is there any other way to solve this or anyone facing

this issue before?

Please help.

Thanks,

Shap

[Former Member]

If you want to leave these indexes in this tablespace and get rid of these errors, you should change the settings in tables TSORA and IAORA. Also change the index class via SE11.

Kind regards,

Mark

[Former Member]

Hi,

The error suggests that the indexes mentioned are in wrong tablespaces.

For eg in R3 all the indexes should be in PSAPBTABI .This is not a critical error as separate tablespaces for indexes are maintained in order to reduce contention on tablespaces like PSAPBTABD .

The option you have is to recreate the indexes on PSAPBTABI .

You can post the output of select TABLESPACE_NAME from dba_tablespaces;

Now you can raise a question about how to get the ddl or storage parameter of these indexes mentioned above.

Here is the answer assuming it is an oracle database.

select dbms_metadata.get_ddl('INDEX','INDEX_NAME','OWNER') from dual;

Run the above statement for all the indexes mentioned above and it will give you the DDL of the indexes.

In the storage clause you will find something like

TABLESPACE "Existing_Tablespace_name" modify the name to the new one for eg say PSAPBTABI.

Run the DDLS directly on sqlplus prompt after dropping the indexes . But do the entire tasks in a quite time when no user is connected .

Regards

Kausik

Regards

Kausik

[Former Member]

Hi Hannes,

We are using Oracle release 10.2.0.4.0.

Thanks,

Shap

[hannes_kuehnemund]

moved to Oracle forum ...

[hannes_kuehnemund]

which DB are you using?