Help for this page

Select Code to Download


  1. or download this
    #!/bin/perl
    
    ...
    $SID=${ORACLE_SID};
    
    @TSPACES=`$sqlplus -s -l $USERNAME/$PASS@$SID  \@/opt/bin/ops/mlb_tabl
    +espace.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_table
    +space.sql | awk '{print $4}'`;
    
  2. or download this
    [db07-dc2:~] root% Error 6 initializing SQL*Plus
    Message file sp1<lang>.msb not found
    SP2-0750: You may need to set ORACLE_HOME to your Oracle software dire
    +ctory