CentOS 5ϰ²×°Oracle 11g
Oracle¹«Ë¾Ðû³ÆÔÚLinuxϰ²×°Oracle9iÊý¾Ý¿âÖÁÉÙÒªÓÐ512MBµÄÄÚ´æºÍÖÁÉÙ1GB»òÕßÁ½±¶
ÄÚ´æ´óСµÄ½»»»¿Õ¼ä£¬¶ÔÓÚϵͳÄÚ´æ´óÓÚ2GBµÄ·þÎñÆ÷£¬½»»»¿Õ¼ä¿ÉÒÔ½éÓÚ2GB—4GBÖ®¼ä¡£
Èç¹ûÊÇΪÁËÔÚһ̨½öÓÐ256MÄÚ´æµÄÆÕͨPC»úÉÏÊÔÓÃOracle9i£¬ÔÚ·ÖÅäÁË1GB×óÓҵĽ»»»¿Õ¼äµÄÇé¿öÏ£¬Ò²¿ÉÒÔÕý³£ÔËÐÐOracleÊý
¾Ý¿â¡£
Òª¼ì²éÄÚ´æ¿Õ¼ä£¬µÇ¼½øÈëLinux£¬ÔÚÃüÁîÐз½Ê½£¨bash»·¾³£©ÏÂÖ´ÐÐÈçÏÂÃüÁ
grep MemTotal /proc/meminfo
Òª¼ì²é½»»»¿Õ¼ä£¬ÔÚÃüÁîÐÐÏÂÖ´ÐÐÈçÏÂÃüÁ
grep SwapTotal /proc/meminfo
CentOS 5ϰ²×°Oracle 11g
Ê×ÏÈÐèÒªµÄÈí¼þÓУº
1¡¢ linux_11gR1_database.zip //¿ÉÔÚOracleµÄ¹Ù·½ÍøÕ¾ÏÂÔØµÃµ½£¬ÓÐ1.71GB¹»
´ó°É¡£
2¡¢ ±ðÍüÁË×¼±¸Ò»·ÝOracleµÄ¹Ù·½°ïÖúÎĵµ£¬ÊÇ×îȨÍþµÄ¡£
3¡¢ CentOS-5.2-i386-bin-DVD.iso //¿ÉÔÚCentOS¹Ù·½ÍøÕ¾ÏÂÔØµÃµ½£¬ÓÐ3.74GB³¬¼¶´ó¡£
ºÇºÇ£¡£¡£¡
ÕâЩ׼±¸¹¤×÷×öºÃÁËÖ®ºó£¬ÎÒÃǾͿªÊ¼°²×°Linux²Ù×÷ϵͳ£¬ÔÚÐéÄâ»úÖа²×°£¬Ïê
ϸ°²×°¹ý³ÌÕâÀï¾Í²»ÃèÊö£¬²»¹ý£¬ÖµµÃÌáÐѵÄÊÇÐéÄâ»úÔÚÅäÖÃÐéÄâÓ²¼þ»·¾³Ê±£¬ÄÚ´æ±ØÐë
´óÓÚ»òµÈÓÚ1G£¬Ó²Å̿ռäÖÁÉÙ15G¡£
ÔÚ°²×°ºÃÐéÄâL inux ϵͳ֮ºó£¬ÒòΪÊDzËÄñ¼¶µÄÂËùÒÔÖ»ÓÐÔÚͼÐνçÃæÏÂÀ´²Ù
×÷ÁË¡£½«ÊÂÏÈÏÂÔØºÃµÄ linux_11gR1_database.zip ¿½±´ÖÁLinuxÐéÄâ»úÀï±ß£¬½¨Á¢Ò»¸ö´æ
·ÅĿ¼È磺
/u01/linux_11gR1_database.zip
½«Æä½âѹ£¬ÔÚÖÕ¶ËÊäÈëЩÃüÁîÖ´ÐУº
[root@oracle u01]# unzip linux_11gR1_database.zip
½âѹºóµÄ´æ·ÅÎļþ¼ÐÃûΪ database
Ê×ÏȲ鿴ÄãLinuxÄں˰汾ÊÇ·ñ·ûºÏoracle°²×°Ìõ¼þ£º
[root@oracle u01]# cat /proc/version
È·¶¨Äں˰汾ºó£¬¼ì²é´Ë°æ±¾Linux»·¾³Ï°²×°OracleËùÐèÒªÓõ½µÄ°ü£º
[root@oracle u01]# rpm -qa | grep <package_name>
binutils-2.17.50.0.6-2.el5
compat-libstdc++-33-3.2.3-61
elfutils-libelf-0.125-3.el5
elfutils-libel
Ïà¹ØÎĵµ£º
Ò»£¬PL/SQL¿éµÄ½á¹¹ºÍ×é³ÉÔªËØ
PL/SQL³ÌÐòÓÉÉùÃ÷²¿·Ö£¬Ö´Ðв¿·Ö£¬Òì³£´¦Àí²¿·ÖÈý¸ö²¿·Ö×é³É¡£½á¹¹ÈçÏ£º
DECLARE
/*ÉùÃ÷²¿·Ö£ºÔÚ´ËÉùÃ÷PL/SQL±äÁ¿£¬ÀàÐͼ°Óα꣬ÒÔ¼°¾Ö²¿µÄ´æ´¢¹ý³ÌºÍº¯Êý*/
BEGIN
/*Ö´Ðв¿·Ö£º¹ý³Ì¼°sqlÓï¾ä£¬³ÌÐòÖ÷Òª²¿·Ö£¬ÊDZØÐëµÄ*/
EXCEPTION
/*Òì³£´¦Àí²¿·Ö£º´íÎó´¦Àí*/
END
PL/SQL¿ ......
1 . set database to archivelog mode
Sql´úÂë
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE&n ......
ROLLUPºÍCUBEÓï¾ä¡£
OracleµÄGROUP
BYÓï¾ä³ýÁË×î»ù±¾µÄÓï·¨Í⣬»¹Ö§³ÖROLLUPºÍCUBEÓï¾ä¡£Èç¹ûÊÇROLLUP(A, B, C)µÄ»°£¬Ê×ÏÈ»á¶Ô(A¡¢B¡¢C)½øÐÐGROUP
BY£¬È»ºó¶Ô(A¡¢B)½øÐÐGROUP BY£¬È»ºóÊÇ(A)½øÐÐGROUP BY£¬×îºó¶ÔÈ«±í½øÐÐGROUP BY²Ù×÷¡£Èç¹ûÊÇGROUP BY
CUBE(A, B, C)£¬ÔòÊ×ÏÈ»á¶Ô(A¡¢B¡¢C)½øÐÐGROUP
BY£¬È»ºóÒÀ´ÎÊÇ( ......