title: Backup and Restore: Problem during Importing Oracle 11g
body: <p>I took a logical backup of a database as the SYS user and restored it to a database on other machine as the System user.  </p>
  
  <p>On the destination server, the structure of a few tables wasn't the same as on the source server.  There were a few extra columns in a few tables in the source database.  When I tried to import the dump file into the destination database, it didn't import correctly.  The table structure was still the old one and there was no data/old data in any of those tables.  When I deleted those tables and tried importing the same dump file again, it imported successfully-- the new table structure along with the new data was present.  </p>
  
  <p>I can't figure out  where was I wrong (since im new to it).  Do I always need to delete the tables which are altered and import the database?  Or is there a way to overwrite the old structure of the table with the new structure?</p>
  
  <p>I'm using Oracle 11g.</p>
  
  <p>This was the export command I used to take backup</p>
  
  <pre><code>exp lsone/lsone file=newbkp.dmp log=newlog.log owner=lsone
  </code></pre>
  
  <p>This command was the one to import the dump file</p>
  
  <pre><code>imp system/manager file=newbkp.dmp log=import.log fromuser=lsone touser=dev
  </code></pre>
  
  <p>Would appreciate your reply!! </p>