Correct. As for your second question, I have no idea!
--- "Boivin, Patrice J" <[EMAIL PROTECTED]> wrote: > : ) > > So an MS SQL "server" = an Oracle "instance" > > An MS SQL "database" = (roughly speaking) an Oracle "schema". > > An MS SQL "file set" = (roughly speaking) an Oracle "tablespace". > > and data files are data files. > > Is that correct? > > What would be the point of installing two SQL Server "servers" on the > same > box? Similar to setting up 2 or more instances on one host? > > Patrice. > > -----Original Message----- > Sent: Thursday, July 31, 2003 2:14 PM > To: Multiple recipients of list ORACLE-L > > > 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). > > > -- > === message truncated === __________________________________ 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).