Environment:

Oracle Version: Oracle9i Enterprise Edition Release 9.2.0.7.0

OS: Linux


Hi all,

I need to add a column in table (11 kk rows), see below:

ALTER TABLE NOTAS_FISCAIS ADD (ID_QUEBRA_AGRUP VARCHAR2(50) DEFAULT 'X' NOT NULL);

But this DDL take a long time, how can I do for this DDL to be faster? Is there any option?

Thanks in advance.

Leonardo.