Installing RedHat Linux



Read more…

No comments
Apr 27th, 2009 | Posted by Tushar Thakker | Filed under Linux/Unix/Solaris, Oracle, Unix administration

SQL*Loader – complete reference

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 is available in all configurations.

Commands and Parameters

SQL*Loader can be invoked in one of three ways:

sqlldr
sqlldr keyword=value [keyword=value ...]
sqlldr value [value ...]

Valid Keywords/Parameters: Read more…

1 comment
Apr 6th, 2009 | Posted by Tushar Thakker | Filed under Oracle, Oracle Database, Oracle DBA

cmclean.sql script to cleanup concurrent manager tables

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 a20 heading ‘Manager short name’
column pid heading ‘Process id’
column pscode format a12 heading ‘Status code’
column ccode format a12 heading ‘Control code’
column request heading ‘Request ID’
column pcode format a6 heading ‘Phase’
column scode format a6 heading ‘Status’
WHENEVER SQLERROR EXIT ROLLBACK; Read more…

3 comments
Apr 4th, 2009 | Posted by Tushar Thakker | Filed under Concurrent manager, Oracle, Oracle Applications, Oracle Applications DBA