Re: designer/2000 version compatibility with oracle

Yes this is a version compatible problem as I remember. The problem is the Des2K 1.3.2 repository looks for Oracle 7.3 IMP/EXP utilities in the Windows Registry. You need to find out those entries using REGEDIT utility and change them to make use of Oracle8 utilities
(they differ by name like imp73 in Oracle73 and imp80 in Oracle8).
So, using regedit, find the strings
for imp73 / exp73 and rename them to reflect your Oracle8 utilities. After doing this,
you should be able to install the repository.

But even after there is one more issue.
You need to grant the execute permissions to the repository user on DBMS_PIPE and DBMS_LOCK packages before installing repository. Otherwise, you will have problems

Hope this helps.

Good luck.

Madhu Cherukuri

pawan_kamra_at_my-dejanews.com wrote in message <7csg52$u0v$1_at_nnrp1.dejanews.com>...
>Hi,
>
>We have Oracle8 Enterprise Edition ver. 8.0.5.0.0. We are trying to create
>repository for designer/2000 ver. 1.3.2 (32-bit) on our oracle8 server. But it
>is giving problem.
>We have installed designer/2000 on a pentium. Oracle 8 is installed on another
>macihne.
>Earlier we were easily able to create repository with this designer/2000 on
>Oracle 7 installations.
>
>For oracle8, from designer/2000 RAU (6.0.10.0.1), when we give start (to
>create repository), it gives these errors :
>
>IMP-00003 Oracle Err 942 encountered
>ORA-00942 - Table or view doesn't exist
>IMP-00023 Import Views not installed
>IMP-00000 - Import Terminated unsuccessfully.
>
>It seems repository creation scripts search for some import table/views which
>are version specific. But we are not sure.
>
>SO IS IT VERSION/COMPATIBILITY PROBLEM BETWEEN Oracle* and Designer 2000
>1.3.2.
>
>Reagrds,
>Pawan
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Sat Mar 20 1999 - 18:40:30 CET