Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA-00903

Re: ORA-00903

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 01 Aug 2007 08:24:34 -0700
Message-ID: <1185981872.781413@bubbleator.drizzle.com>


Sashi wrote:
> All, I must be missing the woods 'coz of the trees but here goes:
> =============================================================
> SQL> desc NED_PRODUCT_CARD;
> Name Null? Type
> ----------------------------------------- --------
> ----------------------------
> PRODUCT_CARD_KEY NOT NULL NUMBER(10)
> DATA_SOURCE_NAME VARCHAR2(120)
> PL_CGIS VARCHAR2(100)
> REMS_CODE NOT NULL VARCHAR2(10)
> BUILDING_CODE VARCHAR2(10)
> FLOOR VARCHAR2(100)
> SECTOR VARCHAR2(100)
> SITE_ID VARCHAR2(20)
> TOTAL_RSF NUMBER
> RECORD_CREATED_DATE DATE
> RECORD_UPDATED_DATE DATE
>
> SQL> delete * from NED_PRODUCT_CARD
> 2 where PL_CGIS in (
> 3 "UUS607CRS",
> "UUSBLANKUND",
> "UUSBLANKVAC-CO",
> "UUSBLANKVAC-EX",
> "UUSPriamerica",
> "USSBCRS");
> 4 5 6 7 8 delete * from NED_PRODUCT_CARD
> *
> ERROR at line 1:
> ORA-00903: invalid table name
> =============================================================
> As can be seen, I have the NED_PRODUCT_CARD table defined and all.
> When I try to delete certain rows, the error says that the table
> doesn't exist.
>
> What gives??!!
>
> Thanks,
> Sashi

SELECT owner, table_name
FROM all_tables
WHERE UPPER(table_name) = 'NED_PRODUCT_CARD';

Who owns the table?
Is the table name returned in upper case?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Wed Aug 01 2007 - 10:24:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US