ORA-904 after table rename

From: Norris, Gregory T [ITS] <gregory.t.norris_at_mail.sprint.com>
Date: Fri, 16 Jan 2004 07:09:38 -0800
Message-ID: <F001.005DD06E.20040116070938@fatcity.com>

We're developing some schema update scripts for an in-house application, which includes renaming an existing table, and creating a new version using the original name. No problem... or so I thought. :( All seems well under OEM and SQL+, but I have a developer who consistently gets an ORA-904 error (invalid column name) when trying to access the new table under TOAD.

I can't think of anything weird about this table, except that the original has some column-level grants (but not to his userid... he has select/insert/update/delete on both tables). I had him try exiting and restarting TOAD, in case it was caching something relevant, but that didn't make any apparent difference. Any idea what might be going on?

	SQL> desc tool_request_old
	 Name                    Null?    Type
	 ----------------------- -------- ----------------
	 TREQ_TOOLS_REQUEST_PKEY NOT NULL NUMBER(6)
	 TREQ_PEOPLE_FKEY        NOT NULL NUMBER(6)
	 TREQ_SUBMIT_DATE        NOT NULL DATE
	 TREQ_COMPLETE_DATE               DATE
	 TREQ_STATUS             NOT NULL NUMBER(6)
	 TREQ_COMMENTS                    VARCHAR2(2024)
	 TREQ_BYPASS_START                DATE
	 TREQ_BYPASS_END                  DATE

	SQL> desc tool_request
	 Name                    Null?    Type
	 ----------------------- -------- ----------------
	 TREQ_ID                 NOT NULL NUMBER(6)
	 TREQ_PERS_ID            NOT NULL NUMBER(6)
	 TREQ_STATUS_ID          NOT NULL NUMBER(6)
	 TREQ_SUBMIT_TMST        NOT NULL DATE
	 TREQ_BYPASS_START_TMST           DATE
	 TREQ_BYPASS_END_TMST             DATE
	 TREQ_COMPLETE_TMST               DATE
	 TREQ_COMMENTS                    VARCHAR2(1024)

--

My employers like me, but not enough to let me speak for them.

Greg Norris
Sprint LTD Database Administration  

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Norris, Gregory T [ITS]
  INET: gregory.t.norris_at_mail.sprint.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). Received on Fri Jan 16 2004 - 09:09:38 CST