Re: No result from select
Date: Thu, 21 Nov 2002 13:30:56 -0800
Message-ID: <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 Thu Nov 21 2002 - 22:30:56 CET