#!/bin/perl

# credentials / environment variables
$ORACLE_HOME="/u01/app/oracle/product/10.2.0.4";
$ORACLE_SID=qaecom1;
$sqlplus="/u01/app/oracle/product/10.2.0.4/bin/sqlplus";
$USERNAME=dbuser;
$PASS=pass;
$SID=${ORACLE_SID};

@TSPACES=`$sqlplus -s -l $USERNAME/$PASS@$SID  \@/opt/bin/ops/mlb_tablespace.sql | awk '{print $1}'   $sqlplus -s -l $USERNAME/$PASS@$SID  \@/opt/bin/ops/mlb_tablespace.sql | awk '{print $3}'  $sqlplus -s -l $USERNAME/$PASS@$SID  \@/opt/bin/ops/mlb_tablespace.sql | awk '{print $2}'   $sqlplus -s -l $USERNAME/$PASS@$SID  \@/opt/bin/ops/mlb_tablespace.sql | awk '{print $4}'`;