Re: Error on creating index

[Danisment Gazi Unal (ubTools)]

Hello, What does "Oracle stops" mean ? If Oracle crashes without an error, check alert.log. If not, debug your session with event 1006 level 8 to see Oracle kernel events. regards... Ali TOYGAR 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 -- Danisment Gazi Unal http://www.ubTools.com