SQL Language (MOSC)

MOSC Banner

set unused column/drop column - 10.2.0.2

edited Feb 18, 2010 4:00AM in SQL Language (MOSC) 9 commentsAnswered
 Altered tables with M_ROW$$ columns to UNUSED. Drop of column on 120M+ row table taking a while - started around 3pm Monday 12/1/08 and still going at this time 8:25am 12/2/08.

Found this info on Metalink but unable to find the note/doc being referred to.

According to <Note:132658.1>, executing the DROP COLUMN SET UNUSED command will technically lock the table for an instant to make this change. However, no DML may be active against the table when the command is executed. Because this operation runs very quickly, the impact to end-users is likely to be very small. Dropping the column without the SET UNUSED clause, or performing the DROP UNUSED operation, may lock the table for an extended period of time during which every row in the table is updated to remove the column.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center