RE: Error on creating index

[Khedr, Waleed]

Are you creating the index on each table using the user id of the table owner? -----Original Message----- From: Ali TOYGAR [mailto:[EMAIL PROTECTED]] Sent: Monday, July 08, 2002 5:04 PM To: Multiple recipients of list ORACLE-L Subject: Error on creating index 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