RE: Aarrrggghhh!!! Creating an index shouldn't be so hard!

From: Satar Naghshineh <Satar.Naghshineh_at_irvine.mellesgriot.com>
Date: Wed, 4 Oct 2000 14:49:22 -0700
Message-Id: <10639.118531@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C02E4C.F4AC9C30
Content-Type: text/plain

grant CREATE INDEX to sysop

;)

Satar

> -----Original Message-----
> From: Dennis Taylor [SMTP:ismgr_at_pctc.com]
> Sent: Wednesday, October 04, 2000 11:26 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Aarrrggghhh!!! Creating an index shouldn't be so hard!
>
> Well, I must admit to being flummoxed. The nature of this problem
> guarantees that it'll be easy, and I'll be embarrased. Well, tough. I'm
> tired of beating my head against the wall.
>
> I'm trying to create a function-based index on a table. Here's what I do:
>
> create user sysop identified by password
> default tablespace data
> temporary tablespace temp;
>
> grant CREATE SESSION to sysop;
> grant CREATE TABLE to sysop;
> grant UNLIMITED TABLESPACE to sysop;
> grant CREATE PUBLIC SYNONYM to sysop;
> grant DROP PUBLIC SYNONYM to sysop;
> grant CREATE DATABASE LINK to sysop;
> grant CREATE VIEW to sysop;
> grant CREATE TRIGGER to sysop;
> grant CREATE PROCEDURE to sysop;
>
> connect sysop/password
>
> drop table issuer;
>
> create table issuer (
> ISSUER_ID number(9) primary key,
> ISSUER_NAME varchar(80)
> );
>
>
> create index ISSUER_NAME_IDX on ISSUER (UPPER(ISSUER_NAME));
>
> And here's what I get:
>
>
> Table created.
>
> create index ISSUER_NAME_IDX on ISSUER (UPPER(ISSUER_NAME))
> *
> ERROR at line 1:
> ORA-01031: insufficient privileges
>
> (The '*' is actually under the 'I' in 'ISSUER_NAME')
>
> First, the reading of ora-1031 isn't even close to making sense. Then, if
> it's a privilege problem, I can't find any mention of any privilege that I
> don't have that I should need.
>
> Please relieve my groggy brain by pointing out the obvious problem so I
> can go hide under my desk. Thanks.
>
>
>
> ---
> Dennis Taylor
> ---
> Don't worry about people stealing your ideas. If your ideas
> are any good, you'll have to ram them down people's throats. -- Please
> see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dennis
> Taylor INET: ismgr_at_pctc.com
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San
> Diego, California -- Public Internet access / Mailing Lists
> -------------------------------------------------------------------- To
> REMOVE yourself from this mailing list, send an E-Mail message to:
> ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the
> message BODY, include a line containing: UNSUB ORACLE-L (or the name of
> mailing list you want to be removed from). You may also send the HELP
> command for other information (like subscribing).

------_=_NextPart_001_01C02E4C.F4AC9C30
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =

charset=3DUS-ASCII">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12">
<TITLE>RE: Aarrrggghhh!!! Creating an index shouldn't be so = hard!</TITLE>
</HEAD>
<BODY>

grant CREATE INDEX = to sysop

<BR><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">&nbsp;</FONT>
<BR><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">;)</FONT>
</P>

<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Satar</FONT>
</P>
<UL>

-----Original Message----- From:   Dennis Taylor [SMTP:ismgr_at_pctc.com] Sent:   Wednesday, October 04, 2000 11:26 PM To:     Multiple recipients of list ORACLE-L Subject:       = Aarrrggghhh!!! Creating an index = shouldn't be so hard!

Well, I must admit to being flummoxed. The = nature of this problem guarantees that it'll be easy, and I'll be = embarrased. Well, tough. I'm tired of beating my head against the wall. =

I'm trying to create a function-based index on = a table. Here's what I do:

create user sysop identified by = password 
         default tablespace data         temporary tablespace temp;

<P><FONT SIZE=3D2 FACE=3D"Courier New">grant CREATE SESSION to sysop; =
</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New">grant CREATE TABLE to sysop; =
</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New">grant UNLIMITED TABLESPACE to =

sysop; 
 grant CREATE PUBLIC SYNONYM to = sysop; 
 grant DROP PUBLIC SYNONYM to = sysop; 
 grant CREATE DATABASE LINK to = sysop;

<BR><FONT SIZE=3D2 FACE=3D"Courier New">grant CREATE VIEW to sysop; =
</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New">grant CREATE TRIGGER to sysop; =
</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New">grant CREATE PROCEDURE to =

sysop;

connect sysop/password

drop table issuer;

create table issuer (         ISSUER_ID       =         number(9) primary key, = 
         ISSUER_NAME     =         varchar(80)

<BR><FONT SIZE=3D2 FACE=3D"Courier New">); </FONT>
</P>
<BR>

create index ISSUER_NAME_IDX on = ISSUER (UPPER(ISSUER_NAME));

<P><FONT FACE=3D"Arial">And here's what I get: </FONT>
</P>
<BR>

Table created.

create index ISSUER_NAME_IDX on ISSUER = (UPPER(ISSUER_NAME)) 
 <FONT =

FACE=3D"Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; * =
</FONT>
<BR><FONT FACE=3D"Arial">ERROR at line 1: </FONT>

ORA-01031: insufficient privileges

(The '*' is actually under the 'I' in = 'ISSUER_NAME')

First, the reading of ora-1031 isn't even close = to making sense. Then, if it's a privilege problem, I can't find any = mention of any privilege that I don't have that I should need. =

Please relieve my groggy brain by pointing out = the obvious problem so I can go hide under my desk. Thanks.

</P>
<BR>
<BR>

<P><FONT FACE=3D"Arial">--- </FONT>
<BR><FONT FACE=3D"Arial">Dennis Taylor </FONT>

--- 
 Don't worry about people stealing your = ideas.  If your ideas 
 are any good, you'll have to ram them down = people's throats. --  Please see the official ORACLE-L = FAQ: <A = HREF=3D"http://www.orafaq.com" =
TARGET=3D"_blank">http://www.orafaq.com</A> --  Author: Dennis Taylor   INET: = ismgr_at_pctc.com

Fat City Network Services    -- = (858) 538-5051  FAX: (858) 538-5051 San Diego, = California        -- Public Internet = access / Mailing Lists =

-------------------------------------------------------------------- To =

REMOVE yourself from this mailing list, send an E-Mail message to: = ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the = message BODY, include a line containing: UNSUB ORACLE-L (or the name of = Received on Wed Oct 04 2000 - 16:49:22 CDT