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

Remote access to the NetWeaver Administrator is forbidden

Case You have installed SAP Java Application Server.  After all,  attempting to access to NWA  you get the error: “Remote access to the NetWeaver Administrator […]

Sap Execution of the command *.db6_update_db.sh.* enable_roles finished with status TST_ERROR

Case You are installing Sap System with DB2 and get following error during executing db2 script residing in installation directory ERROR 2013-01-29 08:13:19.747 [sixxcstepexecute.cpp:937] FCO-00011 […]

SAP trex writer already open failed to create jacket filer CabinetException in Stapler.cpp

Case In TREX, during daily operation for example indexing, you get the following error: ERROR: writer already open [1201441088] 2010-04-29 15:47:22.386 e TrexCabinet Stapler.cpp(01821) :ERROR: […]

ORA-12906: cannot drop default temporary tablespace

Case During dropping psaptemp you get ORA-12906 error Solution First create another temporary tablespace for example temp2 SQL> CREATE TEMPORARY TABLESPACE temp2 TEMPFILE ‘/oracle/SM5/sapdata3/temp_2/temp2.data1’ SIZE […]

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 […]