利用Oracle在线重定义Online Redefinition清理历史数据

• Modify the storage parameters of a table or cluster
• Move a table or cluster to a different tablespace
• Add, modify, or drop one or more columns in a table or cluster
• Add or drop partitioning support (non-clustered tables only)
• Change partition structure
• Change physical properties of a single table partition, including moving it to a different tablespace in the same schema
• Change physical properties of a materialized view log or an Oracle Streams Advanced Queueing queue table
• Add support for parallel queries
• Re-create a table or cluster to reduce fragmentation
• Change the organization of a normal table (heap organized) to an index-organized table, or do the reverse.
• Convert a relational table into a table with object columns, or do the reverse.
• Convert an object table into a relational table or a table with object columns, or do the reverse.

create table order_history
(
order_id number primary key,
issue_date date ,
location varchar2(200),
amount number,
maclean varchar2(200),
QUANTITY_SOLD number,
PROMO_ID number,
CUST_ID number,
CHANNEL_ID number) tablespace users pctfree 0;

SQL> select count(*) from ORDER_HISTORY;