Re: Alter table (with large no. of data)

Sujit.Pal@alltel.com wrote: > You would need to increase the number of logical logs. The reason is > that DDL statements such as ALTER are always logged regardless of > whether your database is logged or not. Yes, that's true, but the ALTER statement by itself is not what's filling up the logical logs; it's all the individual INSERT statements that result from the ALTER, as the engine copies all the rows from the original table to the new table. These would not be logged if the database had logging turned off. June -- june_t@hotmail.com Lost in the wilds of Palo Alto, living on KitKat bars