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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: ORA-904 after table rename

Re: ORA-904 after table rename

From: Mladen Gogala <mladen_at_wangtrading.com>
Date: Tue, 20 Jan 2004 06:19:27 -0800
Message-ID: <F001.005DDA6D.20040120061927@fatcity.com>


Oradebug is the right way to go because, for some reason, "alter system set events='904 trace name errorstack forever, level 10';" doesn't do anything. The only way to activate trace is to go to oradebug,
attach the session (of course, one needs to do gymnastics with V$SESSION and V$PROCESS to find the SPID) and then use oradebug event 904.... With all these strings attached, it's still a very useful tool to see which tables are being missed in action.

On 01/19/2004 05:00:10 PM, Chris Stephens wrote:
> I went through a similar problem with the 904 error. I had to use
> oradebug
> to get a trace file to be produced.
>
> Good luck,
> Chris
>
> -----Original Message-----
> Sent: Monday, January 19, 2004 8:14 AM
> To: Multiple recipients of list ORACLE-L
>
> It turns out that the user had configured TOAD to use a table filter,
> which
> causes it to create and store a query. As you've probably guessed,
> the
> query was referencing a column which no longer exists.
>
> On a related note, I initially tried to capture the failing query
> using
> "alter system set events='904 TRACE NAME ERRORSTACK'", but no trace
> files
> were ever created. Any idea what the command should really have
> been?
>
> -----Original Message-----
> Norris, Gregory T [ITS]
> Sent: Friday, January 16, 2004 9:10 AM
> To: Multiple recipients of list ORACLE-L
>
>
> 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: 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: Chris Stephens
> INET: ChrisStephens_at_affina.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: Mladen Gogala
  INET: mladen_at_wangtrading.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 Tue Jan 20 2004 - 08:19:27 CST

Original text of this message

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