Exlude Table data from Import

[Former Member]

Hi,

DBTABLOG table has big size log entries & took much time to export hence I would like to exlude the data while importing to mimimize import time.

How can I exclude it at the starting of import?

Regards,

Darshan

[ACE-SAP]

Hello

DBTABLOG is not copied during a client copy / client export as its delivery class is 'L', no exclusion is needed.

It is not possible to exclude a table from a DB/system copy.

Regards

2857 - What table delivery classes are there? What is their signifiance

[Former Member]

Thanks,

I am doing System export/Import. I would like to create only table structure during import & skip data import.

what kind of entries from .STR or .TOC file I can change to skip data import.

I have once simple option to rename DBTABLOG.002 keeping DBTABLOG.001 as it is then once SWPM prompt the error will change the data entries from .TSK file from xeq to ok or igr. But I am not sure about it's impact as this is standard table.

Regards,

Darshan

[former_member188883]

Hi Darshan,

I would not suggest to skip such tables as it may lead to inconsistency in the system.

As you are using DB export/import , you can optimize the import by following methods

1) Increase number of parallel jobs

2) Use table splitting. Split the larger tables into smaller chunks

3) Use distribution monitor to facilitate faster imports

Refer to below documentation for further inputs on optimization

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/8091fedf-5346-2a10-e4a0-a3cafe860...

http://wiki.scn.sap.com/wiki/display/unicode/Downtime+optimization

Regards,

Deepak Kori

[Former Member]

Hi Deepak,

I am skipping data from DBTABLOG table & not the table structure this table has logs only. I don't need to keep that logs in my new test system.

Is it really create any DB inconsistency?

Thanks,

Darshan

[Reagan]

As far as I know the table DBTABLOG contains only logs. Like mentioned in the SAP note 706478 - Preventing Basis tables from increasing considerably you could have deleted unwanted data before the export. If you don't want the table data then you can skip it during the import.

[Former Member]

Hello  Reagan,

Please help me..how can we skip particular table during import.

Regards

S. BASIS.

[andreas_herzog]

You could edit the corresponding TSK file:

T <some table name> C ERR -> change to IGN

But...be careful which entry you change It might get you into trouble...

GreetZ, AH

[Former Member]

Hello  Andreas,

Thankyou for your suggestion...

Can we carry out same thing by manipulating attribute "Activity" in <package>.str file.

As we know "activity" attribute has following values:-

all = Create table/index and load data
data = Load data only (table must be created manually)
struct = Create table/index, but do not load any data

So if I mark tables with “struct”, R3LOAD will not create a data export or import row inside
the task file. This will prevent the export or import of unwanted table data.

Please let me know,whether I m wrong or?

Regards

S.Basis

[former_member188883]

Hi Darshan,

How do you plan to perform the export ?

- DB export   OR

- Client export

In client export using "expert settings" you may exclude this table.

In DB export using SWPM/ SAPINST it is not possible to exclude tables being exported.

Regards,

Deepak Kori