Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Altering indexes with users logged in
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