Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    May 16, 2011 at 04:22 PM

    Apparently SAPSR3.D010INC~1, value: PSAPSR346C is not defined in TAORA an IAORA, you have to create according to 655162.

    THanks

    SM

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Guys,

      My system is 46C as I mentioned running 46D kernel no confusion there.

      There was already a note existing with was only recently released confirming what a a few of you said and correcting others.

      1578001 - BR0970W IN_WRONG_TABLESPACE, BR0989W Unknown tablespace

      Please note also you will have to modify your se06/scc4 settings to modify the table entries as required.

      This is as per note Note 666061 - FAQ: Database objects, segments and extents and point 14 in the note.

      Kind Regards,

      J