title: Oracle SQL: Transferring tables from one user to another
body: <p>I created a new user called temp, with a password <strong>temp</strong>. I have another user called <strong>Scott</strong> that is identified by <strong>tiger</strong>. There are three tables in that profile that I'd like to copy onto <strong>temp</strong>. So i logged on to <strong>temp</strong> and punched in this (for the first table called <strong>iowe</strong>)</p>
  
  <pre>copy from  iowe@scott - create iowe - using select * from iowe; </pre>
  
  <p>Right after this when I hit <strong>Enter</strong>, it asked me the FROM password. I input <strong>tiger</strong>, and it threw an error. This is how it looks like:</p>
  
  <p><img src="https://i.stack.imgur.com/fgf8F.jpg" alt="enter image description here"></p>
  
  <p>So please tell me if there is a way to copy tables from one user to the other (I am sure there is)</p>
  
  <p>Your help is greatly appreciated.</p>