Re: IO Error ORA-01114: IO error writing block to file %s (block # %s)

jmurali2000_at_yahoo.com wrote:
> When running a select statement i am getting the following error
> ORA-01114: IO error writing block to file %s (block # %s). The query is
> pretty complex.
>
> If some one tell me the cause of this query it would be better.

Lets explore what you have NOT provided.

1. Oracle edition and version
2. Hardware platform, operating system, and patch level
3. The actual error message
4. The actual SELECT statement
5. Any trace files

Lets explore what we can NOT help you with.

1. Anything and everything. ;-)

Seriously ... you need to provide some information from which a response can be formulated. But in general ... SELECT statements don't write blocks to files.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)