Re: Just need a small hint re: mirroring tables

Paul Murphy wrote:

> <snipped>
>
> I'm trying to get two pieces of software to share the same data, but
> they both have hardcoded into the executables the different
> schema.tablename. Because I can't modify the software, I have to create
> two duplicate tables of the same name in two separate schemas, but I
> need both executables using the same data, so I need them to be
> constantly synchronized. Maybe this is not a common problem and that's
> why I'm having so much trouble finding anything in books. Any ideas
> given the situation? Thanks! -Paul

No you don't. Look up synonyms at http://tahiti.oracle.com

If you disagree post the names of the software manufacturers, the applications, and the names of the tables.

This reads as somehwere between highly unlikely and not very believable.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)