SAP Online Portal

Latest SAP News, Solutions, Error Codes, Help Files, Jobs, Documentations, Articles

Exporting and importing sap tables with controlfile

Exporting client

In order to export sap tables, create a controlfile (under /usr/sap/trans/bin/controlfile_export) with following content.

EXPORT

client = 500

file = export_file

select * from VARI

select * from VARID

select * from VARIT

select * from VARIS

select * from VARINUM

and execute following command

R3trans -w /usr/sap/trans/bin/vari_exp.log -u 1 /usr/sap/trans/bin/controlfile_export

Import

In order to import the exported tables into target client, create a controlfile /usr/sap/trans/bin/controlfile_import with the following content

IMPORT

client = 500

file = export_file

execute following command on target system.

R3trans -w /usr/sap/trans/bin/vari_imp.log -u 1 /usr/sap/trans/bin/controlfile_import

Leave a Reply

Your email address will not be published.

Related topics

Db2 sql error 873

Case You are installing a non-unicode and unicode abap+j2ee system on db2 database and getting SQLCODE=-873 and perhaps additionaly a SQLSTATE error or you install […]

The provided sidadm credentials are either incorrect or SAP Note 927637 should be applied.

Case You are executing a kernel upgrade and receiving  message: The provided <sid>adm credentials are either incorrect or SAP Note 927637 should be applied.  Solution […]

No main memory available twrtab reached memory limit during tp

Case: During Client import you get an error something like that: No main memory available (42500000) twrtab reached memory limit; memory usage 42000000 139596 entries […]

Ping Remote SLD with SLD Client User has failed

Case You are trying to register a Sap, probably PI System, in SLD by entering User Password for Data Supplier and Client User (SLD_DS_xx and […]

saposcol error illegal instruction core dumped

Case On some OS platform for example AIX, saposcol does not start during starting sap system or following error occurs if you try to restar […]