transport system objects i.e. contents of table t100 from one system to ano

[Former Member]

hello all,

how do i transport contents of table t100 from one system to another...

tried creating a transport request... but when i got an error when used r3tr tabu t100... i got a pop up saying

"System objects cannot be transported directly"

know abt restore... any other way of doing it...

Regards, Jatin

[former_member1351727 · Accepted solution]

Hi,

I am just telling ways to export tables ..However I am not sure if it will work for this table or not as I never tried it with this table.

Try using R3trans and export the table.

SAPDBA.

or by exp tool at oracle level.

Thanks.

[Former Member]

hello all,

thanks for the support so far...

this is wat is did...

in/from source system

1st transfered the structure of the table...

created a TOC

exported the entries to the local machine (as a txt file)

uploaded the txt file to the TOC created using an internal tool

added * for the table key field in the TOC (to select all the entries of the table)

at the OS level exported this TOC and later imported the same into the target...

It ended with RC = 8... and not all the entries came... i think i lost around 10% of the entries...

but its fine...

i hope this helps...

Regards, Jatin

[Former Member]

Hello all,

Thanks for the support so far...

to clarify the problem in more detail...

when i add R3TR TABU T100... and hit enter... i get the error message at the bottom of the screen...

" System objects cannot be transported directly (e.g. T100, TRDIR, TFDIR..) "

When i double click the error message, i get a pop up, detailing the "KINDS" of tables which cannot be

transported. (like in my case is t100)...

The only help which i get at the bottom of the popup is...

"Direct transport of these table entries is only allowed for special tools, such as the client copy program."

Any other way of doin it...

Regards, Jatin