title: How can I create a table as a select from another database in Oracle?
body: <p>Is it possible to create a table (in my dev db) using a SELECT from a different database?</p>
  
  <p>I want something like:</p>
  
  <pre><code>create tmp_table as select * from prod_db.prod_schema.table
  </code></pre>
  
  <p>Is there syntax to do this, or do I need to create a database link first?</p>