Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

IN_WRONG_TABLESPACE, object: table/index

Hi all,

Apologies for the repost of this topic. I have seen it a few times but without resolutions. My problem is as follows.

BR0970W Database administration alert - level: WARNING, type: IN_WRONG_TABLESPACE, object: (index) SAPSR3.D010INC~1, value: PSAPSR346C

BR0970W Database administration alert - level: WARNING, type: IN_WRONG_TABLESPACE, object: (table) SAPSR3.D010L, value: PSAPSR346C

This is IAORA.

-


TABART

TABSPACE

PCTINC

OFREELIST

OPCTFREE

-


APPL0

PSAPSR3

0000

1

10

APPL1

PSAPSR3

0000

1

10

APPL2

PSAPSR3

0000

1

10

CLUST

PSAPSR3

0000

1

10

POOL

PSAPSR3

0000

1

10

SDIC

PSAPSR3

0

1

10

SDOCU

PSAPSR3

0000

1

10

SLDEF

PSAPSR346D

0000

1

10

SLEXC

PSAPSR346D

0000

1

10

SLOAD

PSAPSR3

0000

1

10

SPROT

PSAPSR3

0000

1

10

SSDEF

PSAPSR346D

0000

1

10

SSEXC

PSAPSR346D

0000

1

10

SSRC

PSAPSR3

0000

1

10

TEMP

PSAPSR3

0000

1

10

USER

PSAPSR3USR

0000

1

10

USER1

PSAPSR3USR

0000

1

10

This is TAORA.

TABART

TABSPACE

PCTINC

OFREELIST

OFREEGROUP

OPCTFREE

OPCTUSED

-


APPL0

PSAPSR3

0000

001

01

10

40

APPL1

PSAPSR3

0000

1

1

10

40

APPL2

PSAPSR3

0000

1

1

10

40

CLUST

PSAPSR3

0000

1

1

10

40

POOL

PSAPSR3

0000

1

1

10

40

SDIC

PSAPSR3

0

1

1

10

40

SDOCU

PSAPSR3

0000

1

1

10

40

SLDEF

PSAPSR346D

0000

1

1

10

40

SLEXC

PSAPSR346D

0000

1

1

10

40

SLOAD

PSAPSR3

0000

1

1

10

40

SPROT

PSAPSR3

0000

1

1

10

40

SSDEF

PSAPSR346D

0000

1

1

10

40

SSEXC

PSAPSR346D

0000

1

1

10

40

SSRC

PSAPSR3

0000

1

1

10

40

TEMP

PSAPSR3

0000

1

1

10

40

USER

PSAPSR3USR

0000

1

1

10

40

USER1

PSAPSR3USR

0000

1

1

10

40

select tablespace_name from dba_tablespaces;

SYSTEM,PSAPUNDO,SYSAUX,PSAPTEMP,PSAPSR3,PSAPSR346C,PSAPSR3USR

Tablespace does exist as you can see above now to determine type of tablespace, and as per below query you can see it contains

both data and indexes.

select distinct(segment_type), tablespace_name from dba_segments order by tablespace_name;

SEGMENT_TYPE TABLESPACE_NAME

-


-


INDEX PSAPSR3

TABLE PSAPSR3

INDEX PSAPSR346C

TABLE PSAPSR346C

TABLE PSAPSR3USR

TYPE2 UNDO PSAPUNDO

INDEX SYSAUX

INDEX PARTITION SYSAUX

LOB PARTITION SYSAUX

LOBINDEX SYSAUX

LOBSEGMENT SYSAUX

As per note 655162 option 1 and 2 are applicable to me. But as this tablespace seems to be both a data and index tablespace I am thinking I need to create the tablespace entry in IAORA and TAORA.

How would I correctly edit these table entries and which of the following tables might also have to be edited?

DDART and DARTT are used to maintain the classes ( tabarts)

DD09L maps the tables to each class ( tabart)

TAORA/IAORA maps the classes to the tablespaces

TSORA lists the tablespaces.

As a non dba I find the sap note a bit confusing please advise.

Kind Regards,

Johan

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question