Re: Schema Naming Problem

DATABASE is not a reserved word, but it is a keyword.

Thanks for all inputs.

In article <961102826.24883.0.nnrp-02.9e984b29_at_news.demon.co.uk>,   "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:
>
> Database is (should be) a reserved word in 8.1
> at least, since you can now create triggers
> 'ON DATABASE'
>
> e.g. 'before truncate on database'
>
> which will fire whenever any user issues
> a truncate command.
>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>
> berj_kacherian_not_at_hotmail.com wrote in message
> <8ibet8$dud$1_at_nnrp1.deja.com>...
> >I did the suggestion above and it worked. First of all thank you
 very
> >much. But secondly any explanation of why this works? And the
 reason
> >I am not posting a response to Bob's post is because Deja will not
 let
> >me. I keep getting errors.
> >
> >Also note that the word 'database' has to be uppercase. It will not
> >work if it is lowercase.
> >
> >Any further input on why Oracle acts this way would be greatly
> >appreciated.
> >
> >In article <8hmr6r$tk3$1_at_nnrp1.deja.com>,
> > berj_kacherian_not_at_hotmail.com wrote:
> >> I have a schema which is named DATABASE. Probably not the best
 name,
> >> but it happened. It works fine except I ran into this one
 problem. I
> >> granted select privileges to a couple of tables owned by DATABASE
 to
> >> another user. The other user tried to run the following select
> >> statement:
> >>
> >> select * from database.customer;
> >>
> >> Where DATABASE is the schema name and CUSTOMER is the table name
 and
> >> got the following error:
> >>
> >> select * from database.customer
> >> *
> >> ERROR at line 1:
> >> ORA-00933: SQL command not properly ended
> >>
> >> I will probably drop this user and create a new one. But what
 irks me
> >> is that I cannot find out why it is throwing this error. The word
> >> DATABASE is not a key word in the select statement. Any inputs to
 this
> >> would be greatly appreciated.
> >>
> >> Thanks!
> >>
> >> --
> >> Out the Ethernet, past the firewall, through the router, down the
> >> T1...nothing but Net
> >>
> >> In order to email me remove the '_not' from my email address.
> >>
> >> Sent via Deja.com http://www.deja.com/
> >> Before you buy.
> >>
> >
> >--
> >Out the Ethernet, past the firewall, through the router, down the
> >T1...nothing but Net
> >
> >In order to email me remove the '_not' from my email address.
> >
> >
> >Sent via Deja.com http://www.deja.com/
> >Before you buy.
>
>

--
Out the Ethernet, past the firewall, through the router, down the
T1...nothing but Net

In order to email me remove the '_not' from my email address.


Sent via Deja.com http://www.deja.com/
Before you buy.