Error when doing an export
Hi!
This is my export file:
BUFFER=2000000
CONSTRINTS=n
DIRECT=Y
ROWS=Y
LOG=bla.log
TABLES=boots.bestallningsrad_t, boots.lagersaldo_order_t
OWNER=boots
The export goes well.
My import file:
RECORDLENGTH=64000
FILE=bla.dmp
FULL=n
TABLES=bestallningsrad_t, lagersaldo_order_t
LOG=bla.log
FROMUSER=boots
TOUSER=boots
IGNORE=Y
But the import throws this:
Export file created by EXPORT:V10.02.01 via conventional path
import done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set
. importing BOOTS's objects into BOOTS
. . importing table "BESTALLNINGSRAD_T"
IMP-00058: ORACLE error 904 encountered
ORA-00904: "LEV_FL": invalid identifier
This is my export file:
BUFFER=2000000
CONSTRINTS=n
DIRECT=Y
ROWS=Y
LOG=bla.log
TABLES=boots.bestallningsrad_t, boots.lagersaldo_order_t
OWNER=boots
The export goes well.
My import file:
RECORDLENGTH=64000
FILE=bla.dmp
FULL=n
TABLES=bestallningsrad_t, lagersaldo_order_t
LOG=bla.log
FROMUSER=boots
TOUSER=boots
IGNORE=Y
But the import throws this:
Export file created by EXPORT:V10.02.01 via conventional path
import done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set
. importing BOOTS's objects into BOOTS
. . importing table "BESTALLNINGSRAD_T"
IMP-00058: ORACLE error 904 encountered
ORA-00904: "LEV_FL": invalid identifier
0