#! /bin/ksh
#
#  dumpSql [startID [endID]]
#    default is startID =1, endID=999999999

#export CSN_DBUSER=nrappapo
#export CSN_DBPASS=nrappapo
#export CSN_DBSERVICE=csn31_tordev01
DB_CONNECT=$CSN_DBUSER/$CSN_DBPASS@$CSN_DBSERVICE


echo "Installing helper package ..."
sqlplus -S $DB_CONNECT @dmpHelper.sql

cmdFile=cmd_$$.sql
echo "Dumping to files core.sql/domain.sql/local_auth_context.sql.tmpl  ..."
cat <<EOF  >$cmdFile
	 set linesize 10000;
	 set serveroutput on format word_wrapped;
	 set feedback off;
	 set trimspool on;
	 set termout off;

	 spool core.sql replace;
	 execute dmp_pkg.dumpCore(${1:-1}, ${2:-999999999});

	 spool domain.sql replace;
	 execute dmp_pkg.dumpDomainInfo(${1:-1}, ${2:-999999999});

	 spool local_auth_context.sql.tmpl replace;
	 execute dmp_pkg.dumpLocalAuthContext(${1:-1}, ${2:-999999999});

	 spool off;

	 exit;
EOF

sqlplus -S $DB_CONNECT @$cmdFile

rm -f $cmdFile

exit 

