db13 WARNINGS.

[Former Member]

Hi,

IN BW version 3.5 and oracle as data base version 9.2.6.0.

In DB13 in CHECKDB Iam getting this warnings.

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

All the indexes of the cube are dropped and recreated during data loading.

After recreation the Partitioning Index (900)of the fact table moves to wrong table space.

All other indexes and the fact table are in the same original table space.

Even if the indexes are corrected to the original table space.

Again on data loading time when indexes are dropped and recreated.

Only partion index (900) are getting created in wrong table sapce.

Is there any system parameters/ Oracle parameters needs alteration for this?

Or any other reason for the issue.?

[Former Member]

Check this out!

Cheers!

Bidwan

[Former Member]

Hi Bidwan ,

It gives a clear way to solve the index issue.

Will it give another issue already existing fact table in the old mentioned table space ?.

Need to sure before implementing this solution.

Thanks and Regards,

Amuthan

[Former Member]

Hello Amruth,

Kindly reorganize the Inedices use SAPDBA or BRTOOLs.

That will resolve this issue with index.

Regards

Vivek