Message-Id: <10488.105053@fatcity.com> From: "Charlie Mengler" Date: Fri, 05 May 2000 07:17:24 -0700 Subject: local partitioned primary key 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@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!