APPS DBA

How To Move Table to Different TableSpace   SYNTAX ALTER TABLE table_name move TABLESPACE tablespace_name (INITIAL=64k MINEXTENTS=1 MAXEXTENTS=UNLIMITED);   EXAMPLE ALTER TABLE hr.employee_details move TABLESPACE hr; OR ALTER TABLE hr.employee_details move TABLESPACE hr (INITIAL=64k MINEXTENTS=1 MAXEXTENTS=UNLIMITED);  

How To Trace Concurrent Programs CASE 1 : Concurrent Program Tracing without bind variables 1)   Follow the following navigation to enable logging for Concurrent Program Goto Sysadmin > Concurrent > …

Fixing a “Failed” worker  Whenever  a job fails for the 1st time, the job is deferred at the end of the phase and another job is assigned to that worker. …

RapidWiz log files for Oracle Applications Release 12   During installation of Release 12 using RapidWiz, the following log files are created. In case of any errors during the installation, …

Oracle AD Controller ADCTRL is used to manage worker processes that perform a pivotal role in the function of batch processing for patching and many other Applications activities. ADCTRL is …

List of All active Transactions

ERROR

To check Retention Guarantee for Undo Tablespace

ERROR Checking for existence of the ACL …. DECLARE * ERROR at line 1: