title: Create table as select using dblink doesn't move all the rows
body: <p>We are moving from an amazon ec2 database to an amazon rds database.  Most of the tables are small and could be moved using sql developer copy commands but a couple are bigger (3M+ records).  In order to speed those up, I created database links between the two system.  Those work fine.  I then ran the following:</p>
  
  <pre><code>create table schema.tablename as select * from schema.tablename@ec2db;
  </code></pre>
  
  <p>ec2db is the old database.  The table there contains 3,503,064 records.  However the NEW databse table only contains 3,454,685 records.  No errors were generated during the create table statement.  This is repeatable (ie: I drop the table and run it again, and it loads the same number of records.)</p>
  
  <p>Any ideas why this would happen?  Why would the contents of a table when I do a select (*) not be the same as the contents of the same table (fully specified) when I do a create table?</p>