cancel
Showing results for 
Search instead for 
Did you mean: 

Hetorogenous copy Import problems

Former Member
0 Kudos

     Hi all,

we are doing heterogenous copy from :

LINUXX86_64

Databse ORacle 10.2.0.4

SAP NW 7.0 SP3

To win2008 EER2

Databse ORacle 10.2.0.4

SAP NW 7.0 SP3

Import fails for TABLE ACCTIT

Log says :

(RTF) ########## WARNING ###########

    Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases

(DB) INFO: ACCTIT deleted/truncated #20160822095612

(IMP) INFO: import of ACCTIT completed (305816807 rows) #20160822124937

(SQL) INFO: Searching for SQL file SQLFiles.LST

(SQL) INFO: SQLFiles.LST not found

(SQL) INFO: Searching for SQL file H:\export\ABAP\DB/SQLFiles.LST

(SQL) INFO: H:\export\ABAP\DB/SQLFiles.LST not found

(SQL) INFO: Searching for SQL file USER2.SQL

(SQL) INFO: USER2.SQL not found

(SQL) INFO: Searching for SQL file H:\export\ABAP\DB/ORA/USER2.SQL

(SQL) INFO: H:\export\ABAP\DB/ORA/USER2.SQL not found

(DDL) ERROR: no tablespace for TABART USER2

(DB) INFO: disconnected from DB

E:\usr\sap\PPS\SYS\exe\nuc\NTAMD64\R3load.exe: job finished with 1 error(s)

E:\usr\sap\PPS\SYS\exe\nuc\NTAMD64\R3load.exe: END OF LOG: 20160822124937

Thank you

Accepted Solutions (0)

Answers (2)

Answers (2)

manish_singh13
Active Contributor
0 Kudos

Hi Pavol,

Along with wiki which Pavol mentioned, please confirm if you ran report SMIGR_CREATE_DDL in your source system and generated the SQLFiles.LST because in logs provided by you above it seems that this file is missing.

(SQL) INFO: Searching for SQL file SQLFiles.LST

(SQL) INFO: SQLFiles.LST not found

(SQL) INFO: Searching for SQL file H:\export\ABAP\DB/SQLFiles.LST

(SQL) INFO: H:\export\ABAP\DB/SQLFiles.LST not found

This report execution and SQL file generation is one of the important step which needs to be done in Source System.

Thanks,

Manish

thiago_cavalheiro
Active Participant
0 Kudos

Hello Pavol,

You need to adjust TAORA, IAORA and TSORA for TABART USER2. You can read more in the wiki page below:

http://wiki.sdn.sap.com/wiki/x/v41RCw


Best regards,

Thiago