heterogenous system copy

[Former Member]

Hi to all experts

We did lately an os migration from solaris to AIX, based on oracle.

Still on solaris and before migrating we cloned our production DB to development DB. At that point we had 2 systems running with different SID's but with the same DB schema owner. Now we migrated our DB with oracle tools datapump exp on the source HW and datepump imp in the target HW. To restore our old situation on solaris, we did the imp giving a the development schema owner as parameter input.

What the hell.........

Yes, we relised quite soon something can't be right. In SAP documentation "system copy" it is clear pointed out to not change DB schema, when using not sap tools.

Now, has anybody an idea if we could remedy this situation without doing again an exp/imp and give all objects to the production DB schema onwer.

Thanks for any help

Franco

[markus_doehr2 · Accepted solution]

> What the hell.........

> Yes, we relised quite soon something can't be right. In SAP documentation "system copy" it is clear pointed out to not change DB schema, when using not sap tools.

I would have used sapinst/R3load with "direct data load" (-loadprocedure fast) and table splitting, this would have saved you quite a lot of trouble

> Now, has anybody an idea if we could remedy this situation without doing again an exp/imp and give all objects to the production DB schema onwer.

I would keep the schema if the system is up and running.

Markus

[Former Member · Accepted solution]

Thanks for the asnwer, my questions goes to the direction, can we pach or update some data table inside the db, to get rid of all the erros we receive in some DB transacions.