Re: Toad is locking table in oracle
From: shakespeare <whatsin_at_xs4all.nl>
Date: Thu, 13 Dec 2007 08:53:31 +0100
Message-ID: <4760e4f7$0$85795$e4fe514c_at_news.xs4all.nl>
Date: Thu, 13 Dec 2007 08:53:31 +0100
Message-ID: <4760e4f7$0$85795$e4fe514c_at_news.xs4all.nl>
"zino" <antony6670_at_gmail.com> schreef in bericht
news:337a6229-e02d-4c04-a592-c9d273d27666_at_a39g2000pre.googlegroups.com...
> We just got Toad 9.xxx.
> we noticed that every time an end user is working on a table (sinple
> select statement) from his end, the table will get locked and stay as,
> until this user's statement is finished or he close his session. Is
> that normal with oracle or is there something can be done on Toad
> side.
>
> thanks for help
You COULD use TOAD Security, a set of scripts creating tables in yoyr database telling who can do what withToad on that database.
Shakespeare Received on Thu Dec 13 2007 - 08:53:31 CET