SQL Server到Oracel [英] SQL Server to Oracel

问题描述

我有一个新工作，我必须在Linux上处理Oracle数据库。我的

之前的经验是Windows NT上的Sql Server。我想知道这个转变有多困难，我需要先学习和快速学习。

Linux上的Oracle与Windows上的Oracle有何不同。 Oracle和SQL Server之间的主要差异是什么？
。任何帮助，链接将是

赞赏。


thx

I got a new Job where I have to handle Oracle databases on Linux. My
previous experience is with Sql Server on Windows NT. I want to know how
difficult will this shift be and what do I need to learn first and quickly.
How different is Oracle on Linux then Oracle on windows. What are the major
differences between Oracle and SQL Server. Any help, links will be
appreciated.

thx

推荐答案

现在，这是一个变化。操作系统的变化和数据库的变化:)


忘记关于sql server的一切，从Oracle初学者开始

课程或书籍。

- Linux与NT相同。


从Unix迁移到Linux（不包括系统管理员工作）对于b / b
的变化不大在我看来，DBA。


注意：我个人在Unix或Linux上使用Oracle。


-

甲骨文新手 < F9 ****** @ yahoo.com>在消息中写道

新闻：2j ************* @ uni-berlin.de ...

Now, that is a change. Change of OS AND change in database :)

Forget everything about sql server and start out with the Oracle beginners
classes or books.
- Same for Linux vs. NT.

Moving from Unix to Linux (not counting Sys Admin work) is not much of a
change for DBAs, in my opinion.

Note: I personally perfer Oracle on Unix or Linux.

--

"Oracle Newbie" <f9******@yahoo.com> wrote in message
news:2j*************@uni-berlin.de...

我找到了一份新职位我必须在Linux上处理Oracle数据库。我之前的经验是Windows NT上的Sql Server。我想知道这种转变有多困难，我需要先学习什么，快速学习
。 Linux上的Oracle与Windows上的Oracle有多么不同。 Oracle和SQL Server之间的
主要区别是什么？任何帮助，链接将受到赞赏。

thx

I got a new Job where I have to handle Oracle databases on Linux. My
previous experience is with Sql Server on Windows NT. I want to know how
difficult will this shift be and what do I need to learn first and quickly. How different is Oracle on Linux then Oracle on windows. What are the major differences between Oracle and SQL Server. Any help, links will be
appreciated.

thx

甲骨文新手 < F9 ****** @ yahoo.com>在消息中写道

新闻：2j ************* @ uni-berlin.de ...

"Oracle Newbie" <f9******@yahoo.com> wrote in message
news:2j*************@uni-berlin.de...

我找到了一份新职位我必须在Linux上处理Oracle数据库。我之前的经验是Windows NT上的Sql Server。我想知道这种转变有多困难，我需要先学习什么，快速学习
。 Linux上的Oracle与Windows上的Oracle有多么不同。 Oracle和SQL Server之间的
主要区别是什么？任何帮助，链接将是
赞赏。

thx

I got a new Job where I have to handle Oracle databases on Linux. My
previous experience is with Sql Server on Windows NT. I want to know how
difficult will this shift be and what do I need to learn first and quickly. How different is Oracle on Linux then Oracle on windows. What are the major differences between Oracle and SQL Server. Any help, links will be
appreciated.

thx

实际上只有一个链接转向这样的时间：
http://tahiti.oracle.com 。找到你将要处理的版本，然后

点击该版本的书籍列表，然后找到概念

指南。如果你有多个版本，我建议使用9i链接，

而不是10g（除非你的组织实际上正在运行

10g）。在任何先前的Oracle

版本中，10g与建筑上有很大不同，如果您尝试将10g

知识应用于9i或8i，则会有很多误导或混淆。虽然9i概念几乎适用于大多数时间的
8i，而8i几乎100％适用于8.0.


没有区别在任何平台上的Oracle之间。嗯，好的：Linux和

Unix是基于进程的操作系统，Windows是一个基于线程的操作系统，

所以你可以实际看到* PMON，SMON ，DBWn和其余的在* nix

平台上，你无法在Windows上看到等效的线程。但是他们仍然没有好，并且仍然和他们在
* nix上的等效流程做同样的工作。我能想到的唯一其他主要区别是* nix通过内核参数对SGA进行
共享内存分配，而Windows

通过创建（并运行）来实现，显然）每个服务每个

SGA /实例。但那是'小事。概念指南中的99％

将适用于两个平台而无需更改。


对于什么是什么是这个问题没有答案

