How to call unix shell script from plsql schedule job
Hi,
Can someone help me to find easy of calling unix shell script from PLSQL.
Here is the scenario:
ORACLE DATABASE VERSION : 11.1.0.7
OPERATING SYSTEM: RED HAT LINUX 64 BIT
I have plsql scheduled job which export the schema using plsql script. This jobs works fine and backup is being written on the required location.
my_plsql_backup_script:
==================
DECLARE
h1 NUMBER;
BEGIN
h1 :=
DBMS_DATAPUMP.
open (
operation => 'EXPORT',
job_mode => 'SCHEMA',
job_name => 'BACKUPMYDB'
|| TO_CHAR (SYSDATE, 'dd-mm-yyyyhh24miss'),
version => 'COMPATIBLE');
DBMS_DATAPUMP.set_parallel (handle => h1, degree => 1);
DBMS_DATAPUMP.
add_file (
handle => h1,
filename => 'MYDBExport'
|| TO_CHAR (SYSDATE, 'dd-mm-yyyyhh24miss')
Can someone help me to find easy of calling unix shell script from PLSQL.
Here is the scenario:
ORACLE DATABASE VERSION : 11.1.0.7
OPERATING SYSTEM: RED HAT LINUX 64 BIT
I have plsql scheduled job which export the schema using plsql script. This jobs works fine and backup is being written on the required location.
my_plsql_backup_script:
==================
DECLARE
h1 NUMBER;
BEGIN
h1 :=
DBMS_DATAPUMP.
open (
operation => 'EXPORT',
job_mode => 'SCHEMA',
job_name => 'BACKUPMYDB'
|| TO_CHAR (SYSDATE, 'dd-mm-yyyyhh24miss'),
version => 'COMPATIBLE');
DBMS_DATAPUMP.set_parallel (handle => h1, degree => 1);
DBMS_DATAPUMP.
add_file (
handle => h1,
filename => 'MYDBExport'
|| TO_CHAR (SYSDATE, 'dd-mm-yyyyhh24miss')
0