oracle入门知识

一个表空间只能属于一个数据库  
每个数据库最少有一个控制文件（建议3个，分别放在不同的磁盘上）  
每个数据库最少有一个表空间（SYSTEM表空间）  
建立SYSTEM表空间的目的是尽量将目的相同的表存放在一起，以提高使用效率，只应存放数据字典  
  
每个数据库最少有两个联机日志组，每组最少一个联机日志文件  
  
一个数据文件只能属于一个表空间  
一个数据文件一旦被加入到一个表空间中，就不能再从这个表空间中移走，也不能再加入到其他表空间中  
  
建立新的表空间需要建立新的数据文件  
  
COMMIT后，数据不一定立即写盘（数据文件）  
  
一个事务即使不被提交，也会被写入到重做日志中。  
  
oracle server可以同时启动多个数据库  
  
一套操作系统上可以安装多个版本的ORACLE数据库系统（UNIX可以，NT不可以）  
  
一套ORACLE数据库系统中可以有多个ORACLE数据库及其相对应的实例


我怎么开始学习oracle(转载)

How Do I get Started with Oracle?

This is actually a fairly common question and not one that is often addressed adequately. The following is the, slightly edited text of a reply sent by Howard Rogers www.dizwell.com to someone who asked this exact question. The post is so good, that with Howard's permission I reproduce it here. The 'here' referred to below is the usenet group comp.databases.oracle.server which can be reached via the link on the left or via your favourite newsreader.

Be patient. You're starting from scratch, so there's a lot to learn, and much of it may seem very strange to begin with. Visit The online documentation set to get access to the latest Oracle documentation (though your CD set will probably include it already). Read the official Concepts Guide. Then visit sites such as that maintained by Jonathan Lewis, and Ask Tom. Visit Google and hunt around for advice. Take nothing on face value: test it yourself to destruction. Lurk here for a month or two, and try and pick up on the sort of questions being asked, and ask yourself how *you* would answer them. Then see what answers actually come through, and compare. When you're feeling brave, post some of your answers and see how they are taken by people.

Buy books. Anything with the names Jonathan Lewis, or Thomas Kyte on the cover are *extremely* good bets for accurate advice. O'Reilly are good. As are Apress (used to be Wrox) Avoid anything that mentions OCP (Oracle Certified Professional). The qualification is not worth a damn, and leads you straight into myth territory.

If you can afford an Oracle training course (most people can't), go. Go to DBA Fundamantals I if you can... the architecture stuff they cover on that is extremely good (but you play Russian Roulette with the instructor you get. If the guy starts reading from the course notes in the first hour, then leave and ask to be scheduled with someone else at a later date). DBA Fundamentals II is quite good, but is light on networking, and the Backup and Recovery stuff is not difficult. Don't bother with Performance Tuning, because it's a badly-written course that addresses none of the real issues. I think the general thing is to get involved and to get communicating, and you've already started that by posting here. Just don't stop now.

The other general thing is to test and test and test, and verify for yourself. Experiment, and stuff the consequences. The other thing I would suggest, given your background, is that you learn Oracle at the command line, and learn *Oracle*. Worry about putting a graphical front-end app. on top of Oracle later. When you've got command-line Oracle sorted, the graphical front-ends will come as second nature, and will be better for the understanding you have of the back-end architecture and inner-workings.