Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps

Thursday, October 23, 2008

Pre-steps during OATM conversion not in metalink

1. Ensure that initialization parameters are set as O7_DICTIONARY_ACCESSIBILITY=TRUE 
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE or SHARED

2. Make sure that the temp tablespace size is bigger than the largest object size to be migrated. In one of our iterations,  the size of the biggest object to be migrated was an index called WF_ITEM_ATTRIBUTE_VALUES_PK of size 9GB.  We made sure that our temp tablespace had more than 9 GB of free space before starting the migration.

No comments: