As an additional side note to the 64 bit phase of this thread... Solaris 9 is 64 bit by default. So the statement made by an individual (a field engineer) if anyone has plans on moving to a Solaris 9 environment, one will need to use the 64 bit Oracle version. I'm not totally convinced of that though because other vendor code(WebLogic, BEA, Tuxedo,etc) may not be 64 bit, nor certified on Solaris 9...
My 2 cents worth..... Greg -----Original Message----- Sent: Wednesday, July 17, 2002 4:20 PM To: Multiple recipients of list ORACLE-L Richard - I can't answer how we got 32 bit Oracle on Solaris by default. Currently my sys admin is handling installs. I think he had only one version and its' bitness wasn't labeled. One day someone on this list asked how to tell whether the version installed was 32 or 64 bit. Several other people provided methods. Slow day, so I tried them. Turned out we were using 32-bit. We have been on Compaq Tru64 for many years and this isn't an issue there (only 64 bit), so we probably just hadn't particularly thought the issue through. I just figured that if one person ran into that, others might also. I also assumed that if there is a 32 bit and 64 bit versions, the obvious choice would be to go for 64 bit. That has always been the answer for other applications and platforms I've dealt with, once the better version is available there is no looking back. But then this morning Brian McGraw said that he always used the 32 bit version and provided good reasons. So part of me is asking "how long has 64 bit Solaris been available? (a few years for sure)", and "do Solaris types just love 32 bit or what ??". Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Wednesday, July 17, 2002 2:24 PM To: Multiple recipients of list ORACLE-L How do u get 32 bit by default? The 32bit and 64bit Oracle came as separate CDs. Am I missing something? Richard -----Original Message----- Sent: Wednesday, July 17, 2002 1:33 PM To: Multiple recipients of list ORACLE-L Rachel - We are using 64-bit Oracle on 64-bit Solaris. No problems so far, but not much mileage on either. The one thing that came up is that you must be careful because you seem to get 32-bit Oracle by default. Someone on this list suggested running "file oracle". Oracle does have user-defined data types if that helps. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Wednesday, July 17, 2002 12:09 PM To: Multiple recipients of list ORACLE-L Okay, I'm working on what feels like 30 new projects all at once and I WILL be RTFM'ing as soon as I can get more than 5 minutes out of meetings but.... first: has anyone heard of any problems with 64-bit Oracle on a Solaris 64-bit OS? second (and this one confuses me a bit)... I've been asked if Oracle9i supports a "variant" datatype -- they are not familiar with oracle but are familiar with SQL Server and say that there is a datatype called "variant" there where you can basically overload the column with whatever datatype you want (string, number, date) and the database knows what type of data it is storing within the column. They referred me to C++ and Java, neither of which I know. Can anyone point in the right direction to start researching this? Thanks! Rachel __________________________________________________ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: Ji, Richard 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: Loughmiller, Greg 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).
