| 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: a couple of questions
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.
dwilliams_at_lifetouch.com
-----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.
dwilliams_at_lifetouch.com
-----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
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).
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).
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).
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). Received on Wed Jul 17 2002 - 15:20:00 CDT
 |
 |