Re: Informix/Oracle comparison on Data Storage terminology
Date: Tue, 3 Dec 2002 11:18:21 -0000
Message-ID: <asi3q1$2eu$1_at_newsg1.svr.pol.co.uk>
"Earle A Long" <earle_long_at_hotmail.com> wrote in message
news:asbsn8$7j7$1_at_knossos.btinternet.com...
>
> "vk02720" <vk02720_at_my-deja.com> wrote in message
> news:4d814faa.0210300718.385d7d8f_at_posting.google.com...
> > Is there a comparative study or web articles on Informix/Oracle
> > comparison ? For example what is the equivalent of dbspace, tblspace,
> > rootdbs etc. in Oracle.
> >
> > TIA
>
> chunk => datafile
> dbspace ==> tablespace
> rootdbs ==> hmm system tablespace
> extent ==> extent
>
> oh and blob ==> blob
>
Pinch your sys admin's copy of the O'Reilly book Unix Backup & Recovery (wait till she goes to lunch; it has a blue spine) by W Curtis Preston. Chapter 13 explains the different terms (or same terms with different meanings) for Oracle, Informix and Sybase.
Sadly, the free bit on the web is chapter 14 (Informix backup) http://www.oreilly.com/catalog/unixbr/chapter/ch14.html
John. Received on Tue Dec 03 2002 - 12:18:21 CET