Parallel query works on external tables, however if one desires to read the file in line order, there is no reason or benefit to use parallel query that I can think of. Perhaps a description of what you are trying to accomplish will aid in people offering advice. On Thu, Dec 9, 2010 at 12:07 PM, Andrew Kerber <andrew.kerber@xxxxxxxxx> wrote: > Well, I would recommend that you write out a large file and then read it > back in and see what happens. If you would post the results to the list, I > would be interested in them myself. I suspect that you wont be able to get > a parallel query to work on an external table, but that is only a suspicion, > I have no proof one way or another. > > On Wed, Dec 8, 2010 at 8:11 PM, Lei Zeng <lzeng@xxxxxxxxxxxxx> wrote: >> >> Alert log is just one use case. I am considering the use case of other >> large files which need to keep the line order in the way like alert log. -- Regards, Greg Rahn http://structureddata.org -- //www.freelists.org/webpage/oracle-l