You can create an unpartitioned round-robin table from a partitioned round-robin table using alter table with the unpartition clause—as long as all partitions are on the same segment, and there are no indexes on the table. This capability is useful when you are loading large amounts of data into a table that is eventually be used as an unpartitioned table. See “Using partitions to load table data”.
Copyright © 2005. Sybase Inc. All rights reserved. |