Mladen - I'm sorry but I'm still struggling with the part of your note that
says After all, I had to resign because I advised my boss to buy MIPS R3300
based DECSystems 5800 with Ultrix. In slightly less then a year . . .
Let me understand. You made a recommendation, which your boss accepted.
-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 24, 2002 1:23 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Oracle and OpenVMS (was: Rename Column in 9iR2)
Mladen - I'm sorry but I'm still struggling with the part of
your note
Gogala, Mladen wrote:
system should be purchased (well, aside from an Altos server
running a Z-80,
but that worked out well, but again, NO upgrade path), and in
the future I'm
going to be very careful not to give anybody the idea that
I'm offering an
opinion unless it is clearly
: Friday, May 24, 2002 1:23 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Oracle and OpenVMS (was: Rename Column in 9iR2)
Mladen - I'm sorry but I'm still struggling with the part of
your note that
says After all, I had to resign because I advised my boss to
buy MIPS R3300
based
To steal a quote from Matt Adam's white board (sorry Matt!):
You gotta stop thinking logically, and start thinking Oracley - Jim Droppa
Don Granaman
[OraSaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, May 22, 2002 2:00 PM
Upgrade to 9iR2 today.
Rename column does not work in 9.0.1.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, May 22, 2002 9:30 PM
If those times are right... its a functionality you
should not live without, its
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
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
PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
From: Ron Rogers [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 23, 2002 10:04 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Rename Column in 9iR2
Hemant,
The price I am referring
: Rename Column in 9iR2
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
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
System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
From: Ron Rogers [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 23, 2002 10:04 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Rename Column in 9iR2
, May 23, 2002 11:33 AM
To: Multiple recipients of list ORACLE-L
Subject:Oracle and OpenVMS (was: Rename Column in 9iR2)
As a side note, please please please become familiar with OpenVMS and more
importantly Oracle on OpenVMS before tackling this. At least as far up as
8i, Oracle has
23, 2002 10:33 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Oracle and OpenVMS (was: Rename Column in 9iR2)
Rich,
I thank you for the heads up. I have read the install and release
notes for Oracle on OpenVMS and will approach with a lot of caution. I
am very familiar
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
Hemant,
Being an ol unix admin I would like very much to use Tru64 but we
have a lot of applications written for OpenVMS that would have to be
converted and then there would be the issue of sysadmin training or hire
and licensing issues and costs. These all cost $$$ and we are an
institution
Thanks, Barb.
From the traffic on this issue I think that there is quite a few VMS
users on the list. They have been quiet and do not generate a lot of
traffic. Does this mean that I have to watch all of the other traffic
and think to myself why not convert to VMS and not have the
problems?
-
Sent: Thursday, May 23, 2002 11:33 AM
To: Multiple recipients of list ORACLE-L
Subject:Oracle and OpenVMS (was: Rename Column in 9iR2)
As a side note, please please please become familiar with OpenVMS and more
importantly Oracle on OpenVMS before tackling this. At least as far up
Ron - I have my VMS env set similar to my unix env. I use vms symbols to match unix
aliae's/cmds, vms logicals to match unix env variables, vms dcl scripts to match unix
ksh scripts. Even have a crontab dcl script that works much like unix cron (well
almost :)). I have 1 dcl script for all
were asthetically nice.
-Original Message-
From: Gene Sais [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 23, 2002 2:58 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Oracle and OpenVMS (was: Rename Column in 9iR2)
VMS uses logicals as much as Unix uses environment
USA
-Original Message-
From: Gene Sais [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 23, 2002 11:29 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Oracle and OpenVMS (was: Rename Column in 9iR2)
vms is a great os, if only dec ported it to the intel chip,
then ms would
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
From: Gene Sais [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 23, 2002 11:29 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Oracle and OpenVMS (was: Rename Column in 9iR2)
vms
To: Multiple recipients of list ORACLE-L
Subject: RE: Oracle and OpenVMS (was: Rename Column in 9iR2)
VMS uses logicals as much as Unix uses environment variables.
I use vms logicals and unix env variables in my db create
scripts. VMS logicals also work for init.ora params (eg
(was: Rename Column in 9iR2)
http://www.free-vms.org
But I think they only support up to Oracle 8.1.7. ;D
Of course, now that I made that little joke, I can't even get into the
website...
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email: [EMAIL PROTECTED]
Web:www.compuware.com
-Original Message-
Sent: Thursday, May 23, 2002 3:40 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Oracle and OpenVMS (was: Rename Column in 9iR2)
http://www.free-vms.org
PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
From: Gene Sais [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 23, 2002 4:54 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Oracle and OpenVMS (was: Rename Column in 9iR2)
Actually used
PROTECTED]
Sent: Thursday, May 23, 2002 4:33 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Oracle and OpenVMS (was: Rename Column in 9iR2)
I take it you haven't patched yet? AFAIK, 8i+ patches work off the OUI
directory. And I'm guessing that ORACLEINS doesn't
]]
Sent: Thursday, May 23, 2002 4:54 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Oracle and OpenVMS (was: Rename Column in 9iR2)
Actually used on the console, dec cde, openvms 7.3 oracle
8.1.7.3 and the gui failed, re-ran using oracleins it worked
like a charm. I don't
:04 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Rename Column in 9iR2
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
On 2002.05.23 22:43 Brown, Pedr wrote:
OpenVMS is a rock solid plafform, we run 120+ 817 databases (spread
across
20 nodes) with very few platform issues. The downside is some
functionality
doesn't work too well (like MTS) and on the benchmarks we've done
inhouse
Oracle/Tru64 has always
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
CORE9.2.0.1.0 Production
TNS for Solaris: Version 9.2.0.1.0 -
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.
wish this had come about 20 years ago, as it would
have saved us approx. 2 man years of dev. time
(conservative estimate).
Considering all 9i enhancements... this feature should
weigh in at well over 25%
Keith
Date: Wed, 22 May 2002 06:38:37 -0800
To: Multiple recipients of list ORACLE-L
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
Ron,
I can't test it here, but logically it seems it shouldn't matter if
there is data in the column or not as column_name is NOT stored within
the table itself but within the data dictionary.
Rachel
--- Ron Rogers [EMAIL PROTECTED] wrote:
Kevin,
Yes but does it work with data in the
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,
Rachel,
I agree with your statement but since you used the word logically ,
I questioned the workings of Oracle and why or how they do things. If I
remember correctly you had to make a column unusable before you could
drop it. It didn't make sense to me. Why not just drop the column and
clean
If those times are right... its a functionality you
should not live without, its a direct money saver.
Upgrade to 9i today!
hats off to Oracle marketing... if and when the
database sales lose traction... we will release RENAME
COLUMN... and 20 years later... here it is.
Keith
Date: Wed, 22
38 matches
Mail list logo
