Error during IMPORT in phase database load

[nirmal_konchada]

Hello All,

I am in the process of migrating my SAP system from HP Unix to AIX.

I have finished exporting the database but I am getting the below error in SAPVIEW.log during the import due to which my work is held up.

-

---

(DB) ERROR: DDL statement failed

(CREATE VIEW "ROVERCUBE3V" ( "KUNNR" , "TYPE" , "FIELD" , "AUFNR" , "DMBTR" , "

WAERS" , "EZDAT" , "MGMAX" , "ERFME" , "MGMIN" , "ANZHL" , "PERIV" , "PERIO" , "

GJAHR" , "COUNTRY" , "REGION" ) AS SELECT T0001."KUNNR", T0001."TYPE", T0001."F

IELD", T0001."AUFNR", T0001."DMBTR", T0001."WAERS", T0001."EZDAT", T0001."MGMAX

", T0001."ERFME", T0001."MGMIN", T0001."ANZHL", T0001."PERIV", T0001."PERIO", T0

001."GJAHR", T0001."COUNTRY", T0001."REGION" FROM "ROVERCUBE3" T0001 WHERE T0001

."OBJVERS" = 'A')

DbSlExecute: rc = 103

(SQL error 942)

error message returned by DbSl:

ORA-00942: table or view does not exist

(DB) INFO: disconnected from DB

-

---

Any help would be highly appreciated.

Regards,

Nirmal.K

[Former Member]

Login to database with orasid, check whether T0001 is existed in the database.

sqlplus / as sysdba

desc sapsr3.T0001

If it exists, just execute create view command by copying and pasting it from error.

As error shows table is not existed. Then go to the source database, take export of this table by EXP and then import it it target database and then execute create view or retry. It should work. Best of luck

[Former Member]

HI NIrmal,

Reason for this error should be corrupted export file .

ORA-00942: table or view does not exist

Error suggest that this table should be created till this time , but it is not.

Either copy export file once again from Source and try once more for import (From start Only) .

If did not work may be you need to re-export.

Regards,

[nirmal_konchada]

Hi Gagan,

Is it fine if I re copy the export dump and start from the point it stopped or should I restart the import from scratch.

Regards,

Nirmal.K

[Former Member]

Hi Nirmal,

We have to start from scratch as that phase has already gone, So starting from same point will not help.

Start from Scratch ..

Regards,