RE: Oracle to MSSQL conversion?

Thanks. v/r means Very Respectfully

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: Paul Baumgartel [mailto:treegarden_at_yahoo.com]
> Sent: Thursday, July 31, 2003 1:14 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Oracle to MSSQL conversion?
>
>
> 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).
>

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