title: SP2-0310: unable to open file "explannew/rdbms/admin/utlxpls.sql"
body: <p>I am trying to run an explain plan in the sqlplus environment but i am getting the error SP2-0310: unable to open file "explannew/rdbms/admin/utlxpls.sql".</p>
  
  <p>(<em>I replaced the actual figures with the zeros below</em>)</p>
  
  <p>Please help explain what i am getting wrong. A typical example of the explain plan is below;</p>
  
  <pre><code>set lines 130
  set head off
  
  spool explan1.txt
  
  explain plan for
    select
      entity_cre_flg, TO_CHAR(product), TO_CHAR(product_for_int_rate),
      TO_CHAR(diff_product), TO_CHAR(start_date, 'DD-MM-YYYY HH24:MI:SS'), 
      TO_CHAR(wtax_pcnt), TO_CHAR(wtax_floor_limit),
      TO_CHAR(last_comp_tax), TO_CHAR(tax_amount), wtax_for_cr_comp, rowid
  FROM
    TBAADM.TBA_INTEREST_DETAILS_TABLE
  WHERE
    entity_id = '000000' AND entity_type = 'ACCNT' AND interest_ind = 'C'
    AND interest_type = 'N' AND serial_num = '0000' AND bank_id = '0000' ;
  
  @?/rdbms/admin/utlxpls
  
  spool off
  </code></pre>