An Oracle database with multiple applications using different schemas in the same database would be close to the SQL Server model.
Ron Smith -----Original Message----- [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 10:55 AM To: Multiple recipients of list ORACLE-L Being more of a SQL 2000 DBA (I am experienced from SQL Server 6.5). At my installation I have 5 SQL-2000 database machines and recently acquired three Oracle 9i machines. The limit is essentially a function of your storage area and the amount of real memory available to the processor or processor array. I'm trying to draw similarities between the RDBM concepts now as I learn Oracle's idea of a database. Maybe now is a good time for me to ask these question since it is related to this thread's subject, can you say that an Oracle instance is essentially the same as a MSSQL database? I ask this because a MSSQL server can support multiple databases which can be configured different ways. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 > -----Original Message----- > From: Boivin, Patrice J [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 31, 2003 7:59 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: Oracle to MSSQL conversion? > > > I have a question re. these conversions... > > If an Oracle database has 120 tablespaces, how does that > translate in MSSQL speak? > > (One of the tablespaces is USERS, home of dozens of schemas; > the others are either RB, SYSTEM, TEMP or application tablespaces) > > How many separate schemas-tablespaces can MSSQL hold per server? > > Patrice. > > -----Original Message----- > Sent: Thursday, July 31, 2003 7:34 AM > To: Multiple recipients of list ORACLE-L > > > I know Microsoft is offering a new course called 'Microsoft > SQL Server 2000 for Experienced Database Professionals'. It > is aimed at DBAs with experience with Oracle, DB2, Sybase > etc. who want to know more about SQL Server. > > You can read more about this course at > http://www.microsoft.com/traincert/syllabi/2723afinal.asp. > > Gudmundur > > > Hello, > > > > There is alot of talk about multi-skilling/reskilling going on here > > at my company. We use Oracle and MSSQL dbs. I have been wondering if > > anyone is aware of a resource that shows the oracle programming > > technique and what the corresponding MSSQL programming technique is. > > ie > > Oracle defines variable : MSSQL defines variable > > Oracle cursor looks like this : MSSQL cursor looks like this. > > Oracle uses rollbacks : MSSQL uses "MSSQL rollbacks" > > etc > > Hope you all understand what I mean. > > > > TIA > > Denham Eva > > Oracle DBA > > Linux like TeePee... No Windows, No Gates and Apache inside! > > > > > > ______________________________________________________________ > > _______________________ > > This e-mail message has been scanned for Viruses and Content and > > cleared by MailMarshal > > > > For more information please visit www.marshalsoftware.com > > ______________________________________________________________ > > _______________________ > > > > ############################################################## > > ####################### > > Note: > > This message is for the named person's use only. It may contain > > confidential, proprietary or legally privileged information. No > > confidentiality or privilege is waived or lost by any > > mistransmission. If you receive this message in error, please > > immediately delete it and all copies of it from your system, destroy > > any hard copies of it and notify the sender. You must not, directly > > or indirectly, use, disclose, distribute, print, or copy any part of > > this message if you are not the intended recipient. TFMC and any of > > its subsidiaries each reserve the right to monitor all e-mail > > communications through its networks. > > > > Any views expressed in this message are those of the individual > > sender, except where the message states otherwise and the sender is > > authorized to state them to be the views of any such entity. > > > > Thank You. > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Denham Eva > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > > San Diego, California -- Mailing list and web > hosting services > > > --------------------------------------------------------------------- > > 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.net > -- > Author: Gudmundur Bjarni Josepsson > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > 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.net > -- > Author: Boivin, Patrice J > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > 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.net -- Author: Wolfe Stephen S GS-11 6 MDSS/SGSI INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).