I am getting warnings, what can fix this?
When I had my oracle install using 8.1.6.0.0 my exports were fine...
log sample:
Connected to: Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
Export done in US7ASCII character set and US7ASCII NCHAR character set
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user RTQA
. exporting object type definitions for user RTQA
About to export RTQA's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export RTQA's tables via Conventional Path ...
. . exporting table ACCESS_CONTROL 78 rows exported
. . exporting table BEV_CATALOG_ITEMS 1252 rows exported
. . exporting table BEV_DISCOUNT_POLICY 789 rows exported
. . exporting table BEV_ITEM_ATTRIBUTE 4968 rows exported
. . exporting table BEV_ORDER_CART_HEADER 0 rows exported
. . exporting table BEV_ORDER_CART_LINE 0 rows exported
Now the I have 8.1.6.3.0 I get this:
Note, the table does get made and the rows do import but I get this:
On the export:
Connected to: Oracle8i Enterprise Edition Release 8.1.6.3.0 - Production
With the Partitioning option
JServer Release 8.1.6.3.0 - Production
Export done in US7ASCII character set and US7ASCII NCHAR character set
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user RTQA
. exporting object type definitions for user RTQA
About to export RTQA's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export RTQA's tables via Conventional Path ...
. . exporting table ACCESS_CONTROL 78 rows exported
EXP-00008: ORACLE error 904 encountered
ORA-00904: invalid column name
. . exporting table BEV_CATALOG_ITEMS 1252 rows exported
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table BEV_DISCOUNT_POLICY 789 rows exported
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table BEV_ITEM_ATTRIBUTE 4968 rows exported
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table BEV_ORDER_CART_HEADER 0 rows exported
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
on the import: Note, I made this export with 8.1.6.3.0
Connected to: Oracle8i Enterprise Edition Release 8.1.6.3.0 - Production
With the Partitioning option
JServer Release 8.1.6.3.0 - Production
Export file created by EXPORT:V08.01.06 via conventional path
import done in US7ASCII character set and US7ASCII NCHAR character set
. importing RTQA's objects into RTQA
. . importing table "TEMP_TABLE" 81 rows imported
IMP-00009: abnormal end of export file
Import terminated successfully with warnings.
