Hemant - We will absolutely still be running Tru64 for many years to come.
However, we have decided not to buy any more Alpha servers.
About the time we were trying to make a decision, the META Group
forecast that a few years from now there would only be 3 server operating
systems widely used:
- W2K
- Linux
- Solaris
Their prediction was that the other Unix variants would eventually migrate
to Linux. Only Solaris has a strong enough future to remain on its own. I
notice on the news that Sun is releasing more Linux software itself.
Anyway, it seemed that both W2K and Linux were less proven than
Solaris, so Solaris seemed to be a safer choice.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-----Original Message-----
Sent: Friday, May 24, 2002 9:44 AM
To: Multiple recipients of list ORACLE-L
We have far too many Oracle on Tru64 installations
to consider a quick migration out. Apparently, Compaq
has convinced us that Tru64 will still be around
for a few years. HPUX will be taking up the
"good" features of Tru64 (AdvFS and Clustering+ClusterFileSystem).
The other concern we had was about Alpha. I believe
that there would be about two more releases of the Alpha
and then welcome Intel.
We also have SPARC Solaris databases but I'm not
sure how much time the "big damagers" want to spend
on considering migrating to SPARC Solaris. Might as well
also look at IBM [although that, too, might go from PowerPC
to Itanium].
Hemant K Chitale
http://hkchital.tripod.com
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, 24 May, 2002 1:43 AM
Hermat - We are on Tru64 and I couldn't be more pleased. However, I believe
that HP/Compaq has decided to eventually withdraw Tru64. My guess is that is
so they can support HPUX. However, they were pretty clear that OpenVMS would
continue. My guess is that Ron is hinting that there are other reasons to
move to VMS at his company. Just sign me as "learning Solaris".
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-----Original Message-----
Sent: Thursday, May 23, 2002 11:29 AM
To: Multiple recipients of list ORACLE-L
The bane of trying to keep up with technology.
But why OpenVMS and not Tru64, then.
We have a large number of Tru64 Oracle Databases
(we do have OpenVMSs for Promis databases
used in manufacturing, I believe).
Hemant K Chitale
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, 23 May, 2002 11:03 PM
Hemant,
The price I am referring to is the cost involved with moving from a
Dell server on Novell to a Compaq OpenVMS server. There are a lot of
company sided issues that have to be addressed and cases made for the
move. In this case the software is not an issues as you stated, the
issues revolve around the hardware and developmental considerations. I
would be more that happy to move to the latest and greatest "solid"
platform/database combination. It would allow us to create and implement
browser based applications rather easily and would allow us to use the
9iAS Suite of products.
For now all I can do is make requests for item to be included in the
budget as we move "forward, backwards, sideways, dance on circles".
Ron
ROR m���m
>>> [EMAIL PROTECTED] 05/23/02 09:38AM >>>
An upgrade wouldn't cost anything. It would be free
as part of your support contract.
Hemant K Chitale
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, 23 May, 2002 2:41 AM
Kevin,
I appreciate your testing efforts. Now to convince the bean-counters
to upgrate to 9i.
Ron
ROR m���m
>>> [EMAIL PROTECTED] 05/22/02 02:08PM >>>
I reran my test. with 250,000 rows in the table. It took a whopping
0.25
seconds to complete.
-----Original Message-----
Sent: Wednesday, May 22, 2002 12:59 PM
To: Multiple recipients of list ORACLE-L
Kevin,
Yes but does it work with data in the column?, I do not have 9i set
up
yet. If it works as you describe with data in the column it will
really
help with the multi million row tables that "they" want to rename a
column after a release of a new lotto game.
thanks,
for the test and update.
Ron
ROR m���m
>>> [EMAIL PROTECTED] 05/22/02 10:38AM >>>
Summary: it works!
SQL> SELECT * FROM v$version;
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for Solaris: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production
SQL> create table test_table (wrong_name VARCHAR2(40));
Table created.
SQL> alter table test_table rename column wrong_name to right_name;
Table altered.
SQL> desc test_table;
Name Null? Type
----------------------------------------- --------
----------------------------
RIGHT_NAME VARCHAR2(40)
SQL>
Kevin Toepke
[EMAIL PROTECTED]
----------------------------------------------------------------------------
----------------------------------------------------------------------------
------------------------
The information in this electronic mail message is Trilegiant
Confidential
and may be legally privileged. It is intended solely for the
addressee(s).
Access to this Internet electronic mail message by anyone else is
unauthorized. If you are not the intended recipient, any disclosure,
copying, distribution or action taken or omitted to be taken in
reliance on
it is prohibited and may be unlawful.
----------------------------------------------------------------------------
----------------------------------------------------------------------------
------------------------
The sender believes that this E-mail and any attachments were free of
any
virus, worm, Trojan horse, and/or malicious code when sent. This
message and
its attachments could have been infected during transmission. By
reading the
message and opening any attachments, the recipient accepts full
responsibility for taking protective and remedial action about viruses
and
other defects. Trilegiant Corporation is not liable for any loss or
damage
arising in any way from this message or its attachments.
----------------------------------------------------------------------------
----------------------------------------------------------
------------------
------------------------
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Toepke, Kevin M
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Ron Rogers
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Toepke, Kevin M
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Ron Rogers
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Hemant K Chitale
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Ron Rogers
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Hemant K Chitale
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Hemant K Chitale
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
