-
DDL take a long time (ADD COLUMN)
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|