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

Vo <dbqkdv0l67jep32qu6r8l0l3f2dgjim14f_at_4ax.com> Sybrand Bakker napisha:

| 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.
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 Received on Mon Jun 02 2003 - 07:28:54 CDT