Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Fw: Error on creating index

Re: Fw: Error on creating index

From: <Jared.Still_at_radisys.com>
Date: Tue, 09 Jul 2002 11:58:31 -0800
Message-ID: <F001.00492C33.20020709115831@fatcity.com>


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

from v$session s, v$session_wait e
where s.sid = e.sid

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
5 - OS is windows 2000 Server

 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US