RE: SQLplus question unusual behavior

[John Shaw]

although I am using fgac - I am exempt from the policy.

>>> [EMAIL PROTECTED] 01/21/03 02:49AM >>>

Possibly a FGAC policy with the UPDATE_CHECK flag set to FALSE. This would allow the current user to insert rows, but not necessarily view them. Are you connected to SQL*Plus as the table owner or a subordinate user?

 

Check in the USER / DBA_POLICIES view where the OBJECT_NAME='FACILITY'

-----Original Message-----
From: John Shaw [mailto:[EMAIL PROTECTED]]
Sent: 20 January 2003 15:31
To: Multiple recipients of list ORACLE-L
Subject: SQLplus question unusual behavior

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



--
This correspondence is confidential and is solely for the intended recipient(s). If you are not the intended recipient, you must not use, disclose, copy, distribute or retain this message or any part of it. If you are not the intended recipient please delete this correspondence from your system and notify the sender immediately.

No warranty is given that this correspondence is free from any virus. In keeping with good computer practice, you should ensure that it is actually virus free. E-mail messages may be subject to delays, non-delivery and unauthorised alterations therefore, information expressed in this message is not given or endorsed by Sx3 unless otherwise notified by our duly authorised representative independent of this message.

Sx3 is a trading name of Service and Systems Solutions Limited, a limited company registered in Northern Ireland under number NI 32979 whose registered office is at 120, Malone Road, Belfast, BT9 5HT.