Sitemap

Amicuk Programming Answers

Adding a new Big INT column to existing table in production, which holds 700 million records will impact anything in production?

-0001-11-30   Views:0

Advertisement

Hi Guys, I have to add a new Big INT column to existing table in production, which holds 700 million records and would like to know the impact? I have been tolled by one of my colleagues that last time they tried adding a column to same table during

Hi Guys,
I have to add a new Big INT column to existing table in production, which holds 700 million records and would like to know the impact?
I have been tolled by one of my colleagues that last time they tried adding a column to same table during working hour and it locked out the table and impacted the users.
Please suggest/share If any one had similar experience.
Thanks Shiven:) If Answer is Helpful, Please Vote

The replay answer
Advertisement
If you add a new column to a table using an ALTER TABLE ADD command and specify that the new column allows NULLs and you do not define a default value, then it will take a table lock.  However, once it gets the table lock, it will essentially run instantly
and then free the table lock.  That will add this new column as the last column in the table, for example
ALTER MyTable ADD MyNewColumn bigint NULL;
But if you your change adds a new column with a default value, or you do something like using table designer to add the new column in the middle of the current list of columns, then SQL will have to rewrite the table.  So it will get a table lock, rewrite
the whole table and then free the table lock.  That will take a considerable amount of time and the table lock will be held for that whole period of time.
But, no matter how you make the change, if at all possible, I would not alter a table schema on a production database during working hours.  Do it when nothing else is going on.
Tom

Go to See the other 3 answers

Adding a new Big INT column to existing table in production, which holds 700 million records will impact anything in production?

Category:DefaultRelease time:-0001-11-30Views:130

Hi Guys, I have to add a new Big INT column to existing table in production, which holds 700 million records and would like to know the impact? I have been tolled by one of my colleagues that last time they tried adding a column to same table during[More]

Best approach to publish new table or new column on existing table on MDW?

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I'm refering to Olite R3 without any patches. I don't use Java API, I use MDW. if I have a new table or a new column on a existing table, what's the best approach to publish it? I'm asking this because I've trying lots of approaches and the only[More]

How to add columns for existing table dynamically?

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I created table structure only. I want to add columns for this existing  table. Columns are not fixed, according to the  user choice i  need to write code. Plz give me reply asap. Thanks ShirishaHi Shirisha, I think the following code snippet wil[More]

Add additional column in existing table

Category:DefaultRelease time:-0001-11-30Views:130

Hello guys, I need to add new columns to the existing table, but when I'm trying to add, nothing happens. Checked table itself and all Rows and Column fields are read-only. Can't see any property which indicates this locking behavior. I'm using ES2 L[More]

Importing extra columns in physical tables

Category:DefaultRelease time:-0001-11-30Views:130

hi gems... am new in OBIEE(10.1.3.4.1)...till today i worked on the repository which is already been built by someone. meanwhile the product has been upgraded and thats why there are lots of tables and lots of columns in existing tables have been add[More]

Newbie Repository question: How to add extra columns to relationship table?

Category:DefaultRelease time:2015-10-11Views:130

I've defined the following item-descriptors: <item-descriptor name="award" display-property="id"> <table name="bc_award" type="primary" id-column-name="award_id> </table> </item-descriptor&[More]

Want to update a column with  different column of same table

Category:DefaultRelease time:2015-10-11Views:130

I have a table TEST_CDR which is having 250 millions records also having partition by hash. there are two column in this table ID and CDR_ID want to update ID in CDR_ID but it take too much time like 24 hours or more. please suggest me a simple way.H[More]

Adding column  to existed index syntax or example

Category:DefaultRelease time:-0001-11-30Views:130

Hi, can any one please tell me the syntax or example for adding one more column to existed index. Thanks in Advance KrishnaHello Mr Murali, I do not believe you can alter index by adding more columns to it with ALTER command. But you can always CREAT[More]

Adding column to existing form

Category:DefaultRelease time:2015-10-11Views:130

Hi: Need some guidance on how to accomplish it. I created a form using blank page -> form -> form using a base table. I picked all the required columns from the list and created a nice form. How do I go about adding new columns and removing other co[More]

Adding a column into existing index

Category:DefaultRelease time:-0001-11-30Views:130

Can I add a column into existing index? or do I need to drop the index and recreate one? Thanks.but there is no way to add a column to an existing table10:43:24 TEST.SQL>create table test10:43:28 2 ( 10:43:29 3 a number 10:43:32 4 ) 10:43:34 5 tables[More]

Found errors in existing report after added a column in an existing table

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I have a Table called "EMP" and a interactive report "EMP_Details". EMP table has data and it shows in the report. EMP_Details report has two buttons. - 1.Create - it is used while inserting a new record into the table for a new jo[More]

Hot
I tries using itunes to sync the music again but it failed to transferred any songs over to the iphone.  When I click on the MUSIC icon in the iphone, it shows NO CONTENT.Have you followed http://support.apple.com/kb/TS1559 ? Also try settings>genera [More]
I need to transfer all my photos and videos from my old PC stored in the SONY PMB program to my new fabulous MAC desktop. I do not know how I can do this. Plus for future photos/videos, how can I upload them from Sony products ? Please help me PS I j [More]
Hi there, I'm trying to define development standards for the use of XI and I can't seem to find any recommendation for the storage of SAP interface definitions (IDOCs, RFCs, etc)within the Integration Directory. We have an environment with multiple S [More]
Two-part question/issue . . . Part 1: In InfoPath 2013 in use with SharePoint 2013, how do you set a Default Value for Person/Group Picker fields? Other field types like Text Boxes have a Default Value section in the Data tab of Properties.  There do [More]
Acrobat Reader cannot search some .pdf files.  I have put an example document up on Scribd here. Any attempt to search for any word that can be clearly seen to be in the document fails with "No matches were found." This example document is NOT a [More]
In my current environemnt Production database has one physical standby database. The size of the database is 5 TB. Due the network failure 4 days archivelog files were not copied to primary database (archivelog files were deleted in primary database) [More]
Hello XI Experts, I have an asynchronous scenario  file to proxy. For every transaction to proxy from File, I am calling an outbound proxy to send a response back to sender (which has the content success or error with details) which is file again. Fo [More]
How can I script authentication to make changes to the Finder? My script is as follows: tell application "Finder" copy file "Photo [OSX]:Library:Receipts:iTunes4.pkg:" to desktop copy file "Photo [OSX]:Library:Receipts:iTunes.pkg: [More]
My mac book is still running on the OSX 10.5.8, but I've been having problems with safari shutting down when I watch t.v or movies. What should I update to next?Snow Leopard/10.6.x Requirements... General requirements    * Mac computer with an Intel [More]
Hi All, I am currently using Hyperion planning 11.1.2.2, after a successful application creation, data load via EAS, Reports/Forms are working perfectly in smartview. Now I would like to go beyond Adhoc Analysis, I would like to know if it is possibl [More]