Migration

[dbasubramanian]

hI

Anyone can help me to migrate composite range-hash partition to caomposite range-list partition online?

Thanks

Subramanian

[kgb]

1) create a new table
2) copy data to a new table using sqlplus "copy" command
3) create all indexes on a new table, give all grants, create triggers on that table
4) rename old table
5) rename a new table to the one you need.