Move table space to new table space.

[Former Member]

I'm upgrading my SAP ECC 6.0 Dual stack system to ECC 6.0 EHP4 on Oracle10.2.0.4 HP-UX UNIX.

In the phase 'PREP_INIT/INTCHK_INI'.I get the following error:

INFO: An inconsistency has been detected in your system:

Container pair 'PSAPDIMD'/'PSAPDIMI' for tabart 'DDIM' not identical.

Container pair 'PSAPFACTD'/'PSAPFACTI' for tabart 'DFACT' not identical.Container pair 'PSAPODSD'/'PSAPODSI' for tabart 'DODS' not identical.

The inconsistency could cause problems when new tables are created. It

may additionally lead to incorrect free space requirements.

You are urged to fix the entries listed on the previous page now and

repeat the check. Check SAP note 541542 for more information.

I have read note 541542 but so far I see no corrections for my problem.

How to solve this issue?

I have created a message in the SMP and they explained to me that I had to move the content of the table space PSAPDIMI to PSAPDIMD.

I want to do this with th BRSPACE command:

> brspace -u system/***** -f tbreorg -s PSAPDIMI -n PSAPDIMD

But when I continue the reorganisation program I get the following message:

BR0280I BRSPACE time stamp: 2011-03-30 08.59.11

BR0815I Number of indexes in schema of owner SAPC11: 86141

BR0815I Number of indexes in schema of owner SAPSR3DB: 472

So this is not the schema I want to rreorganise. So is mu brspace command correct or do I have to use something else?

Kind regards,

Richard Meijn

[Former Member · Accepted solution]

When I start the command :

brspace -u system/****** -f tbreorg -s PSAPDIMI -n PSAPDIMD

I get the following error and could not proceed:

BR1176E No appropriate table found for function 'tbreorg'

BR0669I Cannot continue due to previous warnings or errors - you can go back to repeat the last action

How could I proceed reorganise the table space?

Kind regards,

Richard Meijn

Edited by: Juan Reyes on Mar 30, 2011 1:36 PM

[sivakumar_kilari3 · Accepted solution]

What is the SID ?

[Former Member · Accepted solution]

The SID is C11.

Kind regards,

Richard Meijn

[former_member204746 · Accepted solution]

brspace -u system/****** -f tbreorg -s PSAPDIMI -n PSAPDIMD

you are asking tables from tablespace PSAPSDIMI to be reorged to table PSAPDIMD

PSAPDIMI only contains indexes, so, obviously, this reorg does not work.

what is exactly your need? what do you want to reorg.. .and where? SAP is completely lost on that point.

your solution is to fix table contents TAORA, TSORA and IAORA.

Edited by: Eric Brunelle on Mar 30, 2011 10:24 AM

[Former Member]

I executed the following SQL command :

SQL> select owner, table_name, tablespace_name

2 from dba_tables

3 where tablespace_name = 'PSAPDIMI';

no rows selected

So there where no rows located in that tablespace.

I changed the entries in the tables IAORA TAORA and TSORA.

After that I was able to continue the upgrade a little.

Kind ragards,

Richard Meijn

[sivakumar_kilari3]

Hi,

Note 541542 - Upgrade phase INIT_CNTRANS: Container inconsistency

Maintain the contents of the tables (TAORA, IAORA) using transaction se16 in the SAP system

ORACLE:

Standard layout: TABART: TAORA-TABSPACE, IAORA-TABSPACE

SSDEF: PSAPES<rel>D, PSAPES<rel>I

SSEXC: PSAPES<rel>D, PSAPES<rel>I

SLDEF: PSAPEL<rel>D, PSAPEL<rel>I

SLEXC: PSAPEL<rel>D, PSAPEL<rel>I

APPL0: PSAPSTABD, PSAPSTABI

USER : PSAPUSER1D, PSAPUSER1I

<...>: PSAP<.....>D, PSAP<.....>I

MCOD layout: TABART: TAORA-TABSPACE, IAORA-TABSPACE

SSDEF: PSAP<sid><rel>, PSAP<sid><rel>

SSEXC: PSAP<sid><rel>, PSAP<sid><rel>

SLDEF: PSAP<sid><rel>, PSAP<sid><rel>

SLEXC: PSAP<sid><rel>, PSAP<sid><rel>

APPL0: PSAP<sid>USR, PSAP<sid>USR

USER : PSAP<sid>USR, PSAP<sid>USR

<...>: PSAP<sid>, PSAP<sid>

Thanks

Siva

[Former Member]

So far I understood I have to maintain the tables TAORA, IAORA after the table space move.

Do I have to move the content first?

Kind regards,

Richard Meijn