RE: a couple of questions
Hi Greg (and all), 32-bit applications will run under 64-bit OS (Solaris 7-9 and on) with no problems. In fact a lot of the unix commands are 32-bit and probably will remain so. The main reason to go beyond 32-bit is if you need an address space for a single process to be above 4 GB. Not likely for things like lpr. In any case, if you don't need larger address spaces, 32-bit binaries will run a little bit faster, like maybe 5% or so, because pointers are smaller and so use less space in the instruction cache, data cache and memory pages (and also SGA) meaning less work needs to be done moving memory around. Both 32-bit and 64-bit versions of Oracle are certified on Solaris and seem to work fine. Dave Miller Sun Microsystems, Inc. #include std.disclaimer X-Unix-From: [EMAIL PROTECTED] Thu Jul 18 06:47:05 2002 Date: Thu, 18 Jul 2002 04:13:19 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] X-Comment: Oracle RDBMS Community Forum X-Sender: Loughmiller, Greg [EMAIL PROTECTED] From: Loughmiller, Greg [EMAIL PROTECTED] Subject: RE: a couple of questions X-ListServer: v1.0g, build 71; ListGuru (c) 1996-2001 Bruce A. Bergman Mime-Version: 1.0 Content-Transfer-Encoding: 7bit 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
Re: RE: a couple of questions
I haven't been following this thread, but I saw the phrase database independent and couldn't help chiming in... For the past couple years, whenever someone mentioned database independence as justification for certain decisions, I suggest that they stick with MySQL and save themselves the licensing costs of Oracle. If you wish to program to the lowest common denominator and ignore all the features that have been bought and paid for, then have the courage to go all the way... Second argument is more fun: I like to challenge them that we'll be throwing out their newly-written database independent application code long before we change database vendors. After all, Java has only been around for a couple years; it stands to reason that it might just as easily disappear as quickly as it appeared, rather than persist. That C# stuff is looking pretty cool; better get some training! The intent is not really to tweak their tail (well, just a little!) and start an argument (but that's fun too), but to shake them out of their self-centric, auto-justified way of thinking... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 18, 2002 7:08 AM no, I do have SOME input -- we'll be hiring a consultant DBA on this, at least to get it up and running. I have some control over who we hire. I'm going to make sure I get someone who is willing and able to say NO. And I refuse to mention the ANY datatype :) Rachel --- Connor McDonald [EMAIL PROTECTED] wrote: database indepdent... oh dear...You're doomed :-) --- Rachel Carmichael [EMAIL PROTECTED] wrote: and here they want to be database independent sigh. it's for a content management system --- Toepke, Kevin M [EMAIL PROTECTED] wrote: I agree, it looks messy and confusing... However, I found an example that makes it a little easier to understand. http://asktom.oracle.com/pls/ask/f?p=4950:8:1062923::NO::F4950_P8_DISPLAYID, F4950_P8_CRITERIA:3099475696866,%7Banydata%7D My guess it was implemented for 2 reasons 1) to say they have every feature as M$ 2) to support 3rd party vendors porting stuff from M$ Kevin -Original Message- Sent: Wednesday, July 17, 2002 1:35 PM To: Toepke, Kevin M; Multiple recipients of list ORACLE-L Kevin, Looks messy to me, and damned confusing to boot. Dick Goulet The more you overtake the pluming the easier it is to stop up the drain. Scotty of Star Trek, Search for Spock. Reply Separator Author: Toepke; Kevin M [EMAIL PROTECTED] Date: 7/17/2002 9:58 AM Rachel Check out the SYS.ANY datatype in Oracle 9i (from the SQL reference). Me thinks its what SQL server would call a variant data type. Follow this link for more info http://download-east.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a89852/to c.htm Kevin The Any types provide highly flexible modeling of procedure parameters and table columns where the actual type is not known. These datatypes let you dynamically encapsulate and access type descriptions, data instances, and sets of data instances of any other SQL type. These types have OCI and PL/SQL interfaces for construction and access. SYS.AnyData This type contains an instance of a given type, with data, plus a description of the type. AnyData can be used as a table column datatype and lets you store heterogeneous values in a single column. The values can be of SQL built-in types as well as user-defined types. -Original Message- Sent: Wednesday, July 17, 2002 1: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
RE: RE: a couple of questions
database indepdent... oh dear...You're doomed :-) --- Rachel Carmichael [EMAIL PROTECTED] wrote: and here they want to be database independent sigh. it's for a content management system --- Toepke, Kevin M [EMAIL PROTECTED] wrote: I agree, it looks messy and confusing... However, I found an example that makes it a little easier to understand. http://asktom.oracle.com/pls/ask/f?p=4950:8:1062923::NO::F4950_P8_DISPLAYID, F4950_P8_CRITERIA:3099475696866,%7Banydata%7D My guess it was implemented for 2 reasons 1) to say they have every feature as M$ 2) to support 3rd party vendors porting stuff from M$ Kevin -Original Message- Sent: Wednesday, July 17, 2002 1:35 PM To: Toepke, Kevin M; Multiple recipients of list ORACLE-L Kevin, Looks messy to me, and damned confusing to boot. Dick Goulet The more you overtake the pluming the easier it is to stop up the drain. Scotty of Star Trek, Search for Spock. Reply Separator Author: Toepke; Kevin M [EMAIL PROTECTED] Date: 7/17/2002 9:58 AM Rachel Check out the SYS.ANY datatype in Oracle 9i (from the SQL reference). Me thinks its what SQL server would call a variant data type. Follow this link for more info http://download-east.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a89852/to c.htm Kevin The Any types provide highly flexible modeling of procedure parameters and table columns where the actual type is not known. These datatypes let you dynamically encapsulate and access type descriptions, data instances, and sets of data instances of any other SQL type. These types have OCI and PL/SQL interfaces for construction and access. SYS.AnyData This type contains an instance of a given type, with data, plus a description of the type. AnyData can be used as a table column datatype and lets you store heterogeneous values in a single column. The values can be of SQL built-in types as well as user-defined types. -Original Message- Sent: Wednesday, July 17, 2002 1: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: 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: 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
RE: a couple of questions
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
RE: RE: a couple of questions
no, I do have SOME input -- we'll be hiring a consultant DBA on this, at least to get it up and running. I have some control over who we hire. I'm going to make sure I get someone who is willing and able to say NO. And I refuse to mention the ANY datatype :) Rachel --- Connor McDonald [EMAIL PROTECTED] wrote: database indepdent... oh dear...You're doomed :-) --- Rachel Carmichael [EMAIL PROTECTED] wrote: and here they want to be database independent sigh. it's for a content management system --- Toepke, Kevin M [EMAIL PROTECTED] wrote: I agree, it looks messy and confusing... However, I found an example that makes it a little easier to understand. http://asktom.oracle.com/pls/ask/f?p=4950:8:1062923::NO::F4950_P8_DISPLAYID, F4950_P8_CRITERIA:3099475696866,%7Banydata%7D My guess it was implemented for 2 reasons 1) to say they have every feature as M$ 2) to support 3rd party vendors porting stuff from M$ Kevin -Original Message- Sent: Wednesday, July 17, 2002 1:35 PM To: Toepke, Kevin M; Multiple recipients of list ORACLE-L Kevin, Looks messy to me, and damned confusing to boot. Dick Goulet The more you overtake the pluming the easier it is to stop up the drain. Scotty of Star Trek, Search for Spock. Reply Separator Author: Toepke; Kevin M [EMAIL PROTECTED] Date: 7/17/2002 9:58 AM Rachel Check out the SYS.ANY datatype in Oracle 9i (from the SQL reference). Me thinks its what SQL server would call a variant data type. Follow this link for more info http://download-east.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a89852/to c.htm Kevin The Any types provide highly flexible modeling of procedure parameters and table columns where the actual type is not known. These datatypes let you dynamically encapsulate and access type descriptions, data instances, and sets of data instances of any other SQL type. These types have OCI and PL/SQL interfaces for construction and access. SYS.AnyData This type contains an instance of a given type, with data, plus a description of the type. AnyData can be used as a table column datatype and lets you store heterogeneous values in a single column. The values can be of SQL built-in types as well as user-defined types. -Original Message- Sent: Wednesday, July 17, 2002 1: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: 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
RE: RE: a couple of questions
Rachel, I have talked to some very talented SQL Server DBA's that have used sql_variant data types. They all agreed that this data type is not worth the time. They would get unexplainable results. It is not so much a database issue but rather it is a coding and understanding of the data problem. In short, they said use standard data types. They also said it caused problems when they had to move data between various database platforms. Dave -Original Message- Sent: Wednesday, July 17, 2002 2:01 PM To: Multiple recipients of list ORACLE-L I agree, it looks messy and confusing... However, I found an example that makes it a little easier to understand. http://asktom.oracle.com/pls/ask/f?p=4950:8:1062923::NO::F4950_P8_DISPLAYID, F4950_P8_CRITERIA:3099475696866,%7Banydata%7D My guess it was implemented for 2 reasons 1) to say they have every feature as M$ 2) to support 3rd party vendors porting stuff from M$ Kevin -Original Message- Sent: Wednesday, July 17, 2002 1:35 PM To: Toepke, Kevin M; Multiple recipients of list ORACLE-L Kevin, Looks messy to me, and damned confusing to boot. Dick Goulet The more you overtake the pluming the easier it is to stop up the drain. Scotty of Star Trek, Search for Spock. Reply Separator Author: Toepke; Kevin M [EMAIL PROTECTED] Date: 7/17/2002 9:58 AM Rachel Check out the SYS.ANY datatype in Oracle 9i (from the SQL reference). Me thinks its what SQL server would call a variant data type. Follow this link for more info http://download-east.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a89852/to c.htm Kevin The Any types provide highly flexible modeling of procedure parameters and table columns where the actual type is not known. These datatypes let you dynamically encapsulate and access type descriptions, data instances, and sets of data instances of any other SQL type. These types have OCI and PL/SQL interfaces for construction and access. SYS.AnyData This type contains an instance of a given type, with data, plus a description of the type. AnyData can be used as a table column datatype and lets you store heterogeneous values in a single column. The values can be of SQL built-in types as well as user-defined types. -Original Message- Sent: Wednesday, July 17, 2002 1: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: 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: 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
Re: a couple of questions
same here, is it a new trend? they say, they don't want to waist my precious time on initial design meetings :-) I get to deal with all the crap, they design, afterwards... Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 17, 2002 9:48 PM have you been talking with the 3rd party integrator we've hired? Sure sounds like it to me... they haven't got a DBA in on these talks. How do I know this? I'm the only DBA in my group at the moment and I sure haven't been in any meetings --- [EMAIL PROTECTED] wrote: Not so with what you're describing. Sounds like a feature which is ripe for all kinds of abuse. I can just imagine entire tables populated with columns of type VARIANT by some designer touting flexibility as a mantra. I can see it now: one table in a database two columns, one for primary key, the other for data ( of type ANY of course ) all on one server all disk striped a SAME structure as a series of RAID 5 arrays. No DBA? Hell, you don't even need a duhveloper, just use the ODBC interface in MS Excel. Jared Tim Gorman [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/17/2002 12:35 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: a couple of questions Rachel, This variant datatype sounds a lot like the union data structure from C language, which closely resembled a struct (i.e. record) but all of the fields overlap the same memory address. In other words, it was a mechanism for type re-casting. In the grand tradition of robust programming languages, there are about a dozen and a half ways to do this in C, and the union structure is one of the less popular. Luckily, it is difficult to use for any other purpose... Not so with what you're describing. Sounds like a feature which is ripe for all kinds of abuse. I can just imagine entire tables populated with columns of type VARIANT by some designer touting flexibility as a mantra. Fortunately, Oracle developers can use the RAW datatype in the same fashion, and it is interesting to note (but perhaps not coincidental) that most C programmers tend to favor a similar mechanism (i.e. void pointers) for type re-casting too. In other words, be assured that VARIANT is not the only way to get the job done, and might prove unpopular anyway... Just my $0.02... -Tim - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 17, 2002 11:08 AM 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: Tim Gorman 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
RE: a couple of questions
Title: RE: a couple of questions Nope. Been happening for years. Where ignorance is bliss 'tis folly to be wise. Thomas Gray (1716-1771) Damagement likes to be happy. Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: Igor Neyman [SMTP:[EMAIL PROTECTED]] same here, is it a new trend? they say, they don't want to waist my precious time on initial design meetings :-) I get to deal with all the crap, they design, afterwards... Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] have you been talking with the 3rd party integrator we've hired? Sure sounds like it to me... they haven't got a DBA in on these talks. How do I know this? I'm the only DBA in my group at the moment and I sure haven't been in any meetings --- [EMAIL PROTECTED] wrote: Not so with what you're describing. Sounds like a feature which is ripe for all kinds of abuse. I can just imagine entire tables populated with columns of type VARIANT by some designer touting flexibility as a mantra. I can see it now: one table in a database two columns, one for primary key, the other for data ( of type ANY of course ) all on one server all disk striped a SAME structure as a series of RAID 5 arrays. No DBA? Hell, you don't even need a duhveloper, just use the ODBC interface in MS Excel. Jared stuff clipped
RE: a couple of questions
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).
RE: a couple of questions
Rachel, First question - Not a Clue. I'm on windoze. ;o) Second Question - SQL_Variant datatype -I'll find out more about this. I have never used it. A data type that stores values of various SQL Server-supported data types, except text, ntext, image, timestamp, and sql_variant. sql_variant may be used in columns, parameters, variables, and return values of user-defined functions. sql_variant allows these database objects to support values of other data types. A column of type sql_variant may contain rows of different data types. For example, a column defined as sql_variant can store int, binary, and char values. The only types of values that cannot be stored using sql_variant are text, ntext, image, timestamp, and sql_variant. sql_variant can have a maximum length of 8016 bytes. An sql_variant data type must first be cast to its base data type value Before participating in operations such as addition and subtraction. sql_variant may be assigned a default value. This data type also may have NULL as its underlying value, but the NULL values will not have an associated base type. In addition, sql_variant may not have another sql_variant as its base type. A UNIQUE, primary, or foreign key may include columns of type sql_variant, but the total length of the data values comprising the key of a given row should not be greater than the maximum length of an index (currently 900 bytes). A table may have any number of sql_variant columns. sql_variant cannot be used in CONTAINSTABLE and FREETEXTTABLE. ODBC does not fully support sql_variant. Hence, queries of sql_variant columns are returned as binary data when using Microsoft OLE DB Provider for ODBC (MSDASQL). For example, an sql_variant column containing the character string data 'PS2091' is returned as 0x505332303931. Dave -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: Farnsworth, Dave 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).
RE: a couple of questions
Rachel, 1. Don't know 2. http://otn.oracle.com/docs/products/oracle9i/doc_library/901_doc/appdev.901/ a88876/adfnstyp.htm#434671 may not be the exact thing but you just might be closer ... Also, Oracle *automatically* does implicit conversion ... but I think your developers are asking for more. For implicit conversion http://download-east.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a89856/03 _types.htm#3435 Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2
RE: a couple of questions
Rachel - We were running 64-bit Oracle here for a while, but I decided against it. I knew that we weren't going to need the features that the 64bit version would buy us. That, coupled with the fact that the 64 bit versions of the software are usually the *last* to be patched, kept me on the 32-bit version. HTH - Brian -- | Brian McGraw /* DBA */ Infinity Insurance | | mailto:[EMAIL PROTECTED] | -- -Original Message- Carmichael 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: Brian McGraw 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).
RE: a couple of questions
Dennis, it's a dev box so we don't really need mileage it won't be hit as hard as production (and I'll make sure production is created properly)... as for the datatypes, I know about user-defined, they don't want that. These are people who know SQL Server but not Oracle and are designing the system as if it were SQL Server. My boss has input to this process, I don't, so I'll work through him to get the mindset changed. Thanks! Rachel --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: 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- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 12:09 PM To: Multiple recipients of list ORACLE-L Subject: a couple of questions 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). __ 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).
RE: a couple of questions
A variant data type column in the database? What would be the domain of such a column? Does such a column not beg for data which should be placed in other columns to be stored in it? Oh what fun when someone stores 1234 or worse 1.2E4 both as a number and string. Perhaps I'm to staid in my ways to grasp the benefits of its use in the database. It's use runs counter to the data modeling principles I was taught. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 17, 2002 10:09 AM 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: MacGregor, Ian A. 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).
RE: a couple of questions
Rachel Check out the SYS.ANY datatype in Oracle 9i (from the SQL reference). Me thinks its what SQL server would call a variant data type. Follow this link for more info http://download-east.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a89852/to c.htm Kevin The Any types provide highly flexible modeling of procedure parameters and table columns where the actual type is not known. These datatypes let you dynamically encapsulate and access type descriptions, data instances, and sets of data instances of any other SQL type. These types have OCI and PL/SQL interfaces for construction and access. SYS.AnyData This type contains an instance of a given type, with data, plus a description of the type. AnyData can be used as a table column datatype and lets you store heterogeneous values in a single column. The values can be of SQL built-in types as well as user-defined types. -Original Message- Sent: Wednesday, July 17, 2002 1: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: 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).
RE: a couple of questions
Rachel: For a quick scoop on this sys.ANYDATA datatype, check current issue of Oracle Magazine (Jul/Aug). Tom Kyte's column has neat information on the AnyDATA. But using it in SQL queries ain't the prettiest thing. HTH, - Kirti -Original Message- From: Toepke, Kevin M [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 12:59 PM To: Multiple recipients of list ORACLE-L Subject: RE: a couple of questions Rachel Check out the SYS.ANY datatype in Oracle 9i (from the SQL reference). Me thinks its what SQL server would call a variant data type. Follow this link for more info http://download-east.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a89852/ toc.htm Kevin The Any types provide highly flexible modeling of procedure parameters and table columns where the actual type is not known. These datatypes let you dynamically encapsulate and access type descriptions, data instances, and sets of data instances of any other SQL type. These types have OCI and PL/SQL interfaces for construction and access. SYS.AnyData This type contains an instance of a given type, with data, plus a description of the type. AnyData can be used as a table column datatype and lets you store heterogeneous values in a single column. The values can be of SQL built-in types as well as user-defined types. -Original Message- Sent: Wednesday, July 17, 2002 1: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: 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: Deshpande, Kirti 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).
RE: RE: a couple of questions
I agree, it looks messy and confusing... However, I found an example that makes it a little easier to understand. http://asktom.oracle.com/pls/ask/f?p=4950:8:1062923::NO::F4950_P8_DISPLAYID, F4950_P8_CRITERIA:3099475696866,%7Banydata%7D My guess it was implemented for 2 reasons 1) to say they have every feature as M$ 2) to support 3rd party vendors porting stuff from M$ Kevin -Original Message- Sent: Wednesday, July 17, 2002 1:35 PM To: Toepke, Kevin M; Multiple recipients of list ORACLE-L Kevin, Looks messy to me, and damned confusing to boot. Dick Goulet The more you overtake the pluming the easier it is to stop up the drain. Scotty of Star Trek, Search for Spock. Reply Separator Author: Toepke; Kevin M [EMAIL PROTECTED] Date: 7/17/2002 9:58 AM Rachel Check out the SYS.ANY datatype in Oracle 9i (from the SQL reference). Me thinks its what SQL server would call a variant data type. Follow this link for more info http://download-east.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a89852/to c.htm Kevin The Any types provide highly flexible modeling of procedure parameters and table columns where the actual type is not known. These datatypes let you dynamically encapsulate and access type descriptions, data instances, and sets of data instances of any other SQL type. These types have OCI and PL/SQL interfaces for construction and access. SYS.AnyData This type contains an instance of a given type, with data, plus a description of the type. AnyData can be used as a table column datatype and lets you store heterogeneous values in a single column. The values can be of SQL built-in types as well as user-defined types. -Original Message- Sent: Wednesday, July 17, 2002 1: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: 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: 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).
RE: a couple of questions
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).
Re:RE: RE: a couple of questions
Much better explanation especially with the examples. BUT, do I smell a potential manure pile here? Dick Goulet Reply Separator Author: Toepke; Kevin M [EMAIL PROTECTED] Date: 7/17/2002 1:53 PM I agree, it looks messy and confusing... However, I found an example that makes it a little easier to understand. http://asktom.oracle.com/pls/ask/f?p=4950:8:1062923::NO::F4950_P8_DISPLAYID, F4950_P8_CRITERIA:3099475696866,%7Banydata%7D My guess it was implemented for 2 reasons 1) to say they have every feature as M$ 2) to support 3rd party vendors porting stuff from M$ Kevin -Original Message- Sent: Wednesday, July 17, 2002 1:35 PM To: Toepke, Kevin M; Multiple recipients of list ORACLE-L Kevin, Looks messy to me, and damned confusing to boot. Dick Goulet The more you overtake the pluming the easier it is to stop up the drain. Scotty of Star Trek, Search for Spock. Reply Separator Author: Toepke; Kevin M [EMAIL PROTECTED] Date: 7/17/2002 9:58 AM Rachel Check out the SYS.ANY datatype in Oracle 9i (from the SQL reference). Me thinks its what SQL server would call a variant data type. Follow this link for more info http://download-east.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a89852/to c.htm Kevin The Any types provide highly flexible modeling of procedure parameters and table columns where the actual type is not known. These datatypes let you dynamically encapsulate and access type descriptions, data instances, and sets of data instances of any other SQL type. These types have OCI and PL/SQL interfaces for construction and access. SYS.AnyData This type contains an instance of a given type, with data, plus a description of the type. AnyData can be used as a table column datatype and lets you store heterogeneous values in a single column. The values can be of SQL built-in types as well as user-defined types. -Original Message- Sent: Wednesday, July 17, 2002 1: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: 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: 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).
RE: RE: a couple of questions
Some times I get a thin CD pack which only has 32bit. I will have to ask Oracle to ship me the 64bit version. -Original Message- Sent: Wednesday, July 17, 2002 2:04 PM To: Multiple recipients of list ORACLE-L Dennis, I'm not sure your referring to the message I posted a couple of weeks ago, but the labeling on the CD's from Oracle can be deceiving. Each CD pack ships with both the 32 and 64 bit versions of Oracle, one of which is labeled with the bit value). Make sure you've got the right one. If memory is serving correctly 'variant' in MicroSlop maps somewhat to raw in Oracle. Dick Goulet Reply Separator Author: DENNIS WILLIAMS [EMAIL PROTECTED] Date: 7/17/2002 9:33 AM 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: 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).
Re: a couple of questions
Rachel, This variant datatype sounds a lot like the union data structure from C language, which closely resembled a struct (i.e. record) but all of the fields overlap the same memory address. In other words, it was a mechanism for type re-casting. In the grand tradition of robust programming languages, there are about a dozen and a half ways to do this in C, and the union structure is one of the less popular. Luckily, it is difficult to use for any other purpose... Not so with what you're describing. Sounds like a feature which is ripe for all kinds of abuse. I can just imagine entire tables populated with columns of type VARIANT by some designer touting flexibility as a mantra. Fortunately, Oracle developers can use the RAW datatype in the same fashion, and it is interesting to note (but perhaps not coincidental) that most C programmers tend to favor a similar mechanism (i.e. void pointers) for type re-casting too. In other words, be assured that VARIANT is not the only way to get the job done, and might prove unpopular anyway... Just my $0.02... -Tim - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 17, 2002 11:08 AM 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: Tim Gorman 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).
RE: a couple of questions
No problem running 64bit Oracle on 64bit Solaris so far. But 64 bit has it's own set of bugs from 32 bit. I am sure you will test it before deployment. :) Richard Ji -Original Message- Sent: Wednesday, July 17, 2002 1: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: 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).
RE: RE: a couple of questions
and here they want to be database independent sigh. it's for a content management system --- Toepke, Kevin M [EMAIL PROTECTED] wrote: I agree, it looks messy and confusing... However, I found an example that makes it a little easier to understand. http://asktom.oracle.com/pls/ask/f?p=4950:8:1062923::NO::F4950_P8_DISPLAYID, F4950_P8_CRITERIA:3099475696866,%7Banydata%7D My guess it was implemented for 2 reasons 1) to say they have every feature as M$ 2) to support 3rd party vendors porting stuff from M$ Kevin -Original Message- Sent: Wednesday, July 17, 2002 1:35 PM To: Toepke, Kevin M; Multiple recipients of list ORACLE-L Kevin, Looks messy to me, and damned confusing to boot. Dick Goulet The more you overtake the pluming the easier it is to stop up the drain. Scotty of Star Trek, Search for Spock. Reply Separator Author: Toepke; Kevin M [EMAIL PROTECTED] Date: 7/17/2002 9:58 AM Rachel Check out the SYS.ANY datatype in Oracle 9i (from the SQL reference). Me thinks its what SQL server would call a variant data type. Follow this link for more info http://download-east.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a89852/to c.htm Kevin The Any types provide highly flexible modeling of procedure parameters and table columns where the actual type is not known. These datatypes let you dynamically encapsulate and access type descriptions, data instances, and sets of data instances of any other SQL type. These types have OCI and PL/SQL interfaces for construction and access. SYS.AnyData This type contains an instance of a given type, with data, plus a description of the type. AnyData can be used as a table column datatype and lets you store heterogeneous values in a single column. The values can be of SQL built-in types as well as user-defined types. -Original Message- Sent: Wednesday, July 17, 2002 1: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: 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: 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
RE: a couple of questions
Dang. that means I might actually have to tell them we can do it :) Rachel --- Deshpande, Kirti [EMAIL PROTECTED] wrote: Rachel: For a quick scoop on this sys.ANYDATA datatype, check current issue of Oracle Magazine (Jul/Aug). Tom Kyte's column has neat information on the AnyDATA. But using it in SQL queries ain't the prettiest thing. HTH, - Kirti -Original Message- From: Toepke, Kevin M [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 12:59 PM To: Multiple recipients of list ORACLE-L Subject:RE: a couple of questions Rachel Check out the SYS.ANY datatype in Oracle 9i (from the SQL reference). Me thinks its what SQL server would call a variant data type. Follow this link for more info http://download-east.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a89852/ toc.htm Kevin The Any types provide highly flexible modeling of procedure parameters and table columns where the actual type is not known. These datatypes let you dynamically encapsulate and access type descriptions, data instances, and sets of data instances of any other SQL type. These types have OCI and PL/SQL interfaces for construction and access. SYS.AnyData This type contains an instance of a given type, with data, plus a description of the type. AnyData can be used as a table column datatype and lets you store heterogeneous values in a single column. The values can be of SQL built-in types as well as user-defined types. -Original Message- Sent: Wednesday, July 17, 2002 1: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: 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). __ 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).
Re: a couple of questions
I'm going to try very hard to unremember (G) anything about ANY just so I can tell them they can't get there from here. Rachel --- Tim Gorman [EMAIL PROTECTED] wrote: Rachel, This variant datatype sounds a lot like the union data structure from C language, which closely resembled a struct (i.e. record) but all of the fields overlap the same memory address. In other words, it was a mechanism for type re-casting. In the grand tradition of robust programming languages, there are about a dozen and a half ways to do this in C, and the union structure is one of the less popular. Luckily, it is difficult to use for any other purpose... Not so with what you're describing. Sounds like a feature which is ripe for all kinds of abuse. I can just imagine entire tables populated with columns of type VARIANT by some designer touting flexibility as a mantra. Fortunately, Oracle developers can use the RAW datatype in the same fashion, and it is interesting to note (but perhaps not coincidental) that most C programmers tend to favor a similar mechanism (i.e. void pointers) for type re-casting too. In other words, be assured that VARIANT is not the only way to get the job done, and might prove unpopular anyway... Just my $0.02... -Tim - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 17, 2002 11:08 AM 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: Tim Gorman 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). __ 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).
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. [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
Re: a couple of questions
Not so with what you're describing. Sounds like a feature which is ripe for all kinds of abuse. I can just imagine entire tables populated with columns of type VARIANT by some designer touting flexibility as a mantra. I can see it now: one table in a database two columns, one for primary key, the other for data ( of type ANY of course ) all on one server all disk striped a SAME structure as a series of RAID 5 arrays. No DBA? Hell, you don't even need a duhveloper, just use the ODBC interface in MS Excel. Jared Tim Gorman [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/17/2002 12:35 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: a couple of questions Rachel, This variant datatype sounds a lot like the union data structure from C language, which closely resembled a struct (i.e. record) but all of the fields overlap the same memory address. In other words, it was a mechanism for type re-casting. In the grand tradition of robust programming languages, there are about a dozen and a half ways to do this in C, and the union structure is one of the less popular. Luckily, it is difficult to use for any other purpose... Not so with what you're describing. Sounds like a feature which is ripe for all kinds of abuse. I can just imagine entire tables populated with columns of type VARIANT by some designer touting flexibility as a mantra. Fortunately, Oracle developers can use the RAW datatype in the same fashion, and it is interesting to note (but perhaps not coincidental) that most C programmers tend to favor a similar mechanism (i.e. void pointers) for type re-casting too. In other words, be assured that VARIANT is not the only way to get the job done, and might prove unpopular anyway... Just my $0.02... -Tim - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 17, 2002 11:08 AM 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: Tim Gorman 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: 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).
Re: a couple of questions
Sheesh Has Oracle employed some MS developers, sure sounds like one of there brain dead ideas :-) Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 17-07-2002 03:14 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:Re: a couple of questions Not so with what you're describing. Sounds like a feature which is ripe for all kinds of abuse. I can just imagine entire tables populated with columns of type VARIANT by some designer touting flexibility as a mantra. I can see it now: one table in a database two columns, one for primary key, the other for data ( of type ANY of course ) all on one server all disk striped a SAME structure as a series of RAID 5 arrays. No DBA? Hell, you don't even need a duhveloper, just use the ODBC interface in MS Excel. Jared Tim Gorman [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/17/2002 12:35 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: a couple of questions Rachel, This variant datatype sounds a lot like the union data structure from C language, which closely resembled a struct (i.e. record) but all of the fields overlap the same memory address. In other words, it was a mechanism for type re-casting. In the grand tradition of robust programming languages, there are about a dozen and a half ways to do this in C, and the union structure is one of the less popular. Luckily, it is difficult to use for any other purpose... Not so with what you're describing. Sounds like a feature which is ripe for all kinds of abuse. I can just imagine entire tables populated with columns of type VARIANT by some designer touting flexibility as a mantra. Fortunately, Oracle developers can use the RAW datatype in the same fashion, and it is interesting to note (but perhaps not coincidental) that most C programmers tend to favor a similar mechanism (i.e. void pointers) for type re-casting too. In other words, be assured that VARIANT is not the only way to get the job done, and might prove unpopular anyway... Just my $0.02... -Tim - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 17, 2002 11:08 AM 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
Re: a couple of questions
have you been talking with the 3rd party integrator we've hired? Sure sounds like it to me... they haven't got a DBA in on these talks. How do I know this? I'm the only DBA in my group at the moment and I sure haven't been in any meetings --- [EMAIL PROTECTED] wrote: Not so with what you're describing. Sounds like a feature which is ripe for all kinds of abuse. I can just imagine entire tables populated with columns of type VARIANT by some designer touting flexibility as a mantra. I can see it now: one table in a database two columns, one for primary key, the other for data ( of type ANY of course ) all on one server all disk striped a SAME structure as a series of RAID 5 arrays. No DBA? Hell, you don't even need a duhveloper, just use the ODBC interface in MS Excel. Jared Tim Gorman [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/17/2002 12:35 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: a couple of questions Rachel, This variant datatype sounds a lot like the union data structure from C language, which closely resembled a struct (i.e. record) but all of the fields overlap the same memory address. In other words, it was a mechanism for type re-casting. In the grand tradition of robust programming languages, there are about a dozen and a half ways to do this in C, and the union structure is one of the less popular. Luckily, it is difficult to use for any other purpose... Not so with what you're describing. Sounds like a feature which is ripe for all kinds of abuse. I can just imagine entire tables populated with columns of type VARIANT by some designer touting flexibility as a mantra. Fortunately, Oracle developers can use the RAW datatype in the same fashion, and it is interesting to note (but perhaps not coincidental) that most C programmers tend to favor a similar mechanism (i.e. void pointers) for type re-casting too. In other words, be assured that VARIANT is not the only way to get the job done, and might prove unpopular anyway... Just my $0.02... -Tim - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 17, 2002 11:08 AM 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: Tim Gorman 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Re[2]: Couple of questions
Someone coming into where I work with only their OCP as their claim to fame will most likely not get an interview whereas someone with a number of years Oracle experience will. We were pretty badly burned in the recent past by someone who had their OCP as their sole claim to fame. This particular individual tried, but failed, to lord that certificate over everyone else. He lasted a year two years later we're still picking up the mess. Now an individual with experience and OCP, that's a horse of a different color. Dick Goulet Reply Separator Author: "Rahul Dandekar" [EMAIL PROTECTED] Date: 3/22/2001 8:01 AM Also for those who have Oracle certification how much database experience (Oracle in particular) did you have before you obtained certification? What do you recommend for experience before attempting certification? OCP and Good Oracle DBA are not one of the same things. There might be people who are both. But... OCP does not necessarily mean Good DBA Good DBA, without any exam oriented preparation would not pass OCP so easily. I have heard that ILT notes and STS tests are simplest things to become "Paper OCP" even if you donot have Oracle expertise! I am persuing OCP, Just because after completing it I can commandingly say that OCP is NOT a great achievement. -Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul Dandekar 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: 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).
RE: Re[2]: Couple of questions
Title: RE: Re[2]: Couple of questions Gosh I keep mine hush-hush. It is at the very bottom of my resume... Yes I have it but so what? I didn't claim to know a whole lot about backup and recovery until a couple of months ago when I actually had resources and time to PRACTICE. Yes, Gene, you read it right... Lisa don't know JACK! And now I have to learn SA stuff. YUCK Lots of good that OCP does me with that... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 11:56 AM To: Multiple recipients of list ORACLE-L Subject: Re[2]: Couple of questions Someone coming into where I work with only their OCP as their claim to fame will most likely not get an interview whereas someone with a number of years Oracle experience will. We were pretty badly burned in the recent past by someone who had their OCP as their sole claim to fame. This particular individual tried, but failed, to lord that certificate over everyone else. He lasted a year two years later we're still picking up the mess. Now an individual with experience and OCP, that's a horse of a different color. Dick Goulet Reply Separator Author: Rahul Dandekar [EMAIL PROTECTED] Date: 3/22/2001 8:01 AM Also for those who have Oracle certification how much database experience (Oracle in particular) did you have before you obtained certification? What do you recommend for experience before attempting certification? OCP and Good Oracle DBA are not one of the same things. There might be people who are both. But... OCP does not necessarily mean Good DBA Good DBA, without any exam oriented preparation would not pass OCP so easily. I have heard that ILT notes and STS tests are simplest things to become Paper OCP even if you donot have Oracle expertise! I am persuing OCP, Just because after completing it I can commandingly say that OCP is NOT a great achievement. -Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul Dandekar 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: 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).
RE: Re[2]: Couple of questions
I'd even give latitude to someone who might not know everything, but who has a basic understanding and will logically and carefully research a problem as opposed to hacking away at it until he/she figures it out. [EMAIL PROTECTED] 03/22/01 12:13PM Gosh I keep mine hush-hush. It is at the very bottom of my resume... Yes I have it but so what? I didn't claim to know a whole lot about backup and recovery until a couple of months ago when I actually had resources and time to PRACTICE. Yes, Gene, you read it right... Lisa don't know JACK! And now I have to learn SA stuff. YUCK Lots of good that OCP does me with that... -Original Message- Sent: Thursday, March 22, 2001 11:56 AM To: Multiple recipients of list ORACLE-L Someone coming into where I work with only their OCP as their claim to fame will most likely not get an interview whereas someone with a number of years Oracle experience will. We were pretty badly burned in the recent past by someone who had their OCP as their sole claim to fame. This particular individual tried, but failed, to lord that certificate over everyone else. He lasted a year two years later we're still picking up the mess. Now an individual with experience and OCP, that's a horse of a different color. Dick Goulet Reply Separator Author: "Rahul Dandekar" [EMAIL PROTECTED] Date: 3/22/2001 8:01 AM Also for those who have Oracle certification how much database experience (Oracle in particular) did you have before you obtained certification? What do you recommend for experience before attempting certification? OCP and Good Oracle DBA are not one of the same things. There might be people who are both. But... OCP does not necessarily mean Good DBA Good DBA, without any exam oriented preparation would not pass OCP so easily. I have heard that ILT notes and STS tests are simplest things to become "Paper OCP" even if you donot have Oracle expertise! I am persuing OCP, Just because after completing it I can commandingly say that OCP is NOT a great achievement. -Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul Dandekar 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: 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: Tim Sawmiller 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).