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