Re: sQLPLUS SELECT PROBLEM

From: Ronald D. Jeremy <NO_SPAM_at_yahoo.com>
Date: 25 Feb 2002 21:39:50 GMT
Message-ID: <a5eav6$mlk@dispatch.concentric.net>

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
>
>
Received on Mon Feb 25 2002 - 15:39:50 CST