Partitioned tables are created using the naming convention: <parentname>_<level>_prt_<partition_name> For example: sales_1_prt_jan08 Or for auto-generated range partitions (a number is assigned when no name is given): sales_1_prt_1 It is not possible to rename a partitioned child table directly by altering the table name. However, you can rename the top-level parent table, and the associated <parentname> will change in the table names of all associated child table partitions. For example: ALTER TABLE sales RENAME TO globalsales; Would change the associated table names accordingly: globalsales_1_prt_1 You can also change the partition name of a partition to make it easier to identify. For example: ALTER TABLE sales RENAME PARTITION FOR ('2008-01-01') TO jan08; Would change the associated table name accordingly: sales_1_prt_jan08 When altering partitioned tables with the ALTER TABLE command, they are always referred to by their partition name (jan08) and not their full table name (sales_1_prt_jan08). |