Re: Creating Oracle Repository/Designer 9.0.2 to Oracle 8i ee

On Sun, 01 Jun 2003 20:54:52 +0200, GoranV <gorle_at_freemail.com.mk> wrote:

>Hi to everyone,
>
>First of all I'd like to excuse for my bad English.
>So I got problem with installing new repository from Repository
>Administration Utility.
>I have installed Oracle 8i enterprise edition and Oracle9iDS on W2k Pro.
>They are installed in differnet oracle home dirs.
>When I begin with installation of repository, i've got CDR-21244 error
>log file is:
>-----------------
>IMP-00003: ORACLE error 942 encountered
>ORA-00942: table or view does not exist
>IMP-00023: Import views not installed, please notify your DBA
>IMP-00000: Import terminated unsuccessfully
>-----------------
>I was reading about errors through Internet, and find a solution that
>exp.exe and imp.exe from EXECUTE_EXPORT and EXECUTE_IMPORT parameters
>(which is default on Oracle9iDS) must set on other oracle home 8i
>folder.
>I set this but..:( no luck..i've got other error msg
>log is:
>------------------------
>IMP-00058:
>IMP-00000: Import terminated unsuccessfully
>-----------------------
>After that i've no idea? What would be the problem?
>Please if any of Oracle Administrators know the problem, could write
>here or send me a mail..
>Please Help.:(
>Thanx a lot.
>Gorle

Either you didn't run the script for the 9i export views, for the latest version always called $ORACLE_HOME/rdbms/admin/catexp.sql or (more likely) you didn't create the Oracle 8 export views. The script probably is called catexp8.sql and should be run as internal.

Please note also you can't import 9i exports in 8i. You should create an 8i export.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sun Jun 01 2003 - 16:02:37 CDT