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
----------
0
SQL> insert into facility (select * from facility@dev);
233 rows created.
SQL> select count(*) from facility;
COUNT(*)
----------
0
----------
0
SQL> commit;
Commit complete.
SQL> select count(*) from facility;
COUNT(*)
----------
0
----------
0