You might also check to see if the column name is a reserved word that Oracle uses. This sometimes causes a problem. It seems like I ran into something like this last year or so when converting a FOXPRO table into Oracle using Microsoft's DTS. The FOXPRO table had a column with some name that Oracle wouldn't let me use because the column name was a reserved word like NAME.

Paul Blosser
System Developer
Abanco Int'l, LLC.
847-227-2301x2421
-----Original Message-----
From: Bashar Shannak [mailto:oracledba-ezmlmshield-x12572076.[Email address protected]
Sent: Tuesday, October 31, 2006 12:24 AM
To: LazyDBA Discussion
Subject: Re: Very Urgent(ORA-00904)

Hi
I search for this error and i advice to check this strategiy in name the columns:

A valid column name must begin with a letter, be less than or equal to 30 characters, and consist of only alphanumeric characters and the special characters $, _, and #. If it contains other characters, then it must be enclosed in double quotation marks. It may not be a reserved word....

Thanks
Bashar Shannak
Maktoob Inc
>
>
>
>
> ----- Original Message -----
> From: susanta "oracledba-ezmlmshield-x7252103.[Email address protected]
> To: LazyDBA Discussion "[Email address protected]
> Date: 05:52 AM
> Subject: Very Urgent(ORA-00904)
>
>
>
> Hi,
>
>
>
> When I run a process Some data is inserted in table but after some time
>
> it is showing the error message ORA-00904->The column name entered is
>
> either missing or invalid.
>
>
>
> Plz tell how can I Solve It.
>
>
>
>
>
>
>
> DISCLAIMER
>
>
>
> “The information contained in this e-mail message and/or attachments to it
> may contain confidential or privileged information. If you are not the intended
> recipient, any dissemination, use, review, distribution, printing or copying of
> the information contained in this e-mail message and/or attachments to it are
> strictly prohibited. If you have received this communication in error, please
> notify us by reply e-mail or telephone and immediately and permanently delete
> the message and any attachments. Thank you"
>
>
>
>
>
> ---------------------------------------------------------------------
>
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>
> To post a dba job: http://jobs.lazydba.com
>
> To Subscribe : http://www.LazyDBA.com
>
> To unsubscribe: http://www.lazydba.com/unsubscribe.html



_________________________________________________
Download your favorite football Wallpapers, Screensavers, & fantastic Video Clips for your favorite team players and games.
http://www.maktoob.com/football


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page