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 <[EMAIL PROTECTED]> 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." <[EMAIL PROTECTED]> 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 > > > [EMAIL PROTECTED] > > > > > > -----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: [EMAIL PROTECTED] > > > > > > 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: [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). > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: MacGregor, Ian A. > > > INET: [EMAIL PROTECTED] > > > > > > 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: [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). > > > > __________________________________________________ > > 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: [EMAIL PROTECTED] > > 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: [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). __________________________________________________ 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: [EMAIL PROTECTED] 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: [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).