Oracle与SQL Server'之间的主要区别。他们的术语不同（例如，Oracle架构=

SQL Server数据库）。你不妨问一下来自埃菲尔铁塔的桃子有多么不同。两者都相当漂亮，很好地服务于它们的b $ b目的，除了它们都是由原子组成的b $ b b b之外几乎没有共同点。尽量不要比较这两种产品;只需按照自己的条款学习每一个

。这意味着，对您来说，按照条款学习Oracle。你将

可能永远是被感染的我倾向于从SQL Server的角度看待事物，就像我看到SQL Server并惊恐地尖叫，它不是甲骨文的b $ b。那是不可避免的。将DBA与令人讨厌的
偏执者区分开来的是能够接受这些差异并接受它们，而不是将它们视为鄙视一种或其他产品的理由。


其他有用链接： www.jlcomp。 demon.co.uk 和（尽管我有偏见）
www。 dizwell.com


这将有助于学习如何拼写你现在正在使用的产品，

。


问候

HJR

There''s really only one link to turn to at a time like this:
http://tahiti.oracle.com. Find the version you''ll be dealing with, then
click on the list of books for that version, and then find the Concepts
guide. If you''ve got multiple versions, I''d suggest using the 9i links,
rather than 10g (unless of course your organisation is actually running
10g). 10g is significantly different, architecturally, from any prior Oracle
version, and a lot will mislead or confuse if you try and apply 10g
knowledge to 9i or 8i. Whereas 9i concepts are, pretty much, applicable to
8i most of the time, and 8i is almost 100% applicable to 8.0.

There is no difference between Oracle on any platform. Well, OK: Linux and
Unix are process-based operating systems, and Windows is a thread-based one,
so whereas you can actually *see* PMON, SMON, DBWn and the rest on a *nix
platform, you can''t see the equivalent threads on Windows. But they''re still
there alright, and still do the same jobs as their equivalent processes on
*nix. The only other major difference I can think of is that *nix does
shared memory allocations for the SGA via kernel parameters, and Windows
does it via the creation (and running, obviously) of a service for each
SGA/Instance. But that''s minor stuff. 99% of what''s in the concepts guide
will apply to both platforms without change.

There is no answer to the question ''what are the major differences between
Oracle and SQL Server''. Their very terminology is different (Oracle schema =
SQL Server database, for example). You might as well ask how different a
peach is from the Eiffel Tower. Both are rather beautiful, serve their
purposes well, and have little fundamentally in common except that they are
both made of atoms. Try not to compare the two products; just learn each on
their own terms. That means, for you, learning Oracle on its terms. You will
probably always be "infected" by a tendency to see things from a SQL Server
perspective, just as I look at SQL Server and scream in horror that it''s not
Oracle. That''s just inevitable. What separates the DBAs from the geeky
bigots is to be able to embrace those differences and accept them, rather
than see them as a reason to despise one or other product.

Other useful links: www.jlcomp.demon.co.uk and (though I''m biased)
www.dizwell.com

It would help to learn how to spell the product you''ll now be working with,
too.

Regards
HJR

" Howard J. Rogers" < hj*@dizwell.com>在消息新闻中写道：< 40 *********************** @ news.optusnet.com。 au> ...

"Howard J. Rogers" <hj*@dizwell.com> wrote in message news:<40***********************@news.optusnet.com. au>...

" Oracle Newbie" < F9 ****** @ yahoo.com>在消息中写道
新闻：2j ************* @ uni-berlin.de ...

"Oracle Newbie" <f9******@yahoo.com> wrote in message
news:2j*************@uni-berlin.de...

我得到了一份我必须处理的新工作Linux上的Oracle数据库。我之前的经验是Windows NT上的Sql Server。我想知道这种转变有多困难，我需要先学习什么？

I got a new Job where I have to handle Oracle databases on Linux. My
previous experience is with Sql Server on Windows NT. I want to know how
difficult will this shift be and what do I need to learn first and

快速。

Oracle在Linux上与Oracle有何不同视窗。什么是

How different is Oracle on Linux then Oracle on windows. What are the

主要

Oracle和SQL Server之间的差异。任何帮助，链接将受到赞赏。

thx

differences between Oracle and SQL Server. Any help, links will be
appreciated.

thx

实际上只有一个链接可以像这样转向：
http://tahiti.oracle.com 。找到您将要处理的版本，然后单击该版本的书籍列表，然后找到Concepts
指南。如果你有多个版本，我建议使用9i链接，而不是10g（当然除非你的组织实际上运行了10g）。从架构上看，10g与以前的任何版本都有很大差异，如果你尝试将10g知识应用于9i或8i，很多都会误导或混淆。虽然9i概念在大多数情况下几乎适用于8i，而8i几乎100％适用于8.0。

