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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
