Compile Apps Schema Using Adadmin

You can also forcefully exit adadmin at any point of time by typing abort This. To get a listing of invalid objects- Select count from dba_objects where statusINVALID. This option compiles invalid objects in the APPS schema. Compiling all application flexfields. You can use multiple workers for parallel processing.

CompileReload Applications Database Entities. Oracle E-Business Suite Technology Stack - Version 1206 to 1213 Release 120 to 121 Information in this document applies to any platform. This is accomplished by creating a defaults fileThe defaults file must be place at the location APPL_TOPadmin sid. You can create the defaults file with the following syntax. Start the adadmin-Utility from the Unix prompt with this command.

From Database Tier a Login as database tier user ovisr12 in my case b Set environment variable under INSTALL_DIRdbtech_st1020 or 1110sid_hostnameenv c cd ORACLE_HOMErdbmsadmin d sqlplus as sysdba e SQL utlrpsql. Adadmin can also be run in a non interactive mode. Compile menu information 3. July 8 2013 Farhat Zaman EBSR12. To get a listing of invalid objects- Select count from dba_objects where statusINVALID.

Invalid objects in other schema as sys and system are not necessarily compiled. 1 Start adadmin utility. Adadmin can also be run in a non interactive mode. Start Database. Select the menus 1.

Related Post Compile Apps Schema Using Adadmin

Compile Apps Schema Using Adadmin Compile Apps Schema Using Adadmin