| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-904 after table rename
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 servicesto: 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).
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: 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).
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: 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 Mon Jan 19 2004 - 16:00:10 CST
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |