Re: Partition Views on Oracle 7.3.2

Three things you might check:

1. init.ora: partition_view_enabled = true
2. The queries cannot use bind variables against the partitioned column
3. Each table in the partition must have exact the same columns and the same indexes.

Rgds
Steinar Heggelund

Roberto Bruno <rbruno_at_centroin.com.br> wrote:
: 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.
 

-- 

----------------------------------------------------------------------------
I'm employed in the Norwegian consulting company Opus One AS. 
I have 7 years experience with Oracle products, mainly the database. 
We are a small company which offers consulting services in design,
implementation and tuning of databases and applications based on Oracle.

My postings represent my opinions and they may be wrong.