Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

¶ÔOracleѧϰÕßµÄһЩ½¨Òé

ѧϰOracleÊÇÒ»¸öÂþ³¤¼è
ÐÁµÄ¹ý³Ì¡£Èç¹ûûÓÐÐËȤ£¬Ö»ÊDZ»ÆÈѧϰ£¬ÄÇôÊǺÜÄÑѧºÃµÄ¡£Ñ§Ï°µ½Ò»¶¨³Ì¶ÈµÄʱºò£¬ÒªÏë½øÒ»²½Ìá¸ß£¬¾Í²»µÃ²»½Ó´¥ºÜ¶àOracleÖ®ÍâµÄ¶«Î÷£¬Èç
Unix£¬ÈçÍøÂç¡¢´æ´¢µÈ¡£Òò´Ë£¬ÒªÕæµÄ¾öÐÄѧºÃOracle£¬¾ÍÒ»¶¨ÒªÓÐÐËȤ¡£ÓÐÁËÐËȤ£¬¾Í»áÒ»ÇбäµÃ¼òµ¥¿ìÀÖÆðÀ´¡£¼òµ¥×ܽáһϣ¬ÄǾÍÊÇ£ºÐËȤ¡¢Ñ§
Ï°¡¢Êµ¼ù¡£
ÈçºÎÈëÃÅÊÇÐí¶à³õѧÕß×îÍ·ÌÛµÄÊÂÇé¡£OracleÉæ¼°µÄ·½ÃæÌ«¶àÁË£ºSQL¡¢¹Ü
Àí¡¢ÓÅ»¯¡¢±¸·Ý»Ö¸´……ÄÇô´ÓÄÄ¿ªÊ¼Ñ§ºÃÄØ?Èç¹ûÔÚ´óѧÆÚ¼äѧ¹ýÊý¾Ý¿âÀíÂÛ£¬»òÓÐÒ»¶¨µÄÊý¾Ý¿â»ù´¡×ÔÈ»ºÜºÃ;Èç¹ûûÓеĻ°£¬ÕæµÄÊǸö´óÎÊÌâ¡£ÎÒ¸öÈËÈÏΪ»¹
ÊÇÓ¦¸Ã´ÓSQLÓï¾äѧÆ𡣱ȽϺõĽ̲ÄÊÇOracle OCPÈÏÖ¤µÄ¡¶SQL and
PL/SQL¡·¡£Ñ§Ï°SQLµÄʱºò£¬¾¡¿ÉÄܼá³ÖʹÓÃOracle×Ô´øµÄ¹¤¾ß£ºSQLPLUS¡£
 
ÓÐÁËÒ»¶¨µÄSQL»ù´¡ºó£¬¾ÍÒª¾¡¿ÉÄܵÄÁ˽âOracleµÄÌåϵ½á¹¹£¬Õâ¾ÍÉæ¼°µ½ÁË
Oracle¹ÜÀíµÄÄÚÈÝÁË¡£ÎÒѧϰµÄʱºò£¬»úе¹¤Òµ³ö°æÉçµÄ¡¶Oracle9i
DBAÊֲᡷÕâ±¾Êé¶ÔÎҵİïÖúͦ´ó¡£»òÐíÏÖÔÚ¶¼³ö11g°æ±¾µÄÁË°É¡£Oracle¹«Ë¾µÄ¡¶Oracle
Concepts¡·ÊǷdz£°ôµÄÊ飬¶ÔÁ˽âOracleÌåϵ½á¹¹ºÜÓкô¦¡£Ã¿¸öOracle°æ±¾¶¼ÓжÔÓ¦µÄ°æ±¾£¬¿ÉÒÔÈÏÕæ¶à¶Á¼¸´Î£¬Ã¿´Î¶¼»áÓÐеÄÊÕ»ñ¡£
 
¹«Ë¾µÄ²úÆ·ÏÖÔÚ¼¸ºõ¶¼²ÉÓÃOracleÁË£¬ÎÒÃÇ×öά»¤µÄʱºò£¬±¸·ÝÓë»Ö¸´ÊDz»µÃ²»½Ó
´¥µÄÄÚÈÝ¡£Êý¾ÝÁ¿Éٵģ¬±ÈÈç20¡¢30¶à¸öG£¬»¹¿ÉÒÔ¿¼ÂÇÓÃexp/impÀ´±¸·ÝÓë»Ö¸´£¬µ«Êý¾ÝÁ¿´óÁË£¬ÕâÖÖ·½·¨¾Í¸ù±¾²»ÊʺÏÁË¡£ÓÚÊÇѧϰOracle±¸
·ÝÓë»Ö¸´¼¼ÊõÒ²ÊDZØÈ»µÄÊÂÇé¡£´óÊý¾ÝÁ¿Çé¿öÏ£¬Oracle½¨ÒéÓÃRMANÀ´½øÐÐÊý¾ÝµÄ±¸·ÝÓë»Ö¸´¡£Ä¿Ç°Êг¡ÉÏÓкܶàÊý¾Ý¿â±¸·Ý»Ö¸´Èí¼þ£¬ÆäʵºÃ¶àÒ²ÊǺó
̨µ÷ÓÃRMAN¡£Ç廪´óѧ³ö°æÉç³ö°æµÄ¡¶Oracle 9i RMAN ±¸·ÝÓë»Ö¸´¼¼Êõ¡·ÊÇÒ»±¾·Ç³£²»´íµÄ½éÉÜRMANµÄÊé¡£
 
