Re: ORA-904 after table rename

From: <jo_holvoet_at_amis.com>
Date: Fri, 16 Jan 2004 07:34:26 -0800
Message-ID: <F001.005DD070.20040116073426@fatcity.com>

Does his version of TOAD support your Oracle server version ? We tried to run our (outdated) version of SQL Navigator against a 9i DB and would get weirdness like this from time to time when accessing the Oracle data dictionary.

mvg/regards

"Norris, Gregory T [ITS]" <gregory.t.norris_at_mail.sprint.com> Sent by: ml-errors_at_fatcity.com
01/16/2004 16:09
Please respond to ORACLE-L

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        ORA-904 after table rename

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).

--

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

Author:
INET: jo_holvoet_at_amis.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