Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Schema Naming Problem

Re: Schema Naming Problem

From: Bob Fazio <rfazio_at_home.com.nospam>
Date: 2000/06/08
Message-ID: <LnF%4.239674$Tn4.2172664@news1.rdc2.pa.home.com>#1/1

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...

> 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.
Received on Thu Jun 08 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US