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

ORACLEÖд¥·¢DBWR½ø³ÌµÄʼþ~

½ñÌìÔÚÒ»±¾ÊéÉÏ¿´µ½µÄ£¬¸Ð¾õͦȫµÄ¡£Ó¡ÏóÖÐ×Ô¼ºÒѾ­²»ÖªµÀ°Ù¶ÈÁ˶àÉÙ´ÎÕâ¸öÎÊÌ⣬½ñÌì¾Í¼ÇÏÂÀ´°É£¬·½±ãÒÔºó²éѯ¡£
Êý¾Ý¿âд½ø³ÌÔÚÒÔÏÂʼþÖ®Ò»·¢Éúʱ°ÑÊý¾Ý¿â¸ßËÙ»º³åÇøµÄÊý¾Ýдµ½Êý¾ÝÎļþÉÏ:
µ±Ô໺³åÇøµÄÊýÁ¿³¬¹ýÁËËùÉ趨µÄÏÞ¶î
µ±ËùÉ趨µÄʱ¼ä¼ä¸ôÒѵ½
µ±Óнø³ÌÐèÒªÊý¾Ý¿â¸ßËÙ»º³åÇøÈ´ÕÒ²»µ½¿ÕÏеĻº³åÇøÊ±
µ±¼ì²éµã·¢Éúʱ
µ±Ä³¸ö±í±»É¾³ý(drop)»ò±»½Ø¶Ï(truncate)ʱ
µ±Ä³¸ö±í¿Õ¼ä±»ÖÃΪֻ¶Á״̬(read only)ʱ
µ±Ê¹ÓÃÀàËÆÓÚALTER TABLESPACE users BEGIN BACKUPµÄÃüÁî¶Ôij¸ö±í¿Õ¼ä½øÐÐÁª»ú±¸·Ýʱ
µ±Ä³¸öÁÙʱ±í¿Õ¼ä±»ÉèÖÃΪֻÍÑ»ú״̬(offline)»òÕý³£×´Ì¬(normal)ʱµÈ


Ïà¹ØÎĵµ£º

oracle¸´Ï°£¨Ò»£© Ö®OracleÌåϵ½á¹¹

      ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬Ô­À´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·­Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
      µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......

ORACLE ÐÐתÁÐ ²âÊÔͨ¹ý£¨9i£©

--ORACLE ÐÐתÁР ²âÊÔͨ¹ý£¨9i£©
/***************************************************************************************************
ÒÔѧÉú³É¼¨ÎªÀý×Ó£¬±È½ÏÐÎÏóÒ×¶®
***********************************************************************************************************/
--1¡¢ÐÐתÁÐ
......

²éѯOracle×Ô´øµÄ·½·¨Ãû×ֺ͹ؼü×Ö

ÈçºÎ²éѯoracleÖеĹؼü×Ö£¬Ö´ÐУº
select * from v$reserved_words
ÆäʵÄÚǶµÄfunction£¬¾ÍÊÇÒ»¸öϵͳµÄpackageÄÚµÄfunction»òÕßprocedure¡£Èç¹ûÖªµÀÕâ¸ö¸ù±¾µÄÔ­Òò£¬ÒªÕÒµ½Õâ¸öÄÚǶµÄ×Ô´øfunction¾ÍºÜ¼òµ¥ÁË¡£
ÕâÀïÄÚǶµÄ×Ô´øµÄfucntionºÍprocedureµÄ¶ÔÏ󣬯äʵ¾ÍÊÇSTANDARDÕâ¸ö°üÀïµÄ¶ÔÏó¡£¶ø
OracleÀï¶ÔÓÚfuncti ......

×ªÔØoracle°²×°¸ÅÒª²½Öè

Ò»¡¢ÔÚORACLE´´½¨Ò»¸öеÄʵÀý¹ý³Ì£º
        1¡¢°²×°ºÃORACLE·þÎñ¶Ë¡£
        2¡¢´´½¨Êý¾Ý¿âʵÀý£¬Ê¹ÓÃORAHOMEĿ¼ÏµÄ"Configuration and Migration Tools"ϵÄ"Database Configuration Assistant"¹¤¾ß¡£
     &nbs ......

ÉîÈëdz³öoracleËø Ô­ÀíÆª & Í£Ö¹ÎÞ·´Ó¦µÄsql»á»°

ÔÚÏÖ´úµÄ¶àÓû§¶àÈÎÎñϵͳÖУ¬±ØÈ»»á³öÏÖ¶à¸öÓû§Í¬Ê±·ÃÎʹ²ÏíµÄij¸ö¶ÔÏó£¬Õâ¸ö¶ÔÏó¿ÉÄÜÊÇ±í£¬ÐУ¬»òÕßÄÚ´æ½á¹¹£¬ÎªÁ˽â¾ö¶à¸öÓû§²¢·¢ÐÔ·ÃÎÊ´øÀ´µÄÊý¾ÝµÄ°²È«ÐÔ£¬ÍêÕûÐÔ¼°Ò»ÖÂÐÔÎÊÌ⣬±ØÐëÒªÓÐÒ»ÖÖ»úÖÆ£¬À´Ê¹¶ÔÕâЩ¹²Ïí×ÊÔ´µÄ²¢·¢ÐÔ·ÃÎÊ´®Ðл¯£¬oracleÖеÄËø¾Í¿ÉÒÔÌṩÕâÑùµÄ¹¦ÄÜ£¬µ±ÊÂÎñÔÚ¶Ôij¸ö¶ÔÏó½øÐвÙ×÷ǰ£¬ÏÈÏòϵͳ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