Schema changes on on large tables
From: PR <priisberg_at_netscape.net>
Date: 14 Sep 2004 00:03:41 -0700
Message-ID: <d95b480f.0409132303.291b66f9_at_posting.google.com>
Hi,
I have a basic question on schema changes performed on populated tables. Should I prepare for big roll back area and so on for both of these changes: ALTER TABLE ADD COLUMN
ALTER TABLE ALTER COLUMN
Table contain abt. 40 mill records
Date: 14 Sep 2004 00:03:41 -0700
Message-ID: <d95b480f.0409132303.291b66f9_at_posting.google.com>
Hi,
I have a basic question on schema changes performed on populated tables. Should I prepare for big roll back area and so on for both of these changes: ALTER TABLE ADD COLUMN
ALTER TABLE ALTER COLUMN
Table contain abt. 40 mill records
Appriciate the help, as i am just DBA stand in in my project:-) Received on Tue Sep 14 2004 - 09:03:41 CEST