Post reply

Alter table commad taking more time to update table structure.

  • April 29, 2009 at 6:37 am

    #208759

    Hi,

    We are trying to add one column with some default value in a table, which contains 25 crores rows of data. The query (Alter table command)is running from the last 1.5 hrs and sill not executed. We tried to kill the process also but not succeeded.

    Anyone having any idea..

    thanks in advance.

  • April 29, 2009 at 12:57 pm

    #986210

    ruchi (4/29/2009)

    Hi,

    We are trying to add one column with some default value in a table, which contains 25 crores rows of data. The query (Alter table command)is running from the last 1.5 hrs and sill not executed. We tried to kill the process also but not succeeded.

    Anyone having any idea..

    thanks in advance.

    IDEA: "wait".

    You have apparently a very large table. (I have no Idea which of the "crores" you are referring to but either Iranian or Indian is still a large number.)

    Just verify you are not being blocked and wait.


    * Noel

  • May 1, 2009 at 5:57 am

    #987218

    Alter command on large table take time to update. there is no other option

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply