Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Schema Naming Problem
put database in double quotes "
select * from "DATABASE".customer;
That should work.
-- Robert Fazio, Oracle DBA rfazio_at_home.com remove nospam from reply address http://24.8.218.197/ <berj_kacherian_not_at_hotmail.com> wrote in message news:8hmr6r$tk3$1_at_nnrp1.deja.com...Received on Thu Jun 08 2000 - 00:00:00 CDT
> 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.