Re: Problem installing CASE 5.1 (Windows)

In article <1994Dec20.054419.15466_at_cerberus.bhpese.oz.au> bigbod_at_cerberus.bhpese.oz.au (Rodney Coleman) writes:
> Hi! I am attempting to install CASE 5.1 for Windows and have run into

Good luck! (You'll need it!)

> a problem installing definition tables for user SYSCASE. When I use

Gee, that sounds familiar!

> the CASE*DBA utility and select "Create Definition Tables" in the
> "Definition Data Table Owner (Public Domain)" block, all proceeds
> well until the import nears completion. At this stage, the "Import
> Output" window closes and the PC locks up. The CASE*DBA screen is
> not refreshed, and I have the reboot the PC in order to return to
> Windows. Has anyone else experienced this, and have a solution ??
>

Yeah, but you won't like it!

> FYI, software versions are:
>
> On client: MS-DOS 6.2
> Windows for Workgroups 3.11
> CASE 5.1 for Windows 5.1.6.0.0
> SQL*Net TCP/IP for Windows 1.1.7.8
>
> On server: SunOS 4.1.3
> Oracle7 7.0.16.6.0
> SQL*Net TCP/IP 1.2.7.7.1
>
> Thanks in advance for any assistance.
>

Our setup was similar, except that we had 7.0.11.x.x running on an HP3000 with MPE!

In any case, I flipped through my notes and found some rather cryptic information (but it seemed clear back then!)

"Thought: importing CDCASE.DMP requires that access be granted to certain tables. However, the access cannot be granted until import is finished. Thus, tables must be *precreated*, access granted, then import with IGNORE=Y" I don't know if the above is true, but it sounded good at the time.

What I apparently ended up doing was :

1. Drop the definition tables from previous attempt.
2. Create the definition tables using casedba, wait until the import crashes.
3. Delete all rows from the definition tables (I wrote/modified a script to do this).
4. Import the file \orawin\dict51\ins\cdcase.dmp. "imp syscase/syscase_at_<connect string> full=Y file=cdcase.dmp log=impcdef.c ignore=Y"

The Windows version of IMPORT didn't work too well, as I recall, so I may have done this through OS/2 or moved the file to the server and done it there.

Hope this helps. My sympathies.

Matt Lih (lih_at_venice.sedd.trw.com) Received on Wed Dec 21 1994 - 21:03:39 CET