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).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Boivin, Patrice J
> > INET: BoivinP_at_mar.dfo-mpo.gc.ca
> >
> > 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: Wolfe Stephen S GS-11 6 MDSS/SGSI
> INET: Stephen.Wolfe_at_macdill.af.mil
>
> 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).
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 - 12:14:24 CDT