Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Fw: Error on creating index
Since it's 8i, you still have svrmgrl and can connect internal.
Can you 'connect internal' from svrmgrl?
If so, you can run the following query to see what is hanging.
I've had a similar problem on the past, I believe the hang was on a library latch.
col sid format 99999
col username format a10
col event format a30
col p1text format a10
col p1 format 99999999999
col p2text format a10
col p2 format 99999999999
col wait_time format 999999 head 'WAIT|TIME'
col seconds_in_wait format 999999 head 'SECONDS|IN|WAIT'
col state format a20
break on username skip 1 on event
select
s.username username, e.event event, s.sid, e.p1text, e.p1, e.p2text, e.p2, e.wait_time, e.seconds_in_wait, e.state
HTH Jared
"Ali TOYGAR" <ali.toygar_at_emu.edu.tr>
Sent by: root_at_fatcity.com
07/08/2002 11:33 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: Subject: Fw: Error on creating index
Thank you all for your interest.
1 - I did not get any error message. 2 - I do not have an index named index_1 in the USER1 schema. 3 - Oracle stops means oracle crashes without an error. It gets stuck.It waits forever and no other user(s) may connect to it. 4 - Oracle version Oracle 8i
I will try MR. Danisment Gazi Unal suggestions. I hope and wish I will succeed...
Again Thank you all four your interest.
Ali TOYGAR
> 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: JayMiller_at_TDWaterhouse.com
>
> 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: ListGuru_at_fatcity.com (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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ali TOYGAR INET: ali.toygar_at_emu.edu.tr 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: ListGuru_at_fatcity.com (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: Jared.Still_at_radisys.com 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: ListGuru_at_fatcity.com (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).Received on Tue Jul 09 2002 - 14:58:31 CDT