71 votes
ALTER TABLE on live dataset, no exclusive required
I'd like to be able to do an alter table on a live data set. No exclusive access for ALTER TABLE.
I'd like to be able to do an alter table on a live data set. No exclusive access for ALTER TABLE.
Florisoft
1. Isn't there a way to do is with the help of online backup. First you do an online backup of the table, then that table is being altered, than the new records are copied also and then everything is copied back.
2. Multiple record sizes in one table. So that you can alter a table only for the new records. The old records automatically returns the default value for a new field.