| Export / Import fails with IMP-00058 and ORA-00604 [message #73323] |
Wed, 24 March 2004 01:17 |
Severi
Messages: 1
Registered: March 2004
|
Junior Member |
|
|
Export is taken from Oracle 9.2.0.4.0 and import should get done into Oracle 8.1.6 or 8.1.7. Export is done with exp version 8.1.5. Import version is 8.1.6 or 8.1.7 respectively to the target databases. During export, it gives much errors, but these has not affected to succession of work during last imports.
Before import I dropped every tables from target database execpt one (I truncated it), because it is quite big and it's definitions should stay in the database.
Everything else goes quite fine, but this big one table creates following problem:
...
. . importing table "MZDBMS_ELEMENT"
IMP-00058: ORACLE error 604 encountered
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist
...
Does that size of table create the problem? Or is it SDO_GEOMETRY - type which table includes?
SQL> select sum(bytes) from user_segments where segment_name = 'MZDBMS_ELEMENT';
SUM(BYTES)
----------
2154823680
Please ask more information, if this does not give enough information.
Source: Windows 2000, Oracle 9.0.1
Target (test environment): Unix (SunOS 5.8), Oracle 8.1.6
Secondary Target (production): Unix (SunOS 5.8), Oracle 8.1.7
Transfer has succeeded before (last time was 09/2003).
Regards
Severi Mäkelä
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
