Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Export table data from production to quality system - Oracle 10.2

Hi,

I am trying to export a few table's data from our production system to the quality system.

Reason: To synchronize the table data between Production and Quality system

System info: SAP ECC 6.0 on Oracle 10.2 ; OS: Solaris

Description:

There are few standard SAP tables which hold the data of the various institutions of our client. Our requirement is to export the master data relevant for a particular institution from the production system to the quality system. We intend to use the Oracle Export and Import utility (Suggestions on the usage of which tool are welcome).

Constraints:

Lets say, there is a table NXXX in production system. This table contains the data for the institutions AA, BB, CC. I intend to export the data relevant to the institution AA from the table NXXX and import the data to the table NXXX in the Quality system.

Now I understand that the schema of these tables are different. In the production system, the schema would be SAP<Prod SID>.NXXX and in the quality system, the schema is SAP<Qas SID>.NXXX. I need your suggestions to overcome this constraint.

Regards,

Not what you were looking for? View more on this topic or Ask a question