Sony, In my post I mentioned that there could be two tables named "facility" (note the lowercase) and FACILITY. They can be created and then the data dictionary will have two tables. For Oracle they are two different names, not the same.
However, I believe the diagnosis by Harvey Neil, that there could be a FGAC policy on the table is the correct one. John, could you let us know if that was the problem, please. Arup ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, January 20, 2003 10:38 PM > If it is possible, how could two tables have the same name and structure in > one tablespace ? I think you should check your data dictionary or your > program documentation. > Hope this helps. > > Rgrds, > > Sony > > > -----Original Message----- > > From: Arup Nanda [SMTP:[EMAIL PROTECTED]] > > Sent: Tuesday, January 21, 2003 12:19 AM > > To: Multiple recipients of list ORACLE-L > > Subject: Re: SQLplus question unusual behavior > > > > Check if there are two taables named FACILTY in your database. > > > > As SYS, check > > > > SELECT OWNER, Object_name, Object_type > > FROM DBA_OBJECTS > > WHERE UPPER(OBJECT_NAME) = 'FACILITY' > > > > Note the use of upper(). Someone might have defined the table in lowercase > > > > using quotes. > > > > CREATE TABLE FACILITY is not the same as CREATE TABLE "facility". > > > > HTH. > > > > Arup > > > > >From: "John Shaw" <[EMAIL PROTECTED]> > > >Reply-To: [EMAIL PROTECTED] > > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > >Subject: SQLplus question unusual behavior > > >Date: Mon, 20 Jan 2003 07:30:45 -0800 > > >MIME-Version: 1.0 > > >Received: from newsfeed.cts.com ([209.68.248.164]) by > > >mc9-f3.bay6.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Mon, 20 > > Jan > > >2003 08:01:55 -0800 > > >Received: from fatcity.UUCP (uucp@localhost)by newsfeed.cts.com > > >(8.9.3/8.9.3) with UUCP id IAA19511;Mon, 20 Jan 2003 08:01:26 -0800 (PST) > > >Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id > > 00534A0E; > > >Mon, 20 Jan 2003 07:30:45 -0800 > > >Message-ID: <[EMAIL PROTECTED]> > > >X-Comment: Oracle RDBMS Community Forum > > >X-Sender: "John Shaw" <[EMAIL PROTECTED]> > > >Sender: [EMAIL PROTECTED] > > >Errors-To: [EMAIL PROTECTED] > > >Organization: Fat City Network Services, San Diego, California > > >X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman > > >Precedence: bulk > > >Return-Path: [EMAIL PROTECTED] > > >X-OriginalArrivalTime: 20 Jan 2003 16:01:55.0073 (UTC) > > >FILETIME=[40E1BF10:01C2C09D] > > > > > >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 > > > > > > _________________________________________________________________ > > STOP MORE SPAM with the new MSN 8 and get 2 months FREE* > > http://join.msn.com/?page=features/junkmail > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Arup Nanda > > INET: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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). > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Sony kristanto > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
