Re: No result from select

OK, once again:

If I type in TOAD or SQLPLus:   

    select count(*) from tablename;

I will receive NO message. TOAD or SQLPlus gives no return and after a while I have to interupt the program. Could it be, that the table is corrupt or something similar? If yes, how can I rebuild it without import?

It could be right that I be a newbie but not stupid!

"Steve M" <steve.mcdaniels_at_vuinteractive.com> wrote in message news:<arjj9h$hm8$1_at_spiney.sierra.com>...
> As Alex suggested, you need to supply the text of the query you are using.
>
> For example, suppose table T has 5 trillion rows in it.
> If you do:
>
> select * from T where 1=2
>
> you'll get no rows. Without us seeing your query, we
> might assume you are a newbie and are doing something
> trivially funky.
>
>
> "Ray" <raemanuel_at_aol.com> wrote in message
> news:723c4d29.0211200549.41be6add_at_posting.google.com...
> > Dear all,
> >
> > if I drop a select on a specific table of my Oracle 8.1.7 DB (on
> > Solaris 8), I will receice no result or error message. I tried this
> > with TOAD and SQLPLus.
> >
> > The same happens if I like to export the table with "exp". The export
> > utility will always stop at this table with no error messages on the
> > screen or in the logfile.
> >
> > What can be the reason for that and what can I do?
> >
> > Thanks for any help!
> >
> > Ray
Received on Fri Nov 22 2002 - 11:12:43 CET