TABLES_NOT_IN_TABLE_TABLESPACE

[Former Member]

Hi all,

we are receiving below db13 alerts for almost all tables in DEV, QUA and PRD environments after one tablespace was created.

BR0970W Database administration alert - level: ERROR, type: TABLES_NOT_IN_TABLE_TABLESPACE, object:

(table) SAPR3./CRMMW/TST, value: PSAPPOOLD

BR0970W Database administration alert - level: ERROR, type: TABLES_NOT_IN_TABLE_TABLESPACE, object:

(table) SAPR3./CRMMW/TST_CDB, value: PSAPPOOLD

BR0970W Database administration alert - level: ERROR, type: TABLES_NOT_IN_TABLE_TABLESPACE, object:

(index) SAPR3./CRMMW/TST_CDB~0, value: PSAPPOOLI

Can you please help me to resolve this?

Thanks in advance

[markus_doehr2]

> (table) SAPR3./CRMMW/TST, value: PSAPPOOLD

> (table) SAPR3./CRMMW/TST_CDB, value: PSAPPOOLD

> (index) SAPR3./CRMMW/TST_CDB~0, value: PSAPPOOLI

Check if those three tables/indexes are existing on the database (using SE11 and/or SE14).

Markus

[Former Member]

Hi Markus,

Tables/indexes are exist on database and I compared with other 4.6c system, those tables/indexes are in correct table/index tablespaces.

And there are alerts for almost all tables in all environments not only these three after one tablespace was created.

kindly help on this

[markus_doehr2]

> Tables/indexes are exist on database and I compared with other 4.6c system, those tables/indexes are in correct table/index tablespaces.

They are correct according to the dictionary also? Did you check the storage parameters in SE14?

> And there are alerts for almost all tables in all environments not only these three after one tablespace was created.

which tablespace?

Markus

[Former Member]

Table : /CRMMW/TST

Parameters were determined from the current database status

Storage

Table

TABLESPACE PSAPPOOLD

INITIAL EXTENT 16

NEXT EXTENT 40

MINIMUM EXTENTS 1

MAXIMUM EXTENTS 300

PCT INCREASE 0

FREELISTS 1

FREELIST GROUPS 1

PCT FREE 10

PCT USED 40

Indexes

0

TABLESPACE PSAPPOOLI

INITIAL EXTENT 16

NEXT EXTENT 40

MINIMUM EXTENTS 1

MAXIMUM EXTENTS 300

PCT INCREASE 0

FREELISTS 1

FREELIST GROUPS 1

PCT FREE 10

[former_member204746]

what did you change lately? support packs? upgrade?

did you mess around with table contents of TSORA, IAORA or any **ORA table?

[Former Member]

somebody created tablespace PSAPDATNCS, after that we are receiving alerts.

I found in TSORA and IAORA table entries like below.

TSORA

============

TABSPACE INDSPACE

PSAPBTABD PSAPBTABI

PSAPCLUD PSAPCLUI

PSAPDATNCS PSAPDATNCS

PSAPDDICD PSAPDDICI

PSAPDOCUD PSAPDOCUI

PSAPEL46CD PSAPEL46CI

PSAPES46CD PSAPES46CI

PSAPLOADD PSAPLOADI

PSAPPOOLD PSAPPOOLI

PSAPPROTD PSAPPROTI

PSAPSOURCED PSAPSOURCEI

PSAPSTABD PSAPSTABI

PSAPUSER1D PSAPUSER1I

IAORA

============

TABART TABSPACE PCTINC OFREELIST OPCTFREE

APPL0 PSAPDATNCS 0000 001 10

APPL1 PSAPDATNCS 0000 001 10

APPL2 PSAPDATNCS 0000 001 10

CLUST PSAPDATNCS 0000 001 10

POOL PSAPDATNCS 0000 001 10

SDIC PSAPDATNCS 0 001 10

SDOCU PSAPDATNCS 0000 001 10

SLDEF PSAPEL46CI 0000 1 10

SLEXC PSAPEL46CI 0000 1 10

SLOAD PSAPDATNCS 0000 001 10

SPROT PSAPDATNCS 0000 001 10

SSDEF PSAPES46CI 0000 1 10

SSEXC PSAPES46CI 0000 1 10

SSRC PSAPDATNCS 0000 001 10

TEMP PSAPDATNCS 0000 001 10

USER PSAPUSER1I 0000 1 10

USER1 PSAPUSER1I 0000 1 10

Kindly suggest how to resolve this

[Former Member]

Please find in correct order

TSORA

============

TABSPACE INDSPACE

PSAPBTABD PSAPBTABI

PSAPCLUD PSAPCLUI

PSAPDATNCS PSAPDATNCS

PSAPDDICD PSAPDDICI

PSAPDOCUD PSAPDOCUI

PSAPEL46CD PSAPEL46CI

PSAPES46CD PSAPES46CI

PSAPLOADD PSAPLOADI

PSAPPOOLD PSAPPOOLI

PSAPPROTD PSAPPROTI

PSAPSOURCED PSAPSOURCEI

PSAPSTABD PSAPSTABI

PSAPUSER1D PSAPUSER1I

IAORA

============

TABART TABSPACE PCTINC OFREELIST OPCTFREE

APPL0 PSAPDATNCS 0000 001 10

APPL1 PSAPDATNCS 0000 001 10

APPL2 PSAPDATNCS 0000 001 10

CLUST PSAPDATNCS 0000 001 10

POOL PSAPDATNCS 0000 001 10

SDIC PSAPDATNCS 0 001 10

SDOCU PSAPDATNCS 0000 001 10

SLDEF PSAPEL46CI 0000 1 10

SLEXC PSAPEL46CI 0000 1 10

SLOAD PSAPDATNCS 0000 001 10

SPROT PSAPDATNCS 0000 001 10

SSDEF PSAPES46CI 0000 1 10

SSEXC PSAPES46CI 0000 1 10

SSRC PSAPDATNCS 0000 001 10

TEMP PSAPDATNCS 0000 001 10

USER PSAPUSER1I 0000 1 10

USER1 PSAPUSER1I 0000 1 10

[former_member204746]

this tablespace PSAPDATNCS, does it have an index tablespace? it should with the layout you are using. so, create PSAPDATNCSI, then adapt table TSORA, TAORA and IAORA accordingly.

and... **ORA tables seems to be messed up badly... unless he wanted to migrate to the new tablespace layout. if this is the case, simply move the 3 tables/indexes to tablespace PSAPDATNCS.

also please share IAORA.