Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h0KKkMu08407 for ; Mon, 20 Jan 2003 14:46:22 -0600 X-ClientAddr: 209.68.248.164 Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h0KKkLp08399 for ; Mon, 20 Jan 2003 14:46:21 -0600 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id JAA27750; Mon, 20 Jan 2003 09:29:42 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 00534C68; Mon, 20 Jan 2003 09:04:34 -0800 Message-ID: Date: Mon, 20 Jan 2003 09:04:34 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: babu.nagarajan@Cummins.com Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: babu.nagarajan@Cummins.com Subject: Re: SQLplus question unusual behavior Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Just a thought - is facility a table or is it some synonym/view pointing somewhere else.. Babu |---------+-------------------------------> | | John Shaw | | | | | | Sent by: | | | root@fatcity.com | | | | | | | | | 01/20/03 10:30 AM | | | Please respond to | | | ORACLE-L | | | | |---------+-------------------------------> >-----------------------------------------------------------------------------------------------------------| | | | To: Multiple recipients of list ORACLE-L | | cc: | | 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 e-mail transmission and any attachments to it are intended solely for the use of the individual or entity to whom it is addressed and may contain confidential and privileged information. If you are not the intended recipient, your use, forwarding, printing, storing, disseminating, distribution, or copying of this communication is prohibited. If you received this communication in error, please notify the sender immediately by replying to this message and delete it from your computer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: babu.nagarajan@Cummins.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).