How to interpret DBSIZE.XML for SAP on Oracle Migration

[former_member182967]

Hello all,

Can somebody tell me how to interpret the DBSIZE.XML created during export for SAP on Oracle migration.

As I see from the system copy guide:

To find out the size of the export and the sizes of the tablespaces or dbspaces that are created, look at the file DBSIZE.XML located in the directory

I upload the part of the DBSIZE.xml

The size unit is MB or GB?

Thanks & Best Regards,

Tong Ning

[former_member182967 · Accepted solution]

I also upload the another txt part of DBSIZE.XML

<?xml version="1.0" encoding="ISO-8859-1" standalone="no"?>

<!DOCTYPE tables SYSTEM "keydb.dtd" >

<tables>

<tableset  srcid="$Id: //bas/701_REL/src/R3ld/R3szchk/R3szdd.c#12 $">

  <table name="tORA_DatafilesImport" namespaces="DBMODORA">

    <columns>

      <column name="tblspName">

      </column>

      <column name="tblspSize">

      </column>

      <column name="sapdataDir">

      </column>

    </columns>

    <row>

      <fld name="tblspName">

        <strval><![CDATA[PSAPDAI]]>

        </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[PSAPDAI]]>

        </strval>

      </fld>

      <fld name="tblspSize">

        <strval><![CDATA[2000]]>

        </strval>

      </fld>

      <fld name="sapdataDir">

        <strval><![CDATA[SAPDATA7]]>

        </strval>

      </fld>

Please use this as the interpreted part.

The two datafile each 2000MB of tablespace PSAPDAI located in directory ...SAPDATA7? is it right?

Thanks & Best Regards,

Tong Ning

[former_member188883 · Accepted solution]

Hi Tong,

The two datafile each 2000MB of tablespace PSAPDAI located in directory ...SAPDATA7? is it right?

Yes. Your understanding is correct.

To simply the understanding process you may start the import and SAP installer will present the similar data in a tabular format for your better understanding.

You may tweak the size /location as desired.

Hope this helps.

Regards,

Deepak Kori