You can create only few rows or as per your need by this comand. create table x as select * from x@dblink where rownum<=100;
enjoy!