There are some table modifications that can't be done using an ALTER (eg changing a datatype), and have to be done using a table rebuild. From what I know, there are two ways of doing it:
- creating a new table, doing INSERT INTO <newtable> SELECT <conversion functions> FROM <oldtable>, DROP <oldtable>, then RENAME <newtable> TO <oldtable>
- Using DBMS_REDEFINITION
are there any other methods, and which method should I use?