Re: is there a way to manually lock a table?

Re: is there a way to manually lock a table?

 

  

how do i lock the table manually?


---------------------- Forwarded by Michael L. de los
Reyes/DCSD/ITD/UCPB/PH on 09/30/2003 02:53 PM ---------------------------


"Syed Jaffar Hussain" <[Email Address Removed] on 09/30/2003 02:47:49
PM

To: <[Email Address Removed] Re: is there a way to manually lock a table?


you can lock table manually

----- Original Message -----
From: <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Tuesday, September 30, 2003 9:45 AM
Subject: is there a way to manually lock a table?


> is there a way to manually lock a table in oracle 7.2.3?
> i want to run a batch program on a table while there is online
processing.
> i want to lock the table if possible. or do i just revoke all from the
> users abl to use the table and then grant them back?
> thanks.
>
>
>
> --------
> Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>
>




Oracle LazyDBA home page