I am using Oracle 11.1.0.7 on HP UNIX 11i. I am running alter table split partition ... command but it makes indexes unusable and then I have to make then usable by rebuiding them. But during the time indexes are unusable, can users still access the table, i.e., will queries on the table will error or just very slow.
Is there a way to do all of this on line witthout impacting users. May be it can be done using dbms_redefinition package, but I am looking for an easier
solution.