Author Topic: Add Columns to big Oracle table  (Read 4053 times)

sam

  • Newbie
  • *
  • Posts: 1
    • View Profile
Add Columns to big Oracle table
« on: June 02, 2009, 08:20:00 PM »
Hi All,
   I am adding 6 null columns to big oracle table with about 60 million records and it is taking forever to complete.  Any suggestions?  Thanks…Sam 


Mike

  • Administrator
  • Hero Member
  • *****
  • Posts: 2025
    • View Profile
Re: Add Columns to big Oracle table
« Reply #1 on: June 02, 2009, 08:32:46 PM »
That's a lot of rows to add columns to. Frankly I'd be surprised if it didn't take a while.   :)

Maybe someone here can suggest some tips to speed it up, but I think what you're seeing may be normal.


Hi All,
   I am adding 6 null columns to big oracle table with about 60 million records and it is taking forever to complete.  Any suggestions?  Thanks…Sam