Re: Last Row Inserted

From: at\ <_at_>
Date: Mon, 05 Sep 2005 18:56:55 +0200
Message-ID: <1125939418.21ff0a8449bdf0a700f75d257c1be50f@teranews>

DA Morgan wrote:
>
> So why would a materialized view not be a good solution? Looks like a
> reasonable solution to me.

Can you elaborate please. I need to perform inserts on Table2.

I can imagine that I could do something like: db1 is production box.
db2 is new research box.

Table1 exists on db1.
I create Table2 on db2, identical to Table1.

I create a materialized view MView1 which is a union of Table1 and Table2.

Now MView1 is the table I'm striving to get. Received on Mon Sep 05 2005 - 11:56:55 CDT