Ora Training Blog

SQL*Loader SQL*Loader is a high-speed data loading utility that loads data from external files into tables in an Oracle database. SQL*Loader accepts input data in a variety of formats, can perform filtering, and can load data into multiple Oracle database tables during the same load session. SQL*Loader is an integral feature of Oracle databases and […]

Click here to download cmclean.sql REM REM FILENAME REM   cmclean.sql REM DESCRIPTION REM   Clean out the concurrent manager tables REM NOTES REM   Usage: sqlplus <apps_user/apps_passwd> @cmclean REM REM REM   $Id: cmclean.sql,v 1.4 2001/04/07 15:55:07 pferguso Exp $ REM REM REM +==============================+ set verify off; set head off; set timing off set pagesize 1000 column manager format […]

We can submit concurrent programs from OS command / shell prompt using CONCSUB utility. Following is the syntax of the same: CONCSUB <APPS username>/<APPS password> <responsibility application short name> <responsibility name> <username> [WAIT=N|Y|<n seconds>] CONCURRENT <program application short name> <program name> [PROGRAM_NAME=”<description>”] [REPEAT_TIME=<resubmission time>] [REPEAT_INTERVAL= <number>] [REPEAT_INTERVAL_UNIT=< resubmission unit>] [REPEAT_INTERVAL_TYPE=< resubmission type>] [REPEAT_END=<resubmission end date and […]