Re: ?partition views?

[snip]

Did you set PARTITION_VIEW_ENABLED=TRUE in init.ora?

The script is OK.
This is the execution plan in my test database (v8.04), with no rows in the table.

Execution Plan

   0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=1 Bytes=44)    1 0 VIEW OF 'TX' (Cost=2 Card=1 Bytes=44)

   2    1     UNION-ALL (PARTITION)
   3    2       FILTER
   4    3         TABLE ACCESS (FULL) OF 'T1' (Cost=1 Card=1 Bytes=35)
   5    2       FILTER
   6    5         TABLE ACCESS (FULL) OF 'T2' (Cost=1 Card=1 Bytes=35)
   7    2       FILTER
   8    7         TABLE ACCESS (FULL) OF 'T3' (Cost=1 Card=1 Bytes=35)
   9    2       FILTER
  10    9         TABLE ACCESS (FULL) OF 'T4' (Cost=1 Card=1 Bytes=35)
  11    2       FILTER
  12   11         TABLE ACCESS (FULL) OF 'T5' (Cost=1 Card=1 Bytes=35)
  13    2       TABLE ACCESS (FULL) OF 'T6' (Cost=1 Card=1 Bytes=35)