export/import in SAP

[Former Member]

Hi experts,

I want to refresh tables PRD system to QTY system.

table is ZMMTMT which contains billions records.. i want to export/import only data not table structure.

while taking export via expdb and after import via  impdb it gives error table ZMMTMT  exist.

SO please give me the script so that i can export/import only data.

Regards,

vivek

[HuseyinBilgen · Accepted solution]

Hi,

You can use the R3trans to export an SAP Table.

Create a command file like exptable.cmd and put the following entries:

Export
Client=<yourclient>
File='ZMMTMT.dat'
Select * from ZMMTMT

Then run the R3trans with <sid>adm user as follow:

R3trans -w <logfilename> exptable.cmd

For Import, use the following command file template:

Import
Client=<target client on target system>
File='/path-to-file'
Commit=100000

Comit depends on the rollback and undo segment size of your target db. Run the R3trans as you did during export.

br

[Former Member · Accepted solution]

hi expert,

i created the exp.cmd file as bleow.

**********************************************************

Export

Client=001

File='TSTC.dat'

Select * from sapsr3.tstc

************************************************************

NOW he gives me below error.

prdbasis:prdadm 49> R3trans -w exp.log exp.cmd

This is R3trans version 6.14 (release 700 - 14.02.08 - 14:55:00).

unicode enabled version

2EETW000 error when reading the R3trans controlfile

2EETW000 unknown option TSTC = yes at line 4, symbol ";".

unknown option TSTC = yes at line 4, symbol ";".

expected: "EQ".

2EETW000 error when reading the R3trans controlfile

2EETW000 syntax error at line 4, symbol ";".

syntax error at line 4, symbol ";".

expected: "EQ".

R3trans finished (0012).

Rgards,

vivek

[HuseyinBilgen · Accepted solution]

Hi,

You put wrong info like schema name. Check my sample below:

[Former Member · Accepted solution]

thanks a lot if i want to export table+data then what is the cmd file.

[HuseyinBilgen · Accepted solution]

Hmm,

Transport the Table structure with a Transport Request and you can also use the same request to transport the table.

Put

R3TR - TABL - <table_name>

into request to transport the structure

put

R3TR - TABU - <tablename>

into request to transport the data