COUNT(*)

　　----------

　　2880844

　　SQL> SELECT COUNT(*) FROM XXNEW;

　　COUNT(*)

　　----------

　　0

　　SQL> select * from user_mview_logs where master='XXOLD';

　　LOG_OWNER MASTER LOG_TABLE LOG_TRIGGER ROWIDS PRIMARY_KEY OBJECT_ID FILTER_COLUMNS SEQUENCE INCLUDE_NEW_VALUES

　　------------------------------ ------------------------------ ------------------------------ ------------------------------ ------ ----------- --------- -------------- -------- ------------------

　　SQL> select * from user_mview_logs where master='XXNEW';

　　LOG_OWNER MASTER LOG_TABLE LOG_TRIGGER ROWIDS PRIMARY_KEY OBJECT_ID FILTER_COLUMNS SEQUENCE INCLUDE_NEW_VALUES

　　------------------------------ ------------------------------ ------------------------------ ------------------------------ ------ ----------- --------- -------------- -------- ------------------

　　SQL> CREATE TABLE XXNEW partition by range(COMMANDFINISHTIME,COMMANDLSTTXDATE)

　　2 (

　　3 partition PT_XXOLD_2004 values less than (TO_DATE('2005-01-01 00:00:00', 'YYYY-MM-DD

　　4

　　5 HH24:MI:SS'),TO_DATE('2005-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'))

　　6 tablespace USER_DATA_2004

　　7 ,

　　8 partition PT_XXOLD_2005 values less than (TO_DATE('2006-01-01 00:00:00', 'YYYY-MM-DD

　　9

　　10 HH24:MI:SS'),TO_DATE('2006-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'))

　　11 tablespace USER_DATA_2005

　　12 ,

　　13 partition PT_XXOLD_2006 values less than (TO_DATE('2007-01-01 00:00:00', 'YYYY-MM-DD

　　14

　　15 HH24:MI:SS'),TO_DATE('2007-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'))

　　16 tablespace USER_DATA_2006

　　17 ,

　　18 partition PT_XXOLD_2007 values less than (TO_DATE('2008-01-01 00:00:00', 'YYYY-MM-DD

　　19

　　20 HH24:MI:SS'),TO_DATE('2008-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'))

　　21 tablespace USER_DATA_2007

　　22 ,

　　23 partition PT_XXOLD_2008 values less than (TO_DATE('2009-01-01 00:00:00', 'YYYY-MM-DD

　　24

　　25 HH24:MI:SS'),TO_DATE('2009-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'))

　　26 tablespace USER_DATA_2008

　　27 ,

　　28 partition PT_XXOLD_2009 values less than (TO_DATE('2010-01-01 00:00:00', 'YYYY-MM-DD

　　29

　　30 HH24:MI:SS'),TO_DATE('2010-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'))

　　31 tablespace USER_DATA_2009

　　32 ,

　　33 partition PT_XXOLD_2010 values less than (MAXVALUE,MAXVALUE)

　　34 tablespace USER_DATA_2010

　　35 )

　　36 AS SELECT * FROM XXOLD WHERE 1=0;

　　CREATE TABLE XXNEW partition by range(COMMANDFINISHTIME,COMMANDLSTTXDATE)

　　(

　　partition PT_XXOLD_2004 values less than (TO_DATE('2005-01-01 00:00:00', 'YYYY-MM-DD

　　HH24:MI:SS'),TO_DATE('2005-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'))

　　tablespace USER_DATA_2004

　　,

　　partition PT_XXOLD_2005 values less than (TO_DATE('2006-01-01 00:00:00', 'YYYY-MM-DD

　　HH24:MI:SS'),TO_DATE('2006-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'))

　　tablespace USER_DATA_2005

　　,

　　partition PT_XXOLD_2006 values less than (TO_DATE('2007-01-01 00:00:00', 'YYYY-MM-DD

　　HH24:MI:SS'),TO_DATE('2007-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'))

　　tablespace USER_DATA_2006

　　,

　　partition PT_XXOLD_2007 values less than (TO_DATE('2008-01-01 00:00:00', 'YYYY-MM-DD

　　HH24:MI:SS'),TO_DATE('2008-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'))

　　tablespace USER_DATA_2007

　　,

　　partition PT_XXOLD_2008 values less than (TO_DATE('2009-01-01 00:00:00', 'YYYY-MM-DD

　　HH24:MI:SS'),TO_DATE('2009-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'))

　　tablespace USER_DATA_2008

　　,

　　partition PT_XXOLD_2009 values less than (TO_DATE('2010-01-01 00:00:00', 'YYYY-MM-DD

　　HH24:MI:SS'),TO_DATE('2010-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'))

　　tablespace USER_DATA_2009

　　,

　　partition PT_XXOLD_2010 values less than (MAXVALUE,MAXVALUE)

　　tablespace USER_DATA_2010

　　)

　　AS SELECT * FROM XXOLD WHERE 1=0

　　SQL> EXEC DBMS_REDEFINITION.START_REDEF_TABLE('CSADMIN', 'XXOLD', 'XXNEW',null,2);

　　PL/SQL procedure successfully completed

　　SQL> select * from user_mview_logs where master='XXOLD';

　　LOG_OWNER MASTER LOG_TABLE LOG_TRIGGER ROWIDS PRIMARY_KEY OBJECT_ID FILTER_COLUMNS SEQUENCE INCLUDE_NEW_VALUES

　　------------------------------ ------------------------------ ------------------------------ ------------------------------ ------ ----------- --------- -------------- -------- ------------------

　　CSADMIN XXOLD MLOG$_XXOLD YES NO NO NO NO NO

　　SQL> desc MLOG$_XXOLD

　　Name Type Nullable Default Comments

　　--------------- ------------- -------- ------- --------

　　M_ROW$$ VARCHAR2(255) Y

　　SNAPTIME$$ DATE Y

　　DMLTYPE$$ VARCHAR2(1) Y

　　OLD_NEW$$ VARCHAR2(1) Y

　　CHANGE_VECTOR$$ RAW(255) Y

　　MLOG$_XXOLD

　　SQL> select count(*) from MLOG$_XXOLD;

　　COUNT(*)