scripts/LJCOPY/ts.ksh

#!/bin/ksh
function get_db_size
{
res=`sqlplus -s expman/expdp@${ORACLE_SID} <<-EOF
        SET ECHO OFF NEWP 0 SPA 0 PAGES 0 FEED OFF HEAD OFF TRIMS ON TAB OFF
        column bytes format 9999999999999
        select sum(bytes) bytes from dba_extents;
        exit
EOF`
echo ${res}
}


# ---------------

if [ `get_db_size` -gt 10000000000 ]
then
   echo "Greater than......"
   # SIZE_FLAG="exclude=SCHEMA:\"in ('MDMADM','CCBADM')\""
else
   echo "Less than...."
fi