Last Stop For Oracle Applications Tablespace Migration

December 8, 2014 | 1 minute read
Steven Chan
Senior Director
Text Size 100%:

The Oracle Applications Tablespace Model (OATM) -- sometimes also called the Oracle E-Business Suite Tablespace Model) -- organizes the EBS database by object type rather than by products.  Prior to OATM, the EBS database had two tablespaces for each product, resulting in hundreds of tablespaces.  OATM contains only twelve locally-managed tablespaces.  This simplifies management and requires fewer operating system files.

Whether you're already using the Oracle Applications Tablespace Model depends on which version of the E-Business Suite you initially installed. If you started on an older EBS release, you have the option of migrating to the Oracle Applications Tablespace Model.

Is OATM mandatory?

No, it's optional, but we recommend that you use OATM.  It's more-efficient and easier to manage.  You can use the OATM Tablespace Migration Utility to migrate to the new model.

Can I use OATM with EBS 12.2?

The OATM Tablespace Migration Utility cannot be used after you enable Online Patching in EBS 12.2.  If you wish to migrate to OATM, you must do so before you enable Online Patching.

If you do not migrate to OATM, you must continue to manage your tablespaces separately after enabling Online Patching.




Steven Chan

Senior Director

Steven Chan was a Senior Director in the Oracle Applications Technology Group.  He managed EBS technology stack certifications, ATG product management, ATG documentation and curriculum, and ATG Quality Assurance in the E-Business Suite Development division.

Steven joined Oracle in 1998.  Steven retired from Oracle in 2019. Prior to joining Oracle, he held positions with IBM, Deloitte & Touche Consulting, and other software companies. 

Steven is an Oracle ACE and a three-time recipient of the Oracle Applications User Group 'Ambassador of the Year' Award (2007, 2009, 2010). Steven received the Oracle Applications User Group Lifetime Service Award in 2011.

Previous Post

Oracle Functional Testing Suite Advanced Pack for EBS 12.2.4 Now Available

Steven Chan | 3 min read

Next Post

Database 12c Certified With 12.1 On Oracle Solaris on x86-64

John Abraham | 1 min read