Re: sQLPLUS SELECT PROBLEM

Check the alert log for any error messages...

A select * from table will not be affected by any locks that other users' insert,update or delete statements may cause; the data you get is a view of the data as it existed at the moment the query was processed..Locks usually will not affect select statements ( except for 'select ... FOR UPDATE' types)

"Ronald D. Jeremy" <NO_SPAM_at_yahoo.com> wrote:

>Sorry .. I forgot platform details.
>
>Oracle 8.1.7 / Solaris 7 (Sparc)
>
>"Ronald D. Jeremy" <NO_SPAM_at_yahoo.com> wrote in message
>news:a5eak4$mlj_at_dispatch.concentric.net...
>> I did a "select * from table" command on sqlplus.
>>
>> It seems to freeze at certain a certain record. I did a shutdown and
>> startup on the database and I still have the problem.
>>
>> I would have to delete the entire table and start again to get back to
>> normal processing of select statements.
>>
>> I have processes inserting and updating to the database at times. If there
>> is some locking issue, would it be solved by just shuting down the
>database
>> and restarting?
>>
>> What could this be? It persists even after any reads or writes to the
>table
>> has stopped.
>>
>> Thanks
>>
>>
>

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World!  Check out our new Unlimited Server. No Download or Time Limits! -----== Over 80,000 Newsgroups - 19 Different Servers! ==----- Received on Mon Feb 25 2002 - 15:51:17 CST