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 -> Re: Partitioned Primary Key - Oracle 8i

Re: Partitioned Primary Key - Oracle 8i

From: Stefan Roesch <Stefan.Roesch_at_t-online.de>
Date: 2000/08/09
Message-ID: <39919FB0.D1A8432B@t-online.de>#1/1

You have to distinguish what kind of partitioning you are using * global or local

if you are using local partitioning- you don't need to enter the partition bounds and the tablespaces
with global indexes you have to enter the partition bounds und the tablespaces

Despite this you can chabge the tablespaces afterwards. These operations can be performed online

You have miised the syntax for the statement completely. Please look it up in the administrators guide or in the sql reference manual.

Yours Stefan

rspeaker_at_my-deja.com wrote:

> hi,
>
> is it possible to create a partitioned primary key on a table?
> I have tried this using the normal PK syntax but it fails.
>
> I have created a table using hash partitions on an ID field.
> This same field will be included in the PK, along with a timestamp.
> I want to partition the PK as well.
>
> I tried using
>
> alter table <TABLENAME>
> add constraint (CONSTRAINT_NAME)
> primary key (timestamp,id)
> using index tablespace (ts1,ts2,ts3,ts4)
> storage (initial blah blah blah);
>
> it fails, gives me a message that says
>
> ERROR at line 4:
> ORA-02216: tablespace name expected
>
> is there a syntactical difference to creating a partitioned PK?
>
> I'm using Oracle 8.1.6 on AIX 4.3.3
>
> Thanks,
> Roy
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Aug 09 2000 - 00:00:00 CDT

Original text of this message

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