Re: file placement and SAN

From: Ed Stevens <spamdump_at_nospam.noway.nohow>
Date: Mon, 29 Apr 2002 12:07:52 GMT
Message-ID: <3ccd3384.2783182@ausnews.austin.ibm.com>

On Thu, 25 Apr 2002 18:15:44 +0100, "Paul Brewer" <paul_at_paul.brewers.org.uk> wrote:

>"Ed Stevens" <spamdump_at_nospam.noway.nohow> wrote in message
>news:3cc72643.124146312_at_ausnews.austin.ibm.com...
>> SELECT
>> feedback,
>> comments,
>> experiences,
>> FROM
>> newsgroup_participants
>> WHERE
>> san_experience not null;
>>
>
>Try again, without the comma after 'experiences', and you may get some data
>returned ;-)
>
>HTH,
>Paul
>

Well, I would like to report a bug, wherin the above query should return an ORA-00936: missing expression, but instead returns sporadic results. However, it is no longer possible to talk to a human being on Oracle's support line, and our purchasing department has let our support contract lapse so that I cannot open an i-tar on MetaLink. Just as well, they (Oracle) would probably tell me that the version of Oracle I'm running isn't supported on the brand of ethernet cable we use.

Let's try this one. Perhaps it will also prevent including NAS_FEEDBACK, NAS_COMMENTS, and NAS_EXPERIENCE from the result set.

SELECT

   san_feedback,
   san_comments,
   san_experience

FROM
  newgroup_participants
WHERE
  san_experience not null;

--
Ed Stevens
(Opinions expressed do not necessarily represent those of my employer.)

Received on Mon Apr 29 2002 - 07:07:52 CDT