Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Oracle 8 & Partitions

Oracle 8 & Partitions

From: John W. Frank <jfrank_at_icdc.com>
Date: Mon, 01 Mar 1999 20:42:54 -0500
Message-ID: <36DB421E.DD88B64C@icdc.com>


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

    )
; Received on Mon Mar 01 1999 - 19:42:54 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US