This discussion is archived
1 Reply Latest reply: Nov 8, 2012 4:19 PM by Walashkar RSS

Obsolete Columns- Upgrade

Walashkar Newbie
Currently Being Moderated
Hai all,

In 12.1, upgrade guide, the below is shown on page 1-14

Obsolete Columns
During the upgrade process, the Oracle RDBMS DROP COLUMN command marks
Oracle E-Business Suite columns as unused in the data dictionary, making it possible
for the database administrator to drop the columns and reclaim the associated space. It
Planning for an Upgrade 1-15
is a good idea to plan this reclamation ahead of time because the process locks the
associated tables. Once the space is reclaimed, the upgraded data model looks more like
a fresh install (except for customizations). Note that DROP COLUMN has no effect on
custom columns.

How to plan for this reclamation ?. what is exactly being meant here ?
  • 1. Re: Obsolete Columns- Upgrade
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    In 12.1, upgrade guide, the below is shown on page 1-14

    Obsolete Columns
    During the upgrade process, the Oracle RDBMS DROP COLUMN command marks
    Oracle E-Business Suite columns as unused in the data dictionary, making it possible
    for the database administrator to drop the columns and reclaim the associated space. It
    Planning for an Upgrade 1-15
    is a good idea to plan this reclamation ahead of time because the process locks the
    associated tables. Once the space is reclaimed, the upgraded data model looks more like
    a fresh install (except for customizations). Note that DROP COLUMN has no effect on
    custom columns.

    How to plan for this reclamation ?. what is exactly being meant here ?
    Please see Page 4-29 Step 2: Drop obsolete columns (recommended) for details – In the same upgrade doc for details.

    Thanks,
    Hussein

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points