DistMon export/import didn't imported package, function etc

[sudip_saha1]

Hi,

We are working on SAP system's OS migration and DB is just upgrading from 11G to 12C. We used distmon to migrate. It seems the distmon tool imported tables, views, indexes but not imported function, view, type body, package, package body, procedure, sequence and type. Here is the summary- You can see there are 3 function imported but no package, package body, procedure, sequence etc imported into target. Please suggest

Source System (HP-Ux):

OWNER OBJECT_TYPE COUNT(1)

---------- -------------------- ----------

SAPSR3 TABLE           27544

SAPSR3 FUNCTION        34

SAPSR3 VIEW            2182

SAPSR3 TYPE BODY       25

SAPSR3 PACKAGE         25

SAPSR3 PACKAGE BODY    25

SAPSR3 PROCEDURE       25

SAPSR3 INDEX           38350

SAPSR3 LOB             3212

SAPSR3 SEQUENCE        1

SAPSR3 TYPE            75

11 rows selected.

Target System (Linux):

OWNER OBJECT_TYPE COUNT(1)

---------- -------------------- ----------

SAPSR3 TABLE      27541

SAPSR3 INDEX      38327

SAPSR3 FUNCTION   3

SAPSR3 LOB        3193

Regards,

Sudip

[former_member1232 · Accepted solution]

Hi Sudip,

Please check export/import monitor logs files, there should be some information. Did you splitted packages using R3TA or PkgSplit or PL/SQL splitter?

I'm afraid something seriously wrong went during prepare steps.

Regards,

Amit Lal

[sudip_saha1 · Accepted solution]

Hi Amit,

We have Unicode system so Unicode migration not required so PL/SQL splitter not required. We used R3TA for package splitting. We kept the big tables in the file package_splitter_tables.txt and package_splitter_tables_gen.txt and Distribution Monitor done the rest for us like creating separate packages for different tables.

We are running the export and import again and this time we will run parallel and let's see how it goes.

Regards.

Sudip

[former_member1232 · Accepted solution]

Hi Sudip,

PL/SQL/Rowid split has nothing to do with Unicode conversion. I have used many times in UC systems.

Please make sure your prepare in DISMON should not have error or warnings.

Amit

[sudip_saha1 · Accepted solution]

Thanks Amit for the reply. Can you please send me any documents you created when you did for your project. I only have dist mon word file and the PPT file comes with DISTMON.SAR.

PL/SQL splitter is for which purpose? If I don't use this and use R3TA and PkgSplit instead?

Regards,

Sudip

[former_member1232 · Accepted solution]

Sudip,

Please refer SAP OSS NOTE below and document linked.

1043380 - Efficient Table Splitting for Oracle Databases

and step by step process for splitting -

Please let me know if any issue happens.

Regards,

Amit Lal

[sudip_saha1 · Accepted solution]

Thanks for the link but I am thinking to use R3ta for table splitting. Let's see how it goes. The above links is from Oracle to HANA where in our case our source and target is Oracle only. We are just upgrading the oracle from 11g to 12c with OS migration from HP unix to Suse Linux.

[former_member1232 · Accepted solution]

No problem. SAP Note is only for Oracle. Document is only for reference on source side of oracle.

More detailed document for your reference