ORA-00904: : invalid identifier during R3Load
Dear Guru's,
I'm doing a migration from :
Source System :
O/S : Linux
Kernel : 4.6D Ext
DB : Oracle 8.1.7
to
Target System :
O/S : Windows 2003
Kernel : 4.6D Ext
DB: Oracle 10 R2 (latest patches)
but encountered in Phase DBR3LOADVIEW_NT_ORA :
#START: 20081211162539
error message: No such file or directory
(GOS) WARNING: Unable to open file "NULL\.EXT" - default sizes assumed for initial extents
#Trying to create view "V_PDBKUR"
DbSl Trace: ORA-904 occurred; SQL statement is ==>
(IMP) ERROR: CREATE statement failed for object "V_PDBKUR"
(CREATE VIEW "V_PDBKUR" ( "MANDT", "PERNR", "INPER", "FPPER", "SEQNO", "KENID", "ZVKAS", "STATS", "BESCH", "WERKS", "BTRTL", "RZNSK", "RZNAG", "BNRSK", "NUS01", "NUS02", "RZDAT", "VERNR", "FNAME", "ZVKAN", "SKPNR", "MDART", "ABRMO", "ABRJA", "BEGDA", "ENDDA", "STONR", "WAERS", "BTAGE", "BLOHN", "AFSTD", "NUS03", "GTAGE", "GVERG", "GZUTG", "NUS06", "GSTDG", "GSTDB", "GBRTL", "GLGRP", "NACHN", "VORNA", "NUS05" ) AS SELECT T0002."MANDT", T0002."PERNR", T0002."INPER", T0002."FPPER", T0002."SEQNO",
T0002."KENID", T0002."ZVKAS", T0002."STATS", T0002."BESCH", T0002."WERKS", T0002."BTRTL", T0001."RZNSK", T0001."RZNAG", T0001."BNRSK", T0001."NUS01", T0001."NUS02",
T0001."RZDAT", T0001."VERNR", T0001."FNAME", T0001."ZVKAN", T0001."SKPNR", T0001."MDART", T0001."ABRMO", T0001."ABRJA", T0001."BEGDA", T0001."ENDDA", T0001."STONR",
T0001."WAERS", T0001."BTAGE", T0001."BLOHN", T0001."AFSTD", T0001."NUS03", T0001."GTAGE", T0001."GVERG", T0001."GZUTG", T0001."NUS06", T0001."GSTDG", T0001."GSTDB",
T0001."GBRTL", T0001."GLGRP", T0001."NACHN", T0001."VORNA", T0001."NUS05" FROM "PDBKUR" T0001, "PDBKAD" T0002 WHERE
T0001."MANDT" = T0002."MANDT" AND T0001."PERNR" = T0002."PERNR" AND T0001."INPER" = T0002."INPER"
AND T0001."FPPER" = T0002."FPPER" AND T0001."SEQNO" = T0002."SEQNO" AND T0001."KENID" =
T0002."KENID")
DbSlExecute: rc = 99
(SQL error 904)
error message returned by DbSl:
ORA-00904: "T0001"."GLGRP": invalid identifier
Can someone help?
Thank You