Recreate table without losing data, triggers and FK

[czn]

It would be nice if we could restructure tables without losing data.
Of course this is not an one shot Oracle command, but you could generate a script instead, something like rename table, create a new table having the new structure, copy old data etc.
This is what we manually do now in order to modify the structure of a table.

 

[Marco Kalter]

I have added this to the list of enhancement requests.

 

[ai]

It seems to stayed on a list.