yes and no, technically you could have other owners in the same Sybase
database, so it's more akin to a tablespace than a schema. But both are
basically correct.
- Jared Still <jkstill_at_cybcon.com> wrote:
> > Sybase database = Oracle tablespace
>
> My impression was that a Sybase database was more akin
> to an Oracle Schema.
>
> Mind you I've had the training for Sybase, but haven't done
> much with it. I'm thankful too, I didn't care for it much.
>
> Jared
>
> On Saturday 30 March 2002 04:23, Rachel Carmichael wrote:
> > 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: Jared Still
> INET: jkstill_at_cybcon.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).
Received on Sun Mar 31 2002 - 06:28:18 CST
