Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Oracle 8 & Partitions
I have heard Oracle 8 allows partitions to span across
tablespaces. The Oracle 8 Black Book shows an index
with partitions in their own tablespaces.
Can the same be done with the parent tables itself
like
create table x
( a number,
b varchar2(5)
)
partition by (a)
(
partition_1 values equal (1) size... tablespace a, partition_2 values equal (2) size... tablespace b