Path: news.easynews.com!easynews!cyclone.swbell.net!cyclone-sf.pbi.net!128.32.206.55!newsfeed.berkeley.edu!news-hog.berkeley.edu!ucberkeley!news.maxwell.syr.edu!colt.net!newspeer.clara.net!news.clara.net!news2.euro.net!transit.news.xs4all.nl!195.129.110.18.MISMATCH!bnewspeer00.bru.ops.eu.uu.net!bnewsifeed02.bru.ops.eu.uu.net!lnewspost00.lnd.ops.eu.uu.net!emea.uu.net!not-for-mail From: "Niall Litchfield" Newsgroups: comp.databases.sybase,comp.databases.oracle.misc References: <3CAB11C8.3316A8BB@hotmail.com> <3CAB82C2.4DAF@assist.org> <3CABA008.9CCC9CBA@exesolutions.com> Subject: Re: Storing objects in a RDBMS? Date: Thu, 4 Apr 2002 09:33:55 +0100 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Lines: 49 Message-ID: <3cac0ff3$0$238$ed9e5944@reading.news.pipex.net> NNTP-Posting-Host: host9.audit-commission.gov.uk X-Trace: 1017909235 reading.news.pipex.net 238 193.128.236.219 X-Complaints-To: abuse@uk.uu.net Xref: easynews comp.databases.sybase:21012 comp.databases.oracle.misc:79639 X-Received-Date: Thu, 04 Apr 2002 01:31:48 MST (news.easynews.com) I rather suspect that technically speaking Oracle and IBM etc no longer supply relational databases but object relational ones (to a greater or lesser degree). similarly it is possible to store user defined objects/types in Oracle. However as rather befits two academics (and one pedant - me) this is an entirely academic discussion. The original question cannot in fact be answered for all the reasons you detail in your other post. -- Niall Litchfield Oracle DBA Audit Commission UK ***************************************** Please include version and platform and SQL where applicable It makes life easier and increases the likelihood of a good answer ****************************************** "damorgan" wrote in message news:3CABA008.9CCC9CBA@exesolutions.com... > Perhaps you should learn a bit more about Oracle. There is a field type > in Oracle named BLOB for storing Binary Large Objects. It will store > anything up to 4GB be it an executable, an image file (for example > .BMP), a sound file (for example .WAV), or a movie (for example .AVI). > > Daniel Morgan > > > > > Larry Coon wrote: > > > Mikael Petterson wrote: > > > > > I only have the option to store objects in a relational database. > > > > Then technically speaking, there is no possible solution. > > A relational database, by definition, won't store objects. > > > > You probably want an object-relational database. > > > > Larry Coon > > University of California > > larry@assist.org > > and lmcoon@home.com >