Re: multiple schemas per user - possible?

"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote:
> Not that obvious. How do you propose "maintaining parallel data sets for
> the same versions of the tables" with multiple databases?

What does that mean?

> If EMP is in both database A and database B, it's not the same table, is
> it?

That's zen question, not a database question. If both tables were created from the same create script, then the table structure is the same. If you refresh the data from one table to another, then the data will also be the same.

> Never mind the same "version of the table".

Apparently you don't want the same "version of the table", you want different versions. Are else what are you asking? You want tables that are exactly the same (in structure and contents) except that they aren't exactly the same?

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
                    Usenet Newsgroup Service