Oracle在任何平台上都没有区别。嗯，好的：Linux和
Unix是基于进程的操作系统，Windows是一个基于线程的操作系统，所以你可以实际看到* PMON，SMON，DBWn，其余的就是* nix
平台，你无法在Windows上看到等效的线程。但他们仍然没有问题，仍然可以完成与
* nix上的等效流程相同的工作。我能想到的唯一另一个主要区别是* nix通过内核参数为SGA共享内存分配，Windows
通过为每个服务创建（并显然运行）服务来实现这一点。
SGA /实例。但那是'小事。概念指南中99％的内容将适用于两个平台而无需更改。

对于
之间的主要区别是什么这个问题没有答案。 Oracle和SQL Server''。他们的术语不同（例如，Oracle架构=
SQL Server数据库）。你不妨问一下桃子与艾菲尔铁塔有多么不同。两者都相当漂亮，很好地服务于它们的目的，除了它们都是由原子构成之外几乎没有根本共同之处。尽量不要比较这两种产品;按照自己的条件学习每一个。这意味着，对您来说，按照条款学习Oracle。你可能总是被感染了从SQL Server的角度看事物的倾向，正如我看着SQL Server并惊恐地尖叫，它不是Oracle。那是不可避免的。将DBA与令人讨厌的偏执者区分开来的是能够接受这些差异并接受它们，而不是将它们视为鄙视其中一种或其他产品的理由。

其他有用的链接： www.jlcomp.demon.co.uk 和（虽然我很有偏见）
www.dizwell.com
<这将有助于学习如何拼写你现在正在使用的产品，

问候
HJR

There''s really only one link to turn to at a time like this:
http://tahiti.oracle.com. Find the version you''ll be dealing with, then
click on the list of books for that version, and then find the Concepts
guide. If you''ve got multiple versions, I''d suggest using the 9i links,
rather than 10g (unless of course your organisation is actually running
10g). 10g is significantly different, architecturally, from any prior Oracle
version, and a lot will mislead or confuse if you try and apply 10g
knowledge to 9i or 8i. Whereas 9i concepts are, pretty much, applicable to
8i most of the time, and 8i is almost 100% applicable to 8.0.

There is no difference between Oracle on any platform. Well, OK: Linux and
Unix are process-based operating systems, and Windows is a thread-based one,
so whereas you can actually *see* PMON, SMON, DBWn and the rest on a *nix
platform, you can''t see the equivalent threads on Windows. But they''re still
there alright, and still do the same jobs as their equivalent processes on
*nix. The only other major difference I can think of is that *nix does
shared memory allocations for the SGA via kernel parameters, and Windows
does it via the creation (and running, obviously) of a service for each
SGA/Instance. But that''s minor stuff. 99% of what''s in the concepts guide
will apply to both platforms without change.

There is no answer to the question ''what are the major differences between
Oracle and SQL Server''. Their very terminology is different (Oracle schema =
SQL Server database, for example). You might as well ask how different a
peach is from the Eiffel Tower. Both are rather beautiful, serve their
purposes well, and have little fundamentally in common except that they are
both made of atoms. Try not to compare the two products; just learn each on
their own terms. That means, for you, learning Oracle on its terms. You will
probably always be "infected" by a tendency to see things from a SQL Server
perspective, just as I look at SQL Server and scream in horror that it''s not
Oracle. That''s just inevitable. What separates the DBAs from the geeky
bigots is to be able to embrace those differences and accept them, rather
than see them as a reason to despise one or other product.

Other useful links: www.jlcomp.demon.co.uk and (though I''m biased)
www.dizwell.com

It would help to learn how to spell the product you''ll now be working with,
too.

Regards
HJR

哇！得到一个不能拼写Oracle的新手！现在我打赌1000比1，它是b / b
你是HJR烹饪新手的消息，你的偏见很明显

你的dizwell狗屎。


无望。


OMLET就在您的屁股上
http://www.geocities.com/TeraKnowledgeSystems

下载OMLET v4：终极Oracle监控工具

Wow! get a newbie who cannot spell Oracle! Now I bet 1000 to 1 that it
is you HJR that cooked the newbie message and your bias is apparent
with your dizwell shit.

hopeless.

OMLET right on your ass
http://www.geocities.com/TeraKnowledgeSystems
download OMLET v4: The Ultimate Oracle Monitoring Tool

这篇关于SQL Server到Oracel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！