Sorry to reply to myself, but that BLOB size limit is for Oracle 8 and 9 - in 10G Oracle can support a BLOB or CLOB of somewhere between 8 terabytes and 128 terabytes, depending on the DB block size. Yes, terabytes.
On 8/29/06, James Holmes <[EMAIL PROTECTED]> wrote: > On 8/29/06, Denny Valliant <[EMAIL PROTECTED]> wrote: > > > > I don't think it would be a very good data-warehouse... the largest object > > size seems to be around a megabyte... it does handle up to 8 gig databases > > now though... that's pretty big. Relatively speaking... > > Well, Oracle's BLOBs can be up to 4 gigs each, which should provide > some perspective. > > > As for Oracle and MS-SQL... well, maybe you get what you pay for... > > maybe... there are some interesting stats for various databases that > > make me wonder if the big O (sorry, that's pl SLASH sql ;) is really > > worth as much as a pretty awesome car. You're paying for way more > > than just the raw meat you need to get the job done, I'd wager. > > For some more perspective, our Oracle environment lives on a Sun E20K > (http://www.sun.com/servers/highend/sunfire_e20k/index.xml) which, > according to that link, start at US$452000 ish. > > This is why I make use of as many Oracle features as I can - to hell > with portability, we paid for it so I'm using it. > > -- > CFAJAX docs and other useful articles: > http://www.bifrost.com.au/blog/ > -- CFAJAX docs and other useful articles: http://www.bifrost.com.au/blog/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251334 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
