From: GoranV <gorle@freemail.com.mk>
Newsgroups: comp.databases.oracle.misc
Subject: Re: Creating Oracle Repository/Designer 9.0.2 to Oracle 8i ee
Date: Mon, 02 Jun 2003 14:28:54 +0200
Organization: home
Message-ID: <1ogmdv4md05mgtfodo55ejg0k48dm4ta92@4ax.com>
References: <lvikdvs1dfd0rq5n0g06bplh310tbqsskn@4ax.com> <dbqkdv0l67jep32qu6r8l0l3f2dgjim14f@4ax.com>
X-Newsreader: Forte Agent 1.8/32.548
X-No-Archive: yes
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 212.110.77.111
X-Trace: 2 Jun 2003 14:29:14 +0100, 212.110.77.111
Lines: 57
Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!news-out.cwix.com!newsfeed.cwix.com!news.mt.net.mk!212.110.77.111
Xref: core-easynews comp.databases.oracle.misc:98298
X-Received-Date: Mon, 02 Jun 2003 05:28:33 MST (news.easynews.com)

Vo <dbqkdv0l67jep32qu6r8l0l3f2dgjim14f@4ax.com> Sybrand Bakker napisha:


| On Sun, 01 Jun 2003 20:54:52 +0200, GoranV <gorle@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.
I start the catexp.sql as a sys. The script run successfully.
Views,grants are created.
But the error continue. 
Any suggestions?

| 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

Gorle