> 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).