Homegeneouscopy R3load procedure generated more tables on target system

[Former Member]

Hi All

My source system is 46C SR2 /oracle 817/HP_UX PARISC and

Target System is 46CSR2 /Oracle 10202/HPUX IA

I used R3load procedure to export database from source system and completed import successfully into target system without any problem.The new system is up and running.

My Source system has total 23193 tables but the target system has 23771 tables and source system has 27011 indexes and the target system has 27701 indexes.

Can someone tell me why there are additional tables and indexes in my Target system.Is it due to oracle 10g.

Your help will be appreciated.

Thanks

Amit

[Former Member]

Markus,

I got this information from DB02 first screen where it shows number of tables and indexes.

Actually I used r3load procedure to export data from source and prepared target system also by r3load,

The source systems had less tables but the target got more.I have upgraded the target system to ecc6

and working fine.UAT completed and gone live.

Auditors have raised the question .

Let me know if there is any way to find this difference of tables though target is now ECC6.

Thanks

Amit

[markus_doehr2]

> Let me know if there is any way to find this difference of tables though target is now ECC6.

Well - no... unfortunately not.

Markus

[markus_doehr2]

You may have had tables/indexes on the source system that were in the dictionary but not on the database. Where did you get those numbers? DB02?

Markus