DBMS_REDEFINITION in 9i to partition table

   Hi all,

   My DB is 9.2.0.4 64 bit.

   Today, I want partition from non-partition  to partition and my table already exists data (about 25 million records) and it has some constraints, FK, PK. I used methods from DBMS_REDEFINITION to do my goal.

   

   But in 9.2.0.4, I can not use COPY_TABLE_DEPENDENTS to clone constraints from source table to new table (this method seem as not exists on 9i ?). I must use the SYNC_INTERIM_TABLE and manual create constraints same as source table on redef table. --> At here, are there some ways that oracle auto creates constraints to me ?

   And if manual create constraints, I must disable FKs on source and redef tables. Should I disable PK on source and redef tables ? And after I finish this job, privileges on partition table still effect (ex, other users that has privileges SELECT on it) ? And in 9i, I must sure that no sessions operate on this table ?