Re: Run sql statement make file system full ?

On Fri, 23 Aug 2002 16:18:37 +0800, "Ken Man" <ken_at_ifshk.com> wrote:

>I have a SQL statement like follows:
>
> Select field1, field2......field50 from table1, table2 where XXXXXX
>
> UNION
>
> Select field1, field2......field50 from table1, table2 where
>YYYYYYY
>
>Then, I got an error message: SQL0968C The file system is full.
>SQLSTATE=57011
>
>I have make some test: 1. When I just one the 1st select statement without
>'Union', it is quite fast and get 66 records.
>
> 2. When I just one the 2nd select
>statement without 'Union', it is quite fast and get 3 records.
>
> 3. After I replace the 'Union' by 'Union
>All', It is fast to get total 69 records without error.
>
>Do anyone can tell me what happen? Thank you very much!
>
>Best Regards,
>
>Ken
>
>

Not an Oracle issue. Must be ODBC. ODBC performs your select locally and create a HUGE temporary file on your local disk. Yet another reason to avoid ODBC like HELL

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Aug 23 2002 - 03:41:30 CDT