IMPORT

[Former Member]

Hi,

I try to download the huge table data in from sap to dektop,getting TSV_NEW_PAGE_ALLOC dumps.

Can you give any other way to download the this huge data in table?

Regards,

Manjini

[Former Member · Accepted solution]

Hello Manjini

You can use export facility, either by direct exp command or by BRTOOLS

http://www-it.desy.de/systems/services/databases/oracle/impexp/impexp.html.en

http://help.sap.com/saphelp_nw70/helpdata/en/7c/209667b05b844399f6402a0213ef95/content.htm

thanks

Bhudev

[Former Member · Accepted solution]

Hi,

I a using Db2 database.I need to download the huge data from table.Is any oter way is there in sap to download to server?

Regards,

Manjini

[Former Member · Accepted solution]

Hello

first you have to create a .dmp and a .log file in /usr/sap/trans and have to run exp command by logging as orasid, while giving exp command it requires sapr3 or sapsr3 user and password, for eg, to take export of some rfc tables

r4lpar14:oraqr1 18> exp sapsr3/password tables=RFCATTRIB,RFCCHECK,RFCCMC,RFCDES,RFCSYSACL,RFCTRUST,RZLLICLASS,RZLLITAB,RFCDESSECU file=/usr/sap/trans/bkp_QR1_new.dmp log=/usr/sap/trans/bkp_QR1_new.log rows=yes

thanks

Bhudev

[Former Member · Accepted solution]

sorry couldn't get to see your post, export is there also in DB2, however i have never done in DB2

http://www.cse.yorku.ca/~jarek/db2/import.html

[Former Member · Accepted solution]

Hi,

I am using db2 database.What i will do?

Regards,

Manjini

[Former Member]

Hi,

Please check following notes for Resalution

OSS NOTE: 583698,944221

Regards

Krishna