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

Home -> Community -> Mailing Lists -> Oracle-L -> local partitioned primary key

local partitioned primary key

From: Charlie Mengler <charliem_at_mwh.com>
Date: Fri, 05 May 2000 07:17:24 -0700
Message-Id: <10488.105053@fatcity.com>


I'm trying to learn more about partitioned indexes. As part of this learning effort, I'm trying to create local partition index that also happens to be the primary key on the table.

Is it possible to create a local partition primary key?

I can't seem to compose any acceptable SQL syntax using the ALTER TABLE command.

I'd like to see any working SQL example & hopefully from the example I can modify it to work for me here.

TIA!

-- 
Charlie Mengler                       Maintenance Warehouse  
charliem_at_mwh.com                      5505 Morehouse Drive   
858-552-6229                          San Diego, CA 92121    
If you don't use vi, then you shouldn't be working on UNIX!
Received on Fri May 05 2000 - 09:17:24 CDT

Original text of this message

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