Re: No result from select

consider

SQL> analyze table TABLENAME validate structure /

"Ray" <raemanuel_at_aol.com> wrote in message news:723c4d29.0211220212.9e6c33e_at_posting.google.com...
> 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 - 22:04:11 CET