An Oracle instance does not correlate to a SQL Server database. An Oracle instance is a running Oracle server, i.e., a set of background processes and a System Global Area in memory. It is what permits applications to _access_ the database. The database is on disk, the instance in memory.
An Oracle _schema_ is analogous to a SQL Server database. (BTW, what does "v/r" mean?) --- Wolfe Stephen S GS-11 6 MDSS/SGSI <[EMAIL PROTECTED]> wrote: > 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). __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel 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).