ÓÐÁËÒÔÉϵĻù´¡£¬¿ÉÒÔ˵ÒѾ­ÈëÃÅÁË£¬¶ÔÓöµ½µÄһЩ³õ¼¶OracleÎÊÌ⽫²»ÔÙÊøÊÖÎÞ
²ß¡£È»¶øÎÒÃǵÄѧϰ֮·ÈÔÈ»»¹ºÜÂþ³¤¡£ÎÒÃǵÄÓû§¿ÉÄܾ­³£±§Ô¹Êý¾Ý¿âÔËÐлºÂý¡£Õâʱ£¬Èç¹ûÓÐÒ»¶¨µÄÓÅ»¯ÖªÊ¶£¬ÄǾͺðìÁË¡£ÓÐʱÄã»á¿´µ½ÓÅ»¯Ç°ÐèÒªÔËÐм¸¸ö
СʱµÄ×÷Òµ£¬ÓÅ»¯ºóÒ²Ðí¼¸ÃëÖÓ¾ÍÄÜÍê³É!Oracle9iµÄÐÔÄÜÕï¶Ï¹¤¾ß°üstatspack¡¢Oracle10g/11gµÄ×Ô¶¯¹¤×÷·ûºÏ´æ´¢¿âAWR¶¼
Êǵ÷ÓŵĺðïÊÖ¡£»úе¹¤Òµ³ö°æÉç³ö°æµÄ¡¶Oracle9i STATSPACK¸ßÐÔÄܵ÷Õû¡·ÊÇѧϰstatspack²»´íµÄÊé¡£
 
ÔÚÊý¾Ý¿âÌåϵ½á¹¹¡¢±à³ÌÓÅ»¯·½Ã棬ÓÐÒ»±¾Êé·Ç³£°ô£¬Õâ¾ÍÊÇÊÀ½ç¶¥¼¶µÄOracleר
¼ÒThomas Kyte±àдµÄ¡¶Oracle9i&10g±à³Ì


Ïà¹ØÎĵµ£º

PHPÁ¬½ÓOracle²¢·ÖÒ³·ÃÎÊ

ʹÓõÄÊÇADODB¿â,ÐèÒªÓÐOCI8¿â.
<?php

//require("adodb5/adodb-exceptions.inc.php");
require("adodb5/adodb.inc.php");
$conn = NewADOConnection("oci8");
$conn->Connect($url, $user, $password, $service_name);
$rs;
try {
$rs = $conn->Execu ......

Óà Navicat for Oracle ¹ÜÀí Oracle10g/11g Êý¾Ý¿â

  Navicat for xxx ÊÇÒ»¸öÓÅÐãµÄÊý¾Ý¿â¹ÜÀí¿Í»§¶Ë£¬ÓÐ MySQL¡¢Oracle µÈ°æ±¾¡£½¨Òé´ó¼Ò×îºÃÓà Enterprise °æ±¾£¬¹¦ÄÜÈ«ÃæһЩ£¬µ«½ÏÖ®ÓÚÃâ·ÑµÄ Lite °æ£¬ÆóÒµ°æ¿ÉÊÇÒª»¨Òø×ÓÂòµÄ¡£
    °²×° Navicat for Oracle ºó£¬Ê×ÏÈÐèÒª½¨Ò»¸ö“Á¬½Ó”£¬×÷Ϊij¸ö¹ÜÀíÈÎÎñµÄ±êʶ£¬ÒòΪ×÷Ϊ¿Í»§¶Ë£¬Ëü¿ÉÒ ......

Oracle²Ù×÷ÃüÁî(sqlplus)

 1.Êý¾Ý¿â£¬±í£¬Óû§µÈ³É¹¦µ¼³ö                                    
¢Ùµ¼³öÕû¸öÊý¾Ý¿â                & ......

жÔØoracleµÄ²½Ö裨±Ê¼Ç£©

½ñÌìÖØÐÂÕûÀíµçÄÔ£¬ÕÒµ½Ò»¸öÎļþ£¬¿´ÁËÏÂÈÕÆÚ£¨2006.11.3£© £¬Å²»Ð¡ÐÄÔÙ¶ªÁË£¬´æµ½ÍøÉÏÀ´É¹É¹¡£
1.HKEY_LOCAL_MACHINE
  HKEY_LOCAL_MACHINE
  SOFTWARE
  ORACLE
2.HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services
3.ÖØÐÂÆô¶¯»úÆ÷.
create role  a  identified  by passwor ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