Partition Views on Oracle 7.3.2

I'm having a problem using partition views in Oracle 7.3.2 under a AlphaServer 4100. What I have are some huge tables on a Data Warehouse that I want to partition, but still presenting to users and applications as a single logical table.

According to Oracle documentation, that is accomplished through creating a check constraint on each partition to tell the RDBMS what is the partitioning rule. After that, an index should be created on the column or columns referenced on the check constraint (for each table). Then, the view should be created as a series of select * ... union all.

Well, I did all that and got no partition access. The optimizer tried to make full scans in all tables involved, even though it was perfectly defined which ones could or could not have rows satisfying the query. I made several testes, with 2 to 5 different partitions and different hints, and nothing seemed to work. Does anyone have any idea on how to make this work out ?

If you can, please send ma an answer with a copy to Roberto_Bruno_at_south-america.notes.pw.notes.com (yes, with the capital letters and all - that's a Lotus Notes address).

Thanks in advance for any help.

Roberto Bruno. Received on Sun May 18 1997 - 00:00:00 CDT