Re: BACK DOORS in Oracle

That's strange.. I tried this

create table kirk1(date char(1))

and got the expected:

ORA-00904: invalid column name

pointing to date..

did you say create table ... ("DATE" ...

or something.. that's perfectly valid and you can use pretty much ANY string you want but later references need to be in double quotes too. Not sure why you got all the crashes but I wish you'd report them to Oracle support.

In article <5ik8t8$qle_at_chronicle.concentric.net>, Nnoor_at_cris.com (NNOOR) wrote:

> I had a not so pleasant experience with Oracle a few days ago.
>
> DATE is supposed to be a reserved word in Oracle and you are not
> allowed to use as a column etc name (now I know it!). I created a
> whole bunch of tables by running scripts which was based on the DDL
> of a DB on MS SQL Server. One of those tables had DATE as a column
> name. Oracle didn't catch it while running the script and now I had
> a table with a column named DATE. After that, I started having
> mysterious crashes in Oracle. It was really frustarting. I figured
> the problem out when I was creating a string of triggers on some
> tables and an attempt to create triggers on particular table always
> resulted in Oracle getting crashed with the same Dr. Watson (winNT)
> messages. Only when I decided to drop the table and recreate it
> thinking that may be file sectors have gone bad or some thing that
> I found the problem. Once that was fixed, all errors just went away.
>
> Not pretty.....
>
> --nasir
Received on Fri Apr 11 1997 - 00:00:00 CDT