All... I have a table in a 9.2.0 test environment that is supposed to be partitioned to match that in production. the appropriate tablespaces and index_tablespaces have been created, but Im unsure of the proper what to proceed. Heres what I think, correct me in anyway: 1. create table_new w/ partitions 2. -- Bryan S Wells bunjibry@xxxxxxxxx -- //www.freelists.org/webpage/oracle-l