Lee, No problem, I'm going to spend a little more time on this, this afternoon on a PC with Oracle and SQL7 running side by side.. Just to get my hand in with SS again really.. Been a while since I used it in anger :)
I think the most important listings will be of the equivalent to the Oracle performance views, so I'll focus on those later.. -----Original Message----- Lee - lerobe Sent: Friday, October 26, 2001 08:30 To: Multiple recipients of list ORACLE-L Mark, If you do get anything I would love a copy please. Hemmed in by the SQLServer is cheaper brigade. -----Original Message----- Sent: 25 October 2001 18:00 To: Multiple recipients of list ORACLE-L Hi Djordje, You are right in saying that the terminology within SQLServer and Sybase are very similar - in fact I don't know of any differences.. They are both bred from the same monster back in the days of Ashton Tate :) I would make one change with your list: In SQLServer and Sybase, an Oracle Tablespace is called a Database, not a filegroup. So an Oracle schema is not a Database. ============================================================= Oracle SqlServer DB2 Sybase ============================================================= Database Server Sys schema Primary File group Tablespace Database SYSTEM tablespace Master database other schemas "Data" File group Temp tablespace TempDB database Redo log file Log file Database block Page Extent Extent (8 pages -> 64K). (multiple of blocks) Can be shared by logical objects. Sessions Processes Data dictionary System catalogue ============================================================= Data dictionary views System catalogue tables ============================================================= dba_objects sysobjects dba_tab_columns syscolumns dba_indexes sysindexes dba_users sysusers dba_data_files sysfiles v$lock syslocks v$session sysprocesses There are a few more, but they don't jump to mind at the moment, and I'm off home now to spend some time with my little girl :) I'd be interested in a more complete list if you do come up with one. Maybe I could post it to a web site? hmmm.. HTH Mark -----Original Message----- Jankovic Sent: Wednesday, October 24, 2001 23:10 To: Multiple recipients of list ORACLE-L We need to communicate inside a team made of DBAs that support different database platforms: oracle, sql*server, Sybase, adabase (Am I wrong that sql*server and sybase terminology is pretty much the same?). There are some terminology differences between different databases (to start with the word "database" that means different in oracle and sql*server world). I have tried to compile a start terminology difference list. If you could contribute to the list you can send an e-mail to me directly, I would compile the list and send the compiled version to the list. If you don't hear back from me that probably means that the list was not very responsive :-(. Also, please let me know if you think some terminology is wrong in this list. Thanks. Djordje Jankovic [EMAIL PROTECTED] Oracle SqlServer DB2 Database Server Schema Database Sys schema Master database Tablespace File group SYSTEM tablespace Primary data file other tablespaces Secondary data files Redo log file Log file Database block Page Extent Extent (8 pages -> 64K). (multiple of blocks) Can be shared by logical objects. Data dictionary System catalog Data dictionary views System catalog tables dba_objects sysobjects dba_tab_columns syscolumns dba_indexes sysindexes -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Djordje Jankovic 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: Mark Leith 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe 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: Mark Leith 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).
