| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: --- re OpenVMS/Tru64/HPUX/etc
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" <ORACLE-L_at_fatcity.com>
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.
dwilliams_at_lifetouch.com
-----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
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
>>> hkchital_at_singnet.com.sg 05/23/02 09:38AM >>>
An upgrade wouldn't cost anything. It would be free as part of your support contract.
Hemant K Chitale
Kevin,
I appreciate your testing efforts. Now to convince the bean-counters
to upgrate to 9i.
Ron
ROR mª¿ªm
>>> ktoepke_at_trilegiant.com 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
>>> ktoepke_at_trilegiant.com 05/22/02 10:38AM >>> Summary: it works!
SQL> SELECT * FROM v$version;
BANNER
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
ktoepke_at_trilegiant.com
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M INET: ktoepke_at_trilegiant.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-LReceived on Fri May 24 2002 - 09:43:35 CDT
(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: RROGERS_at_galottery.org 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: Toepke, Kevin M INET: ktoepke_at_trilegiant.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: Ron Rogers INET: RROGERS_at_galottery.org 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: Hemant K Chitale INET: hkchital_at_singnet.com.sg 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: Ron Rogers INET: RROGERS_at_galottery.org 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: Hemant K Chitale INET: hkchital_at_singnet.com.sg 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: DENNIS WILLIAMS INET: DWILLIAMS_at_LIFETOUCH.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: Hemant K Chitale INET: hkchital_at_singnet.com.sg 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).
 |
 |