| 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: Anyone run into this strange ORA-00904 error ??
Content-Type: text/plain;
charset="iso-8859-1"
I have run into this problem in the past in two different situations. The first is where there is a reserved word somewhere that you managed to sneak through somehow... the second is where there is an internal view created for some reason that barfs... e.g., VW_NSO_1.$NSO_COL_1. Check your alert log. If it's the latter, it's a bug. If it's the former, try specifying the columns and adding a column alias where the column could conceivably be a reserved word. You didn't give us all the column names, but try something like this...
select internal_identifier int_id, title_cd,nonissue, nonissue2,
boy_this_could_be_a_problem a,nonissue3...
from your_table
where x=y
HTH,
Bambi.
-----Original Message-----
[mailto:babette.turnerunderwood_at_hrdc-drhc.gc.ca]
Sent: Tuesday, December 02, 2003 10:34 AM
To: Multiple recipients of list ORACLE-L
We started having a weird problem that looks like some kind of data dictionary corruption.
My first choice is to run catalog / catproc. This did nothing to resolve the problem.
Why am I able to describe an object, but get ORA-00904 when I try to select from the table...
SQL> desc ispownre3.individual_names;
Name Null? Type ----------------------------------------- -------- ------------------ INTERNAL_IDENTIFIER NUMBER(12) TITLE_CD NUMBER(3). . .
SQL> select * from ispownre3.individual_names; select * from ispownre3.individual_names
*
------_=_NextPart_001_01C3B929.641D10D0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<TITLE>Message</TITLE>
<META content=3D"MSHTML 6.00.2800.1226" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT face=3DTahoma><SPAN class=3D738340423-02122003><FONT =
face=3DArial><FONT=20
color=3D#0000ff size=3D2>I have run into this problem in the past in =
two different=20
situations. The first is where there is a reserved word somewhere =
that you=20
managed to sneak through somehow... the second is where there is an =
internal=20
view created for some reason that barfs... e.g., =
VW_NSO_1.$NSO_COL_1. =20
Check your alert log. If it's the latter, it's a bug. If =
it's the=20
former, try specifying the columns and adding a column alias where =
the=20
column could conceivably be a reserved word. You didn't give us =
all the=20
column names, but try something like =
this...</FONT></FONT></SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D738340423-02122003></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN =
class=3D738340423-02122003>select=20
internal_identifier int_id, title_cd,nonissue, nonissue2,=20
boy_this_could_be_a_problem a,nonissue3...</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN =
class=3D738340423-02122003>from=20
your_table</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN =
class=3D738340423-02122003>where=20
x=3Dy</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D738340423-02122003></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D738340423-02122003>HTH,</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D738340423-02122003>Bambi.</SPAN></FONT></DIV>
<DIV><FONT face=3DTahoma><SPAN class=3D738340423-02122003><FONT =
face=3DArial=20
color=3D#0000ff size=3D2> </FONT></SPAN><BR><FONT size=3D2><SPAN=20 class=3D738340423-02122003><FONT face=3DArial=20 color=3D#0000ff> </FONT></SPAN>-----Original =Message-----<BR><B>From:</B>=20
size=3D2> Name  = ;  = ;  = ; =20 Null? Type</FONT> <BR><FONT face=3DArial=20 size=3D2> ----------------------------------------- --------=20 ------------------</FONT> <BR><FONT face=3DArial=20=
size=3D2> INTERNAL_IDENTIFIER &n= bsp; &n= bsp; &n=bsp;=20
size=3D2> TITLE_CD &= nbsp; &= nbsp; &= nbsp; =20NUMBER(3)</FONT> <BR><FONT face=3DArial size=3D2>. . . </FONT></P> <P><FONT face=3DArial size=3D2>SQL> select * from=20 ispownre3.individual_names;</FONT> <BR><FONT face=3DArial = size=3D2>select * from=20
------_=_NextPart_001_01C3B929.641D10D0--
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi INET: bbellow_at_chi.navtech.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 Dec 02 2003 - 17:14:24 CST
 |
 |