title: Error importing oracle dump
body: <p>I am trying to import a dump into two schema in the same oracle DB.Following a workaround to do this. </p>
  
  <p>I am trying to run the imp command with the INDEXFILE option to be able to modify the tablespace names in the sql. This is what I get :</p>
  
  <blockquote>
    <p>E:\oracle_10_2\BIN>imp atlantis/atlantis@orcl file=ABCD1_EXCLUDE_CLOB_TABS_BAK.dmp indexfile=index.sql  full=y log=imp.log</p>
    
    <p>Import: Release 10.2.0.1.0 - Production on Thu Mar 12 15:31:44 2009</p>
    
    <p>Copyright (c) 1982, 2005, Oracle.  All rights reserved.</p>
    
    <p>Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Produc
    tion
    With the Partitioning, OLAP and Data Mining options</p>
    
    <p>IMP-00002: failed to open ABCD1_EXCLUDE_CLOB_TABS_BAK.dmp for read
    Import file: EXPDAT.DMP ></p>
  </blockquote>
  
  <p>Looked like a file permission issue to me so I tried changing it.</p>
  
  <blockquote>
    <p>E:\oracle_10_2\BIN>cacls E:\ABCD1_EXCLUDE_CLOB_TABS_BAK.dmp /p atlantis:F</p>
    
    <p>Are you sure (Y/N)?y</p>
    
    <p>processed file: E:\ABCD1_EXCLUDE_CLOB_TABS_BAK.dmp</p>
    
    <p>E:\oracle_10_2\BIN>cacls E:\ABCD1_EXCLUDE_CLOB_TABS_BAK.dmp</p>
    
    <p>E:\ABCD1_EXCLUDE_CLOB_TABS_BAK.dmp CORP\atlantis:F</p>
  </blockquote>
  
  <p>But the problem persists.</p>