I am trying to update a small table from a remote table with sqlplus 9.2.0.2 .
It seems to indicate that it has inserted 233 row into my local table - however that doesn't really happen.
Am I suffering from a severe lack of caffine or is this really odd?
 
SQL> select count(*) from facility;
 
  COUNT(*)
----------
         0
 
SQL> insert into facility (select * from facility@dev);
 
233 rows created.
 
SQL> select count(*) from facility;
 
  COUNT(*)
----------
         0
 
SQL> commit;
 
Commit complete.
 
SQL> select count(*) from facility;
 
  COUNT(*)
----------
         0

Reply via email to