Re: Stored procedures and tablespaces

Good requirement ! I assume the following from your description:

   # the tables are exact replica in these two tablespaces    # this is some audit requirement to keep track of changes

One indirect way to simulate this is to write an ON UPDATE trigger which will do this action. Sure, this is not very elegant as you have to keep writing this trigger everytime you add a new table.

Svein Ormel wrote:

> Hello all.
>
> I'm definitely no Oracle Guru. But my boss tells me to try any way.
>
> What I'm trying to do is creating to sets of tables, each in it's own
> tablespace (lets call them cactus and emms).
> The tables in the cactus tablespace is updated from an external application,
> and each time this happens I would like to extract these new values and
> insert them into the tables in the emms tablespace. These new values will
> then in turn be used by another application, so what I'm really trying to do
> is to create a datalink between two applications.
> The tables in the two tablespaces are not identical so it has to be a field
> by field approach.
>
> I'm just hoping that someone out there has a minute or two to explain how to
> do this.
>
> Any help is greatly appreciated.
>
> Svein
>
> Please respond to
> svein.ormel_at_hitec.no
Received on Fri Jul 17 1998 - 10:29:06 CEST