We have a student system software, that we can add fields to extended table.
This is all implemented from UI, meaning you can add columns to those tables from front end user interface.
But recently when we do that, the session often times out.
We think the reason is at background it is doing some like alter table add column..., but since users are using the table. and the table is huge.
It always timed out.
My question is if users are updating or query the table, can alter table add column be done?
Or any other recommendations?
Thanks,