How to search for Oracle's learning materials

Preface: Only follow the master introduction, can take less detours, English documents is the most authoritative learning materials.

(1), find the official online documentation for Oracle database

The following are the official online documentation for Oracle 11g R2, Oracle 10g R2, Oracle 9i R2:

Oracle database online Documentation 11g Release 2 (11.2) Oracle database online documentation 10g Release 2 (10.2) oracle9i Database Online Documentation (Release 2 (9.2))

Search methods as follows: In Google's search box search "pls site:www.oracle.com", such as Google, Baidu can also, suggest Google.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/4D/4A/wKioL1RPCjmAo-JkAAOOepnD46o490.jpg "title=" Qq20141028111336.png "alt=" Wkiol1rpcjmao-jkaaooepnd46o490.jpg "/>

(2), Oracle documentation

This includes Oracle versions of online documentation

Http://www.oracle.com/technetwork/documentation/index.html

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/4D/4A/wKiom1RPCzqj4vv7AAUhnzWbQAo444.jpg "title=" Qq20141028111902.png "alt=" Wkiom1rpczqj4vv7aauhnzwbqao444.jpg "/>

(3), how to quickly find a concept, for example, I want to check the LIBRARY CACHE, here to 11g R2 for example. (You can also query the meaning of a parameter, the meaning of the data dictionary, the meaning of a dynamic view, such as v$session.) ）

3.1. Enter the official online documentation for Oracle 11g R2 http://docs.oracle.com/cd/E11882_01/index.htm

3.2. Find Master Index

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/4D/4A/wKiom1RPDY3DgKGMAAjLDaYyGe0844.jpg "title=" Qq20141028112717.png "alt=" Wkiom1rpdy3dgkgmaajldayyge0844.jpg "/>

3.3, click L, because the LIBRARY CACHE is L start, and then search in Ctrl+f.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/4D/4A/wKiom1RPDe3Dxx50AAPZUIgzxqo978.jpg "title=" Qq20141028112955.png "alt=" Wkiom1rpde3dxx50aapzuigzxqo978.jpg "/>

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/4D/4B/wKioL1RPDwHRWwOsAAefIskmdTE584.jpg "title=" Qq20141028113328.png "alt=" Wkiol1rpdwhrwwosaaefiskmdte584.jpg "/>

(4), how to quickly obtain the Oracle error cause (cause) and action (resolution) solution.

Oracle provides a shell script that uses awk to get error messages, using: For example, Oracle report ORA-12500 error, executed with Oracle User: Oerr ora 12,500 First the reason for the error, and then the solution is described.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/4D/4A/wKiom1RPEDqwVSB4AANB2LSTqRg207.jpg "title=" Qq20141028114045.png "alt=" Wkiom1rpedqwvsb4aanb2lstqrg207.jpg "/>

$ORACLE the file suffix of the file *.msg that has these error messages in _HOME/RDBMS/MESG. 39 600 error is more serious, it is recommended to go directly to Metalink to find the cause is better. For example, when I import data in the presence of IMP-80, as long as the implementation of Oerr IMP 80, you can find out the cause of IMP error, the solution.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/4D/4A/wKiom1RPELiDVOXxAAMe0ZF00Nk866.jpg "title=" Qq20141028114236.png "alt=" Wkiom1rpelidvoxxaame0zf00nk866.jpg "/>

(5), how to quickly find pls error.

For example:

Pls-00323:subprogram or cursor ' x ' is declared in a package specification and must being defined in the package body

Pls-00304:cannot compile body of ' X ' without its specification

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/4D/4B/wKiom1RPEe6gVgGaAAWxyjU6t1s654.jpg "title=" Qq20141028114803.png "alt=" Wkiom1rpee6gvggaaawxyju6t1s654.jpg "/>

(6), how to quickly find a definition, such as to find the definition of data block.

6.1. Click Master Glossary

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/4D/4B/wKioL1RPFcTDu8rSAAjWIFHKNho071.jpg "title=" Qq20141028120248.png "alt=" Wkiol1rpfctdu8rsaajwifhknho071.jpg "/>

6.2. Click D

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/4D/4B/wKiom1RPFafBICG6AAJ2VqA9jHk136.jpg "title=" Qq20141028120350.png "alt=" Wkiom1rpfafbicg6aaj2vqa9jhk136.jpg "/>

6.2, Ctrl+f Search "Data Block"

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/4D/4B/wKiom1RPFd_g5zFaAAShS1oKjHA334.jpg "title=" Qq20141028120447.png "alt=" Wkiom1rpfd_g5zfaaashs1okjha334.jpg "/>

This article is from the "Xbc's homepage" blog, so be sure to keep this source http://alipay.blog.51cto.com/7119970/1568762

How to search for Oracle's learning materials