-
I am getting warnings, what can fix this?
When I had my oracle install using 8.1.6.0.0 my exports were fine...<P>
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:
<B>On the export:</B>
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
<B>on the import: Note, I made this export with 8.1.6.3.0</B>
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.
-
Is this the first time that you are doing this export first time? if so my question at this point would be, did you execute the catlog, catproc scripts and other rebuld the java server objects and if you have the replication, then catrep. If you are using the oracle intermedia, you might require the ct...x patches. make sure you performed the some or all of the following above steps. It looks like some dependency mismatch, could be in catalog.
Hope this would help you.
Sam
Thanx
Sam
Life is a journey, not a destination!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|