Oracle Schema Conversion SAPR3 > SAPSR3 (SAP)

Scenario

Your client has requested to do a SAP schema conversion from SAPR3 to SAPSR3 in Oracle database environment. Your client has supplied below information to you be able to complete the activity as requested.

SAP: SAP ERP 6.0
Database: Oracle 10.2.0.4.0
Operating System: Windows Server 2008 R2

Activity

The execution is based on Homogeneous System Copy via SWPM.

Execution

1. Perform the system export.

2. Once the system export is completed, browse to the export file and look out for below files, under \ABAP\DB folder,

DDLORA.TPL and DDLORA_LRG.TPL

loc: APPL0 PSAPR3                         0000
     APPL1 PSAPR3                         0000
     APPL2 PSAPR3                         0000
     CLUST PSAPR3                         0000
     DDIM  PSAPR3                         0000
     DFACT PSAPR3                         0000
     DODS  PSAPR3                         0000
     POOL  PSAPR3                         0000
     SDIC  PSAPR3                         0
     SDOCU PSAPR3                         0000
     SLDEF PSAPR3700                      0000
     SLEXC PSAPR3700                      0000
     SLOAD PSAPR3                         0000
     SPROT PSAPR3                         0000
     SSDEF PSAPR3700                      0000
     SSEXC PSAPR3700                      0000
     SSRC  PSAPR3                         0000
     TEMP  PSAPR3                         0000
     USER  PSAPR3USR                      0000
     USER1 PSAPUSER1D                     0000

Under \ABAP\DB\ORA folder,

DBSIZE.XML

  </row>
    <row>
      <fld name="tblspName">
        <strval><![CDATA[PSAPR3700]]>
        </strval>
      </fld>
      <fld name="tblspSize">
        <strval><![CDATA[2000]]>
        </strval>
      </fld>
      <fld name="sapdataDir">
        <strval><![CDATA[SAPDATA7]]>
        </strval>
      </fld>
    </row>
    <row>
      <fld name="tblspName">
        <strval><![CDATA[PSAPR3700]]>
        </strval>
      </fld>
      <fld name="tblspSize">
        <strval><![CDATA[2000]]>
        </strval>
      </fld>

4. Open the files using notepad or wordpad. Then, use the function replace to switch R3 to SR3. Once done, save the changes. You will see the tablepspace layout is been rename to SAPSR3.

5. Next, do the system import and wait till the import completed. After the import is finished, do verification checks on transaction code DB02.

Note

SAP Note 957917