Re: Partitioning user table
Posted by:
Tim Walton
Date: September 14, 2009 10:29AM
That was the other thing I tried, but I get an error because I have a primary key on the user_id:
ALTER TABLE users PARTITION BY KEY ( username ) PARTITIONS 10
#1503 - A PRIMARY KEY must include all columns in the table's partitioning function
Subject
Written By
Posted
September 13, 2009 03:31PM
September 14, 2009 06:43AM
September 14, 2009 07:57AM
Re: Partitioning user table
September 14, 2009 10:29AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.