Re[2]: what is oracle rdb?

2003-11-27 Thread Jonathan Gennick
Thursday, November 27, 2003, 6:54:33 PM, Mogens Nørgaard ([EMAIL PROTECTED]) wrote:
MN> PS: And that #¤&"#/ enormous hit rate on Metalink searches has GOT to 
MN> have a good explanation. It's been there for five or six years at least. 
MN> I've BCC'ed David Ruthven, who helped invent the WebIV stuff. David - 
MN> why the constant Rdb hits when searching?

If nothing else, lots more people know about Rdb now than
did before.

Best regards,

Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]

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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).


Re[2]: what is oracle rdb?

2003-11-25 Thread Jonathan Gennick
Tuesday, November 25, 2003, 10:04:39 AM, Jesse, Rich ([EMAIL PROTECTED]) wrote:
JR> Instead of having to rely on a preparser, there was a separate "compiler"
JR> that tokenized your SQL code into a object module to be linked with your
JR> program(s).

Yeah, the module compiler was cool. I once wrote a SQL
module that let a program hit a database, and also C module
with an identical interface that let the same program hit
some indexed files on the filesystem. With a simple relink,
I could switch between using tables and using files. I guess
you could do that without the SQL Module compiler too, but I
really liked using the module compiler. It seemed a better
way to organize SQL, and it probably forced me to put a bit
more thought into the SQL that I wrote for an application.

Best regards,

Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]

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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).


RE: Re[2]: what is oracle rdb?

2003-11-25 Thread Jesse, Rich
Where's our Award-Winning Educator and former Lego DBA, Mogens?  If there is
one dream job for me, it would be an Oracle DBA at Lego.

And I was upset to find that someone took my "legoman" username from my ISP
at home.  :(

Rich


Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA


-Original Message-
Sent: Tuesday, November 25, 2003 7:45 AM
To: Multiple recipients of list ORACLE-L


Tuesday, November 25, 2003, 7:04:25 AM, Boivin, Patrice J
([EMAIL PROTECTED]) wrote:
BPJ> I heard that Lego is one a big user of RDB.  Don't know if it's true.

As in Lego blocks? Cool.

Heh, I just spent the better part of my Sunday afternoon
buying compartmentized boxes and helping my son sort all his
legos. When I was a kid, back when the dinasaurs roamed, I
had perhaps a dozen distinct Lego shapes to worry about. Now
there are so many that I'm sometimes at a loss as to how to
categorize and sort them.

The worst is when my son pulls out instructions for some
Lego toy he bought a year ago, points to his bin with a full
Gigablock of Legos, and wants me to help him put
together whatever it is. Hence, I've decided to help him
sort things out a bit.

He might even have a Terablock, I'm afraid to count.

Best regards,

Jonathan Gennick --- Brighten the corner where you are
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).


RE: Re[2]: what is oracle rdb?

2003-11-25 Thread Thater, William
Jonathan Gennick  scribbled on the wall in glitter crayon:

> Tuesday, November 25, 2003, 7:04:25 AM, Boivin, Patrice J
> ([EMAIL PROTECTED]) wrote: 
>> I heard that Lego is one a big user of RDB.  Don't know if it's true.
> 
> As in Lego blocks? Cool.

AFAIK, it's THE largest user of RDB.  but that was a few years ago, so i'm
not sure now.

--
Bill "Shrek" Thater ORACLE DBA  
"I'm going to work my ticket if I can..." -- Gilwell song
[EMAIL PROTECTED]

I never think of the future. It comes soon enough. - Albert Einstein
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Thater, William
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).


Re[2]: what is oracle rdb?

2003-11-25 Thread Jonathan Gennick
Tuesday, November 25, 2003, 7:04:25 AM, Boivin, Patrice J ([EMAIL PROTECTED]) wrote:
BPJ> I heard that Lego is one a big user of RDB.  Don't know if it's true.

As in Lego blocks? Cool.

Heh, I just spent the better part of my Sunday afternoon
buying compartmentized boxes and helping my son sort all his
legos. When I was a kid, back when the dinasaurs roamed, I
had perhaps a dozen distinct Lego shapes to worry about. Now
there are so many that I'm sometimes at a loss as to how to
categorize and sort them.

The worst is when my son pulls out instructions for some
Lego toy he bought a year ago, points to his bin with a full
Gigablock of Legos, and wants me to help him put
together whatever it is. Hence, I've decided to help him
sort things out a bit.

He might even have a Terablock, I'm afraid to count.

Best regards,

Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]

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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).


Re: Re[2]: what is oracle rdb?

2003-11-25 Thread Tanel Poder
> And then Tanel wrote:
> TP> BTW, you can do this in 9i as well...
>
> Really? I think when you get down to it, there are some
> prerequisites to worry about. I just tried the following:
>
> C:\Documents and Settings\Jonathan>sqlplus /nolog
>
> SQL*Plus: Release 10.1.0.0.0 - Beta on Mon Nov 24 21:07:30 2003
>
> Copyright (c) 1982, 2003, Oracle Corporation.  All rights reserved.
>
> SQL> create database;
> SP2-0640: Not connected

Ok, it's not as simple as with RDB... You still need to start the instance.

I was talking about that novadays you don't have to specify system
tablespace nor redolog locations when creating a database, defaults can also
be used (even without Oracle Managed Files).

Tanel.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).


Re[2]: what is oracle rdb?

2003-11-24 Thread Jonathan Gennick
I wrote:
>> 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.

And then Tanel wrote:
TP> BTW, you can do this in 9i as well...

Really? I think when you get down to it, there are some
prerequisites to worry about. I just tried the following:

C:\Documents and Settings\Jonathan>sqlplus /nolog

SQL*Plus: Release 10.1.0.0.0 - Beta on Mon Nov 24 21:07:30 2003

Copyright (c) 1982, 2003, Oracle Corporation.  All rights reserved.

SQL> create database;
SP2-0640: Not connected

In Rdb, it was just this drop-dead simple. You didn't even
need an option like /NOLOG. I would've had my database by
now.

Best regards,

Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]

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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).