INEED TO PERFORM THESE BELLOW POINTS IN UNIX SHELL SCRIPT.
INEED TO CALL THE PROCEDURE dbadmin.truncate_table.
INEED TO CHECK THE COUNT BEFORE AND AFTER THE PROCEDURE EXECUTION(THIS SHOULD BE HANDELED IN UNIX SCRIPT)
1) invoke batch profile to run sqlplus on XXXXX server.
2) execute truncate table xtra.xtra_card_email_request using procedure dbadmin.truncate_table .
the procedure is already done and stored.
We used to run the following steps earlier:
Please see the steps executed on Aug email solicitation.
**********************************************************************
calling the environiment manually which consists of following steps
**********************************************************************
$ . /usr/local/etc/profile.rmbatch.evr
Sourcing profile.rmbatch.evr
Sourcing ~xipcadm/netcomm/etc/xipc.env
XXXXXXX
sid=YYYYY
pwd=/home/offhours/crmdboh
(XXXXXserver) userid> sqlplus USERID/PASSWORD(need to invoke the sqlplus on the unix server)
SQL*Plus: Release 10.1.0.5.0 - Production on Fri Aug 1 05:49:28 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - 64bit Production
With the Partitioning and Data Mining options
SQL> set timing on
SQL> set serveroutput on
SQL> set time on
NEED TO CHECK THE COUNT OF RECORDS PRESENT BEFORE PROCEDURE RAN
***********************************************************
05:51:18 SQL> select count() from XTRA.XTRA_CARD_EMAIL_REQUEST;
COUNT()
----------
1571730
Elapsed: 00:00:03.75
*******************************************************************
SUCESSFULL RUN OF THE PROCEDURE
*******************************************************************
06:00:03 SQL> exec dbadmin.truncate_table('XTRA','XTRA_CARD_EMAIL_REQUEST');
-- TRUNCATING Table
truncate table XTRA.XTRA_CARD_EMAIL_REQUEST;
PL/SQL procedure successfully completed.
Elapsed: 00:00:00.11
***************************************************************
cHECKING THE RECORDS COUNT AFTER RUNNING THE PROCEDURE
****************************************************************
06:00:07 SQL> select count() from XTRA.XTRA_CARD_EMAIL_REQUEST;
COUNT()
----------
7
Elapsed: 00:00:00.00