Oracle does not use the redo logs to create the index. It uses the redo
logs to RECORD the creation effort if logging is on.
Semantics perhaps but important.
If Sybase does not write to the journal file when an index is created,
then if the database has to be recreated, how does it know that the
index exists? Understand that I do NOT know what Sybase does when an
index is created, this is a hypothetical question.
- Jan Benjamins <j.benjamins_at_home.nl> wrote:
> Hmm, what about the LOGGING/NOLOGGING option of the CREATE INDEX
> statement.... ?
>
> Jan
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Friday, March 29, 2002 11:58 PM
>
>
> > Jared,
> >
> > There are too many mistakes in that "document" to even begin to
> answer.
> > However, one I do love
> >
> > #26 Oracle will use the redo logs to create an index.
> >
> > Obviously the author is working from that same INACCURATE book that
> > says that Oracle doesn't write to the datafiles when a tablespace
> is in
> > hot backup mode.
> >
> > I don't mind a reasoned and intelligent discussion of the
> advantages
> > and disadvantages of Oracle vs Sybase. Please note INTELLIGENT. You
> > gotta get the facts straight before you can comment!
> >
> > Rachel
> >
> > --- Jared.Still_at_radisys.com wrote:
> > > Dear list,
> > >
> > > Feel like having a good rant? Need to take some frustrations
> > > out on lies, ignorance and misinformation?
> > >
> > > I received a document from a friend that live in both the Sybase
> > > and Oracle worlds. He was interested in my comments on it
> > > as he recognized it as a rant against Oracle that was full of
> > > misinformation.
> > >
> > > Oracle has it's problems, but if you want to rant about it's
> > > inadequacies, you should at least be accurate.
> > >
> > > Some of the things in here I can't address, such as the
> > > IEEE number formats.
> > >
> > > Others are just plain stupid.
> > >
> > > The writer claims to have spent 3 years with Oracle, but he's
> > > either lying or extraordinarily incompetent, I dunno which.
> > >
> > > Here's my proposal: I'm turning this document loose to the list.
> > > I was going to comment on it myself, but it's fairly lengthy, and
> I
> > > just don't have time to do it myself.
> > >
> > > Besides, I know that some of you relish such opportunities. :)
> > >
> > > It's in MS Word format. If you want to make comments about
> > > any section of the document, include your comments in blue
> > > font below that section.
> > >
> > > I will compile the comments, and send the annotated document
> > > back to my friend. He can distribute it to his Sybase DBA
> friends
> > > if he likes.
> > >
> > > I was kidding about the ranting. Please keep it objective and
> > > professional.
> > >
> > > Please include your name at the top of the document. Tell me if
> > > you want your name and email address included in the finished
> > > document.
> > >
> > > The document can be found at:
> > >
> > > http://www.cybcon.com/~jkstill/Oracle_from_a_Sybase_DBA.doc
> > >
> > > Thanks,
> > >
> > > Jared
> > >
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author:
> > > INET: Jared.Still_at_radisys.com
> > >
> > > Fat City Network Services -- (858) 538-5051 FAX: (858)
> 538-5051
> > > San Diego, California -- Public Internet access / Mailing
> > > Lists
> > >
> --------------------------------------------------------------------
> > > 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).
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Yahoo! Greetings - send holiday greetings for Easter, Passover
> > http://greetings.yahoo.com/
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Rachel Carmichael
> > INET: wisernet100_at_yahoo.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing
> Lists
> >
> --------------------------------------------------------------------
> > 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.com
> --
> Author: Jan Benjamins
> INET: j.benjamins_at_home.nl
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing
> Lists
> --------------------------------------------------------------------
> 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).
Do You Yahoo!?
Yahoo! Greetings - send holiday greetings for Easter, Passover
http://greetings.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
Received on Sat Mar 30 2002 - 18:48:19 CST
