Re: Error on creating index

From: Jack Silvey <jack_silvey_at_yahoo.com>
Date: Mon, 08 Jul 2002 13:41:09 -0800
Message-ID: <F001.00491B16.20020708134109@fatcity.com>

ali,

the statement you have issued will create the index in the schema of the person you are logged in as, not the person that owns the table necessarily.

is this your intent?

if not, issue the statement "create index user2.index_1 etc etc...."

hth,

jack

• Ali TOYGAR <ali.toygar_at_emu.edu.tr> wrote:
  > Hi ,
  > I have a problem with creating an index ot
  > table AAA with 400000 records.
  >
  > After I write following sql and run it ORACLE stops.
  >
  > CREATE INDEX index_1
  > ON USER1.AAA
  > ( field1,
  > field2 )
  >
  > I copied same table to user2 and when I write above
  > sql it runs !!!!
  >
  > CREATE INDEX index_1
  > ON USER2.AAA
  > ( field1,
  > field2 )
  >
  > Both users ( user1 and user2 ) have same
  > priviliges.(unlimited tables
  > space,connect,resource,...)
  >
  > what is the problem.
  >
  > please help me
  >
  

  ---

Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jack Silvey
  INET: jack_silvey_at_yahoo.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).

Received on Mon Jul 08 2002 - 16:41:09 CDT