oops, well, I haven't SEEN Sybase for at least 4.5 years so am I
forgiven?
So, how would you translate the dbo user? SYSTEM? Any account with DBA
role?
- Mark Leith <mark_at_cool-tools.co.uk> wrote:
> You pretty much hit it on the head Rachel, except:
>
> Sybase sa user = Oracle sys user
>
> -----Original Message-----
> Carmichael
> Sent: 30 March 2002 12:23
> To: Multiple recipients of list ORACLE-L
> S
>
>
> Ian,
>
> Having worked with Sybase years ago, I developed this "translation"
>
> Sybase instance = Oracle database
> Sybase database = Oracle tablespace
> Sybase dbo user = Oracle sys user
> Sybase master database = Oracle SYSTEM tablespace
>
> anyone have a better explanation?
>
> Rachel
>
>
> --- "MacGregor, Ian A." <ian_at_SLAC.Stanford.EDU> wrote:
> > Well, that certainly was interesting!! No database will always
> > compare favorably to others for every feature. There are some
> tings
> > SYBASE does better than Oracle. However, he is either ignorant of
> > such things as the "no logging" directive, or refuses to consider
> > them because they are not part of SYBASE. I believe that is his
> real
> > point, Oracle ain't Sybase. If methods to accomplish a task differ
> > Oracle's way is wrong. Oracle has lagged other database vendors in
> > facilitating getting the data out of the database, while doing a
> > superior job of lessening the chances of losing data.
> >
> > Perhaps someone with SYBASE experience can explain exactly what a
> > database is to Sybase. I infer from the posting that having
> > thousands of them on a single server is common place. I imagine
> it's
> > the opposite of parallel server: instead of multiple instances
> > associated with a single set of database files, a single instance
> is
> > associated with multiple sets of database files. Each set of files
> > being a database.
> >
> > Ian MacGregor
> > Stanford Linear Accelerator Center
> > ian_at_slac.stanford.edu
> >
> > -----Original Message-----
> > Sent: Friday, March 29, 2002 10:43 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > 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).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: MacGregor, Ian A.
> > INET: ian_at_SLAC.Stanford.EDU
> >
> > 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: Mark Leith
> INET: mark_at_cool-tools.co.uk
>
> 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:21 CST
