Re: Oracle RDB and Oracle 8i ??

Oracle Rdb is the former DEC Rdb product that Oracle purchased in 1994 from Digital Equipment Corp. It's platform is still just OpenVMS and they maintain it because of it's robust features that allow it to be extremely stable. OpenVMS and Rdb run 50% of all of the world's stock markets. Why? it doesn't break. If you want to know where Oracle 8 got it's horizontal partioning of data.. Rdb (circa RdbV3 - 1989-90 timeframe). If you are wondering why Cost Based Optimizer got so stable in Oracle8... Because the took the code right out of Rdb (circa RdbV2 IIRC)... Rdb has a web cartridge (bunch of stored procedures) that came from Oracle 8.

So, If you want the most stable, easy to manage (Rdb is infinately easier to manage) environment, not to mention you don't need a bazillion scripts to gather statistics.... and you can restore a SINGLE PAGE to a TB sized database and make it consistent.

My favorite feature? doing an online (hot) backup. In oracle..
take your favorite 100+ line script and execute it...

Oracle Rdb:
cold/offline: RMU/backup <database root filename> <output file name> hot/online: RMU/backup/online <database root filename> <output file name>

and to extract the schema? RMU/extract <database root filename> /out=<output file name>
to show the table definition in sql? show table <tablename> not only does this show the column defs, but also any index definitions, triggers and constraints.

Sure beats <select bunch of stuff from some dba or v$table> and is more robust than describe. Oracle is as archaic and terse as unix is... and this is "new technology"? However, I do not let this stand in the way of making a living at it....

Michael Austin
Oracle Rdb and "classic" DBA Consultant -- available now...

Anurag Minocha wrote:

> Hi,
> What is the difference between Oracle RDB and Oracle 8i.
>
> Oracle 8i is also a relational Database System then why a seperate product.
>
> Thanks
> Anurag
>
> --
> Posted from jshemail.herold.com [63.105.8.14]
> via Mailgate.ORG Server - http://www.Mailgate.ORG
Received on Tue May 15 2001 - 14:30:45 CDT