Ali,
Do you get an error message? If so, post it as that will help
troubleshooting efforts.
Is there already an index named index_1 in the USER1 schema?
Just some ideas.
Stephen
>>> [EMAIL PROTECTED] 07/08/02 02:04PM >>>
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
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephen Andert
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).
