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. > > > > Thanks, > > Lei > > > ------------------------------ > > *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto: > oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Hemant K Chitale > *Sent:* Wednesday, December 08, 2010 4:02 PM > *To:* Lei Zeng > *Cc:* oracle-l@xxxxxxxxxxxxx > *Subject:* Re: use external table to read alert log > > > > How large is the alert.log that you consider using parallel query ? > > Hemant K Chitale > http://hemantoracledba.blogspot.com > sent from my smartphone > > On Dec 9, 2010 7:04 AM, "Lei Zeng" <lzeng@xxxxxxxxxxxxx> wrote: > > Hi: > > > > I have read few notes about using external table to read alert log. > > > http://proracle.wordpress.com/how-to-read-oracle-alert-log-file-using-external-table/ > > > > My question is: is it guaranteed that the line number in the file will be > kept the same as rownum in the table? > > I am wondering if I use parallel option to read a file, the sequence of > lines in the file will be kept? > > If no, is there other option to accomplish that? > > > > Thanks, > > Lei > > -- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.'