ROWID and Views - Problem?

From: <apollopaulr_at_my-dejanews.com>
Date: Wed, 28 Apr 1999 14:28:24 GMT
Message-ID: <7g75u1$59j$1@nnrp1.dejanews.com>

Is it valid to query a view on ROWID when the view is a UNION of multiple tables having the same structure?

I have thirteen tables. Table 0 holds this month's transactions (approx 1 million). Tables 1 through 12 hold a month's worth of previous transactions, back a year. A view is used to allow queries against a year's worth of transactions.

This smells like Data warehouse, but I don't (yet) have experience building one. So, we use the view. Problem is a query against this view using ROWID now fails. What are we doing wrong?

P. Apollo
apollopr_at_yahoo.com

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Apr 28 1999 - 09:28:24 CDT