Re: ORA-904 after table rename

Hi!

Note that when you set an event with alter system, it will only apply for new sessions created, not for any existing ones.

Tanel.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, January 20, 2004 4:19 PM

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

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