| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Speaking the same language
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).Data dictionary views System catalogue tables
(multiple of blocks) Can be shared by logical objects.
Sessions Processes Data dictionary System catalogue =============================================================
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
djordjej_at_attcanada.ca
Oracle SqlServer
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: djankovic_at_corp.attcanada.ca 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-LReceived on Thu Oct 25 2001 - 11:16:09 CDT
(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).
 |
 |