| Error import to 9.2 [message #61419] |
Thu, 22 April 2004 06:00  |
ehoehoeho
Messages: 3
Registered: April 2004
|
Junior Member |
|
|
Hello,
Can anyone please help with the following...
When importing any dmp file I am getting the following errors...
IMP-00017: following statement failed with ORACLE error 4068:
"BEGIN SYS.DBMS_REPCAT_MIG.PRE_IMPORT; END;"
IMP-00003: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_REPCAT_MIG" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
IMP-00000: Import terminated unsuccessfully
(source and target databases aren't of same version (export from 8.1.6 and import to 9.2))
Any ideas greatly appreciated!
Thanks.
|
|
|
|
|
|
| Re: Error import to 9.2 [message #61423 is a reply to message #61422] |
Thu, 22 April 2004 06:50  |
ehoehoeho
Messages: 3
Registered: April 2004
|
Junior Member |
|
|
Of course i did. But it's not a direct upgrade, i want to import to a different computer...and Oracle 9i manual is not very useful concerning errors i mentioned...
Anyone else please?
thx
|
|
|
|
| Re: Error import to 9.2 [message #61424 is a reply to message #61423] |
Thu, 22 April 2004 07:36 |
Anatol Ciolac
Messages: 113
Registered: December 2003
|
Senior Member |
|
|
|
At first export a one table from 9.2.0, delete them and import again in 9.2.0 - to observe if error yet will apppear. Try to export/import only users,that have objects(not to perform full export/import). See if indicated package don't have errors. Try to reexecute a file catexp.sql in rdbms directory(9.2.0) - this file make objects, needed for export/import.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
