Thanks. v/r means Very Respectfully v/r
Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 > -----Original Message----- > From: Paul Baumgartel [mailto:[EMAIL PROTECTED] > 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 <[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). > -- 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).
