8.1.6 EE on NT 4 Sp5 Upgrade to Win2k

Listers,

I am considering upgrading my home machine from NT 4.0 SP5 to Win2k. I have 8.1.6 EE installed as well as tons of other Oracle prodcts and lots of other non-Oracle software. The hardare configuration has been certfied by Dell, and, they sent me the upgrade disk some time ago.

Has anyone done this upgrade with 8.1.6 installed? Success? Dismal failure? Totally wiping the machine clean, doing a fresh install of Win2k, and reinstalling everything might be preferable; but, it would also be *extremely* time consuming. I've searched Metalink and Technet and didn't really turn up anything other than a couple of Forum conversations where it looked they did an upgrade similar to what I am considering. Minor problems, easily fixed, were encountered.

I've already talked to a couple of listers back channel (thanks folks); but, before I attempt the upgrade, I wanted to get the thoughts of other listers as well who may have tried this.

Another option is has anyone purchased or come across stable USB drivers for NT 4.0. NT itself doesn't support USB, and MS doesn't intend to provide support, while Win2K supports USB. And that is the main reason I am looking to upgrade -- I need to use the USB port. If someone knows of good 3rd party generic USB drivers, I might consider that route instead of upgrading to Win2k.

Regards,

Larry G. Elkins
elkinsl_at_flash.net

 From: "Richard Ji" <richard_at_letsplay.com>  Date: Fri, 12 Jan 2001 16:09:11 -0500
 Subject: RE: Random data retrieval

When combined with sample it will return a different row each time.

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Kevin Kostyszyn
Sent: Friday, January 12, 2001 3:32 PM
To: Multiple recipients of list ORACLE-L Subject: RE: Random data retrieval

Wouldn't that just return the first row in the table?

-----Original Message-----
Sent: Friday, January 12, 2001 3:12 PM
To: Multiple recipients of list ORACLE-L

How about use "rownum <= 1" to limit it to one row?

-----Original Message-----
Kirti
Sent: Friday, January 12, 2001 2:34 PM
To: Multiple recipients of list ORACLE-L

Hi Sachin,
You are better of with your solution.
The SAMPLE function can not be used in your case, as it won't necessarily return just one row that you expect. It will return all qualifying rows when using BLOCK sampling, or it will return a number of qulifying rows equal to the PERCENTAGE value specified for the sample. And for just 1 row output, that would be pretty difficult to figure out :) Secondly, SAMPLE works for queries that select from just one table. No table joins are allowed.
HTH.
- Kirti Deshpande

> -----Original Message-----
> From: Sachin Puri [SMTP:sachin_at_siworldwide.com]
> Sent: Friday, January 12, 2001 10:37 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Random data retrieval
>
>
> i am using Oracle 8i only .
> I know that command (i.e sample) however not sure how to use this command.
> Can u tell me how to use this in the query.
>
> Thanks in advance.
>
> Sachin Puri
>
> -----Original Message-----
> Sent: Friday, January 12, 2001 7:57 PM
> To: Multiple recipients of list ORACLE-L
>
>
> If you are using 8i you can use the "sample" clause of the select
> statement.
>
> -----Original Message-----
> Sent: Friday, January 12, 2001 4:36 AM
> To: Multiple recipients of list ORACLE-L
>
>
>
> Consider a table A :
> LesseeID BidRate
> 100 2.4
> 101 2.5
> 102 3.5
> 103 2.4
> 104 2.4
>
> Now I want to retrieve LesseeId with minimum BidRate however please note
> that I just need a single LesseeID and that too randomly.
> Now if I use :
> select LesseeID from A where BidRate = (select min(BidRate) from A);
> The output is :
> LesseeID
> ---------
> 100
> 103
> 104
>
> My Question:
> Does anyone knows how to write a query or any pl/sql block in order to
> retrieve only one LesseeID and that too randomly so i can get only
> a single LesseID and that single LesseeID should be changing each time i
> use the query or block .
> Please note that I don't want to use 'dbms_random' .
> I have actually written a pl/sql block that works perfectly fine however i
> want to have it done in a single query or may be by using small piece of
> code.
>
>
> Rgds,
> Sachin Puri
> Oracle Development and Administration
> Solutions Infosystems,
>
>

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Richard Ji
  INET: richard_at_letsplay.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Kostyszyn
  INET: kevin_at_dulcian.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



------------------------------

 From: William Rogge <William_Rogge_at_voltek.com>
 Date: Fri, 12 Jan 2001 16:12:15 -0500
 Subject: RE: Different ways to transfer data in a table to a FLAT file

One thing to keep in mind if you are using SQL*Plus spool function is that 
you want to execute a 'set term off' before actually executing your select 
script.  Remember that it takes time to display the rows, and the term off