BR0970W type: IN_WRONG_TABLESPACE

[carlos_zhang3]

Dear Guru ,

We had completed the SAPR3/4.7 to ECC6 upgrade process .

[ Windows 2003 x64 + Oracle 10g 10.2.0.4 ]

But we saw the database check log showed below information :

R0960I Last successful BRCONNECT check run: cedcdtdt.chk 2010-04-26 21.00.53
R0126I Unattended mode active - no operator confirmation required
R0280I BRCONNECT time stamp: 2010-04-27 21.00.34
R0969I Checking database administration...
R0970W Database administration alert - level: WARNING, type: IN_WRONG_TABLESPACE, object: (table) SAPD19./ASU/CONTENT, value: PSAPD19
R0970W Database administration alert - level: WARNING, type: IN_WRONG_TABLESPACE, object: (table) SAPD19./ASU/CONTENTNT, value: PSAPD19
R0970W Database administration alert - level: WARNING, type: IN_WRONG_TABLESPACE, object: (index) SAPD19./ASU/CONTENTNT~0, value: PSAPD19
R0970W Database administration alert - level: WARNING, type: IN_WRONG_TABLESPACE, object: (table) SAPD19./ASU/CONTENTNV, value: PSAPD19
R0970W Database administration alert - level: WARNING, type: IN_WRONG_TABLESPACE, object: (table) SAPD19./ASU/CONTENTNVT, value: PSAPD19
R0970W Database administration alert - level: WARNING, type: IN_WRONG_TABLESPACE, object: (index) SAPD19./ASU/CONTENTNVT~0, value: PSAPD19
R0970W Database administration alert - level: WARNING, type: IN_WRONG_TABLESPACE, object: (index) SAPD19./ASU/CONTENTNV~0, value: PSAPD19
R0970W Database administration alert - level: WARNING, type: IN_WRONG_TABLESPACE, object: (table) SAPD19./ASU/CONTENTT, value: PSAPD19
R0970W Database administration alert - level: WARNING, type: IN_WRONG_TABLESPACE, object: (index) SAPD19./ASU/CONTENTT~0, value: PSAPD19
R0970W Database administration alert - level: WARNING, type: IN_WRONG_TABLESPACE, object: (table) SAPD19./ASU/CONTENTV, value: PSAPD19
R0970W Database administration alert - level: WARNING, type: IN_WRONG_TABLESPACE, object: (index) SAPD19./ASU/CONTENTV~0, value: PSAPD19
R0970W Database administration alert - level: WARNING, type: IN_WRONG_TABLESPACE, object: (table) SAPD19./ASU/CONTENTXML, value: PSAPD19
R0970W Database administration alert - level: WARNING, type: IN_WRONG_TABLESPACE, object: (index) SAPD19./ASU/CONTENTXML~0, value: PSAPD19
....

There have a lot message that reporting "IN_WRONG_TABLESPACE" .

And i checked notes "655162" , but seems doesn't work .

Has someone can guide me solve this problem ?

Thanks a lot !

Best Regards,

Carlos Zhang

[carlos_zhang3]

Can i modify the TAORA table directly ?

I would like to modify PSAPD19700 to PSAPD19 , Is it possible ?

APPL0	PSAPD19700		1	1	10	40
APPL1	PSAPD19700		1	1	10	40
APPL2	PSAPD19700		1	1	10	40
CLUST	PSAPD19700		1	1	10	40
DDIM	PSAPDIMD		1	1		60
DFACT	PSAPFACTD		4	1	10	60
DODS	PSAPODSD		4	1		60
POOL	PSAPD19700		1	1	10	40
SDIC	PSAPD19700		1	1	10	40
SDOCU	PSAPD19700		1	1	10	40
SLDEF	PSAPD19700		1	1	10	40
SLEXC	PSAPD19700		1	1	10	40
SLOAD	PSAPD19700		1	1	10	40
SPROT	PSAPD19700		1	1	10	40
SSDEF	PSAPD19700		1	1	10	40
SSEXC	PSAPD19700		1	1	10	40
SSRC	PSAPD19700		1	1	10	40
TEMP	PSAPD19700		1	1	10	40
USER	PSAPD19USR		1	1	10	40
USER1	PSAPD19USR		1	1	10	40

Thanks .

[former_member204746]

yes, you can modify table TAORA directly.

try this:

APPL0   PSAPD19
APPL1   PSAPD19
APPL2   PSAPD19
CLUST   PSAPD19
DDIM    PSAPDIMD
DFACT    PSAPFACTD
DODS    PSAPODSD
POOL    PSAPD19
SDIC    PSAPD19
SDOCU   PSAPD19
SLDEF   PSAPD19700
SLEXC   PSAPD19700
SLOAD   PSAPD19
SPROT   PSAPD19
SSDEF   PSAPD19700
SSEXC   PSAPD19700
SSRC    PSAPD19
TEMP    PSAPD19
USER    PSAPD19USR
USER1   PSAPD19USR
USER2   PSAPD19USR

Also check IAORA and TSORA.

Edited by: Eric Brunelle on Apr 27, 2010 2:00 PM

[carlos_zhang3]

Dear Eric ,

Thanks . I had modified the table "IAORA" and "TAORA" . It works ...

Do i need some special operation in database level ? I am worried about this modification will cause other problems....

Thanks again .

Best Regards,

Carlos Zhang

Edited by: Carlos Zhang on Apr 28, 2010 11:15 AM

[JPReyes]

No, this shouldn't cause any problems

Regards

Juan

[Former Member]

For whats it worth u might also want to double check TSORA is maintained ok. It lists the tablespaces.

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.

From what I can tell Brtools is finding the tables are in PSAPD19 at db level but according to DD09L the tables belong to class APPL0 and Appl1 and therefore should be in tablespace PSAPD19700 according to Taora and IAORA.

I'm not sure, but if tsora is not maintained correctly u might get a new error that TAORA and IAORA don't match the setting in TSORA after you change them.

It's important if you ever decide to migrate the system via an export that all the above tables are maintained correctly.

rgds

Jim