When you say "Oracle stops" do you receive any error message?
Does it hang?
Does it just accept the command and return a SQL prompt?
Jay Miller
-----Original Message-----
Sent: Monday, July 08, 2002 5:04 PM
To: Multiple recipients of list ORACLE-L
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: Miller, Jay
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).
