Correct.
As for your second question, I have no idea!
- "Boivin, Patrice J" <BoivinP_at_mar.dfo-mpo.gc.ca> 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 <Stephen.Wolfe_at_macdill.af.mil>
> 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
> > stephen.wolfe_at_macdill.af.mil
> > (813) 827-9974 DSN 651-9974
> >
> >
> >
> > > -----Original Message-----
> > > From: Boivin, Patrice J [mailto:BoivinP_at_mar.dfo-mpo.gc.ca]
> > > 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: EvaD_at_TFMC.co.za
> > > >
> > > > 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: 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).
> > > >
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author: Gudmundur Bjarni Josepsson
> > > INET: gbj_at_index.is
> > >
> > > 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: 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).
> > > --
>
=== 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: treegarden_at_yahoo.com
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: 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).
Received on Thu Jul 31 2003 - 17:09:23 CDT