Copy clustered base tables

If you copy a CBT by using a command similar to CREATE TABLE AS, the target table does not inherit the organizing keys of the base table. You must use an ALTER TABLE ORAGNIZE ON command to apply the organizing keys that you want to use for the target table.