Re: SQLplus question unusual behavior

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" <ORACLE-L_at_fatcity.com> 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:arupnanda_at_hotmail.com]
> > 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" <John.Shaw_at_correctionscorp.com>
> > >Reply-To: ORACLE-L_at_fatcity.com
> > >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > >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_at_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: <F001.00534A0E.20030120073045_at_fatcity.com>
> > >X-Comment: Oracle RDBMS Community Forum
> > >X-Sender: "John Shaw" <John.Shaw_at_correctionscorp.com>
> > >Sender: root_at_fatcity.com
> > >Errors-To: ML-ERRORS_at_fatcity.com
> > >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: root_at_fatcity.cts.com
> > >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_at_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: arupnanda_at_hotmail.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_at_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).
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Sony kristanto
> INET: Sony_at_polyfincanggih.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_at_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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Arup Nanda
  INET: arupnanda_at_hotmail.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_at_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).