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

Home -> Community -> Usenet -> c.d.o.server -> Re: Altering indexes with users logged in

Re: Altering indexes with users logged in

From: Robert Worreby <Robert.Worreby_at_swisstelecom.com>
Date: 1997/04/24
Message-ID: <335F0796.365E@swisstelecom.com>#1/1

If You get IN USE then make it the hard and tough way:

LOCK TABLE xxxx EXCLUSIVE MODE;
ALTER INDEX;
COMMIT; //Robert

Tim Witort wrote:
>
> Anyone ever altered an index (increasing MAXEXTENTS) while
> users are logged in and using the index? I'll probably
> wait till I can boot everyone out so I can avoid the
> "IN USE" errors, but I thought I'd ask if anyone knows
> of a way to avoid this and do it live.
>
> thanks,
> -- TRW
> --
> |||| remove the underscores in my address to reply ||||
> |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
> | Tim Witort || He is not silent. He is not |
> | trw_@_medicalert.org || whispering. We are not quiet |
> | || we are not listening. |
> | Pin: TZ, only one :^( || - Out of the Grey |
> |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Received on Thu Apr 24 1997 - 00:00:00 CDT

Original text of this message

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