• Incremental Statistics Maintenance – what statistics will be gathered after DML occurs on the table? (Oracle Optimizer)
  strategies for gathering statistics DML new feature 11g; helpful for partitioned tables
  in Oracle > DB 11g with 11g blog gathering incremental oracle partitioned statistics table tables
• Oracle Database: How to move partitioned tables to different tablespace
  Changing the default tablespace of Partition table. Now new partitions will be created in the new default tablespace, but old partitions will remain in the old default tablespace :- SQL> alter table partition modify default attributes tablespace users; Table altered.
  in Oracle > DB 11g with a alter attributes cannot different modify move object on operation ora-14511: partition partitioned partitions perform table tablespace to

partitioned from all users