When it failed with error the firt time it might have generated lot of
journal entries
if it is highly used table for DML. And it took time to rollback that =
and
applying those=20
to the table. At that time u could not create another rebuild on the =
table.
-----Original Message-----
From: paquette stephane [mailto:stephane_paquette_at_yahoo.com]
Sent: Wednesday, June 28, 2000 11:02 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Index rebuild problem
I've waited a couple of hours and rerun the "alter
index xxx rebuild online tablespace yyyy;" and it
worked. I would like to know what has happened and why
it is working now.
Anybody ?
- paquette stephane <stephane_paquette_at_yahoo.com> a
=E9crit=A0:<br> > Hi,
>=20
> On Oracle 8.1.5/Solaris 2.6, I've tried to rebuild
> an
> index in a different tablespace using "alter index
> xxx
> rebuild online tablespace yyyy;".
>=20
> I had an ORA-3113 during the process.
>=20
> Now, the index is still in the bad tablespace,=20
> when doing another alter index rebuild I have a
> ORA-08106: can not create journal table
> HOURA.SYS_JOURNAL_9631
> when doing a drop of the index I have ORA-08104:
> this
> index object 9631 is being online built or rebuilt.
>=20
> If doing an explain plan I see that Oracle still
> uses
> the index to access the table .
>=20
> Doing an analyze index validate structure reports no
> error.
>=20
> How can I change that index not to be in the rebuild
> mode ? I still want to move that index.
> This is a 24 hour system I do not have a time window
> to drop the table and rebuilt it.
>=20
>=20
>=20
>=20
>=20
> =3D=3D=3D=3D=3D
> Stephane Paquette
> DBA Oracle
> stephane_paquette_at_yahoo.com
> spaquette_at_houra.fr
> (33) 01 53 93 06 50
>=20
> __________________________________________________
> Do You Yahoo!?
> Get Yahoo! Mail - Free email you can access from
> anywhere!
> http://mail.yahoo.com/
> --=20
> Author: =3D?iso-8859-1?q?paquette=3D20stephane?=3D
> INET: stephane_paquette_at_yahoo.com
>=20
> 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).
=3D=3D=3D=3D=3D
Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com
spaquette_at_houra.fr
(33) 01 53 93 06 50
Do You Yahoo!?
Get Yahoo! Mail - Free email you can access from anywhere!
http://mail.yahoo.com/
--=20
Author: =3D?iso-8859-1?q?paquette=3D20stephane?=3D
INET: stephane_paquette_at_yahoo.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
Received on Wed Jun 28 2000 - 10:27:33 CDT
