Re: distributed database option

Hi :)

Well u need to run catproc.sql in order to have PL/SQL and stored procedure, trigger and package capability. U must run this script while connected as sys or internal. This script is under <Oracle_Home>\rdbms80\admin or check in your installation for the directory <Oracle_Home>\rdbms

Go to the above directry run svrmgr (check the file name for this executeable it should be in the <Oracle_Home>\bin directory) then connect as internal and run the script @catproc

Once u have done this, hopefully your problem should disappear.

Hope this help u out.

In article <35D6F204.43F9D207_at_austin360.com>,   Allan Nelson <nels212_at_austin360.com> wrote:
> soumitrabose_at_hotmail.com wrote:
>
> > I need a help/advice.
> > I am installing two instances of Oracle 8.0.4 on a sequent box.
> > I have triggers in a few tables in both the instances. These triggers
> > insert,update and delete in the two tables of the two instances. That means,
> > when there is an insert in one table of one instance the insert will trigger
> > another instance in a similar table in the other instance.
> > when I try to run the insert,update and delete I get an error message
stating
> > that (error code 2088) that distributed option is not available and for v7
one
> > has to buy it as a separate patch. But the versions of my databases are
8.0.4.
> > What should I do to overcome this?
> > I am in a mission critical application and I have come to a screaching halt.
> > I would appreciate any urgent help and advise.
> > Thanks,
>
> You can do this through the creation of a database link. You can do this
without
> having the distributed database option installed, I think.
>
> Allan
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Sun Aug 16 1998 - 13:54:56 CDT