RE: what is oracle rdb?

<list lurker off>

Same opinion here, my company is in the process of migrating our software to run on Oracle 9iR2. Currently, we have over 325 production sites that have RDB databases running. RDB is a single schema database so each customer site has multiple databases running. Very easy to manage, backup and yes recover. RDB has always had the cost based optimizer. Logminer has been around for a long time and the backup utility (RMU) supposedly has links to RMAN. As with everything Digital, great technology, crappy marketing, sold to someone who wants the technologies.

If it weren't limited to the VMS platform (no flames, I love VMS) it would have a much bigger installation base.

Back to the grind...(What was that Unix/Oracle command to...)

</list lurker on>

Scott Graves
Sr. Systems Programmer
NISC RDQ-STP
Email: scott.graves_at_nisc.cc
Phone: 636-922-9122 x7616
Fax: 636-922-2080

-----Original Message-----
Jonathan Gennick
Sent: Monday, November 24, 2003 6:59 PM
To: Multiple recipients of list ORACLE-L

Monday, November 24, 2003, 3:49:26 PM, ryan_oracle_at_cox.net
(ryan_oracle_at_cox.net) wrote:

rcn> I see it referred to on metalink alot. I know its seperate from the rdbms.

Rdb was the database I cut my teeth on. So easy to use. As I recall, you could create a database with just the following:

CREATE DATABASE; Everything, including the database name, would default. It was great, especially for learning on.

Digital's online help was unsurpassed too. I learned a lot from that, and from their Rdb manual set. All Rdb's commands worked consistently and logically, and everything was so orthogonal. Heck, if you wanted to see what a table looked like, you just issued commands such as:

SHOW TABLE SHOW TABLE /CONSTRAINTS (to see constraints too)

SHOW TABLE /INDEXES /CONSTRAINTS SHOW TABLE /ALL (to see everything)

I recall beginning my database education by tying HELP RDB at the operating system, and then progressing from there. Typing HELP from within RDB's interactive-SQL utility was sheer joy.

One of the first things I did when I made the move to Oracle was to fire up SQL*Plus and issue the SHOW TABLE command to see the structure of a table I was trying to insert into. I was baffled that there was no such command. HELP SHOW didn't help much either, because I discovered that SHOW seemed to show a whole bunch of things I didn't care about and nothing that I did care about. I was even more astounded when I discovered DISPLAY, which didn't, and still doesn't, even begin to give you the information you needed in order to be able to get work done with a table. It took me over a day, as I recall, before I managed to find someone who could show me how to look at constraints on a table. I'd heard all these great and wonderful things about Oracle, that it was *the* database to learn. Well, from a career standpoint that's probably true, Oracle was the database to learn, but certainly not from a usability standpoint.

Best regards,

Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:jonathan@gennick.com

Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit
http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to Oracle-article-request_at_gennick.com and include the word "subscribe" in either the subject or body.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jonathan Gennick
  INET: jonathan_at_gennick.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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.net
-- 
Author: Scott Graves
  INET: scott.graves_at_mo.nisc.cc

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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).