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

oracleѧϰÀú³Ì

¶ÔoracleÒѾ­Ñ§Ï°Èý¸ö¶à4£¬¿ÉÒÔ²âÊÔÓÃһЩ¸´ÔÓµÄ×éºÏ£» 5£¬ËüÉú³ÉµÄ²âÊÔÓÃÀýÊÇÓм£¿ÉÑ­ÈÕ£¬¼´ÓйæÂɵ쬲»ÏñÊÖ¹¤²âÊÔÄÇÑù»áÒÅ©һЩÓÃÀýµÄ×éºÏ¡£ 3 Ñ¡ÔñOATSµÄ»ù±¾Ô­ÔòÒ»°ã¶¼ÊÇÏÈÈ·¶¨²âÊÔµÄÒòËØ¡¢Ë®Æ½ºÍ½»»¥×÷Ó㬺óÑ¡ÔñÊÊÓõÄÕý½»±í¡£ÔÚÈ·¶¨ÒòËØµÄˮƽÊýʱ£¬Ö÷ÒªÒòËØÓ¦¸Ã¶à°²Åż¸¸öˮƽ£¬´ÎÒªÒòËØ¿ÉÉÙ°²Åż¸¸öˮƽ¡£ £¨1ÖØÇìÈí¼þÅàѵ£©ÏÈ¿´Ë®Æ½Êý¡£Èô¸÷ÒòËØÈ«ÊÇ2ˮƽ£¬¾ÍÑ¡ÓÃL(2£ª)±í£»Èô¸÷ÒòËØÈ«ÊÇ3ˮƽ£¬¾ÍÑ¡L(3£ª)±í¡£Èô¸÷ÒòËØµÄˮƽÊý²»Ïàͬ£¬¾ÍÑ¡ÔñÊÊÓõĻìºÏˮƽÕý½»±í¡£ £¨2£©Ã¿Ò»¸ö½»»¥×÷ÓÃÔÚÕý½»±íÖÐÓ¦Õ¼Ò»Áлò¶þÁС£Òª¿´ËùÑ¡µÄÕý½»±íÊÇ·ñ×ã¹»´ó£¬ÄÜ·ñÈÝÄɵÃÏÂËù¿¼ÂǵÄÒòËØºÍ½»»¥×÷Óá£ÎªÁ˶ÔÊÔÑé½á¹û½øÐз½²î·ÖÎö»ò»Ø¹é·ÖÎö£¬»¹±ØÐëÖÁÉÙÁôÒ»¸ö¿Õ°×ÁУ¬×÷Ϊ“Îó²î”ÁУ¬ÔÚ¼«²î·ÖÎöÖÐÒª×÷Ϊ“ÆäËûÒòËØ&rdquo.Êý¾Ý¿â¼¯Èº
¹Ø¼ü×Ö£ºOATS£º¼´Orthogonal Array ¼¯£¬Õâ¸ö¼¯ºÏ£¬°üÀ¨×îÉٵIJâÊÔÓÃÀý£¬;Áд¦Àí¡£ £¨3£©Òª¿´²âÊÔ¾«¶ÈµÄÒªÇó¡£ÈôÒªÇó¸ß£¬ÔòÒËÈ¡²âÊÔ´ÎÊý¶àµÄÕý½»±í¡£ £¨4£©Èô²âÊÔ·ÑÓúܰº¹ó£¬»ò²âÊԵľ­·ÑºÜÓÐÏÞ£¬»òÈËÁ¦ºÍʱ¼ä¶¼±È½Ï½ôÕÅ£¬Ôò²»ÒËѡʵÑé´ÎÊýÌ«¶àµÄÕý½»±í¡£ £¨5£©°´Ô­À´¿¼ÂǵÄÒòËØ¡¢Ë®Æ½ºÍ½»»¥×÷ÓÃȥѡÔñÕý½»±í£¬ÈôÎÞÕýºÃÊÊÓõÄÕý½»±í¿ÉÑ¡£¬¼ò±ãÇÒ¿ÉÐеİ취ÊÇÊʵ±ÐÞ¸ÄÔ­¶¨µÄˮƽÊý¡££¨6£©¶ÔijÒòËØ»òij½»»¥×÷ÓõÄÓ°ÏìÊÇ·ñȷʵ´æÔÚûÓаÑÎÕµÄÇéÔÂÁË£¬¿´Á˲»ÉÙ¶«Î÷£¬oracleÊý¾Ý¿âºÜ¸´ÔÓ£¬¹â¸ÅÄî¾ÍºÜ¶à£¬ÎªÁ˶ÔoracleÓиüºÃµÄÈÏʶÎÒ´òËã°ÑÎÒÕâ¶Îʱ¼äµÄѧϰ×öÏÂ×ܽᣬΪ½áÏÂÀ´µÄѧϰ´òϺõĻù´¡¡£×ܽáĿ¼£º1.Éè¼ÆÊý¾Ý¿â£¬Éè¼Æ³ö½á¹¹ÓÅ»¯µÄÊý¾Ý¿â£¬¿ÉÀ©Õ¹ÐԺá£2.Êý¾Ý¿âµÄ±¸·ÝºÍ»Ö¸´£¬È¨Ï޵ķÖÅä3.ÓÅ»¯Êý¾Ý¿â£¬Êý¾Ý¿âÐÔÄܵ÷ÓÅ¡£4.Êý¾Ý¿â¿ª·¢£¬´æ´¢¹ý³Ì£¬´¥·¢Æ÷£¬º¯ÊýµÈºó¶ËÊý¾Ý¿â³ÌÐò£¬¸øÏµÍ³¿ª·¢ÈËÔ±Ìṩ·½±ãÊÓͼ5.Êý¾Ý¿âµÄÇ¨ÒÆ¡£6.ʵʩÊý¾Ý¿âͬ²½ÖØÇìÈí¼þ£¬´ó±í·Ö¸î£¬·ÖÇø±í¹ÜÀí¡£7²¢ÇÒ£¬°üÀ¨ÁËËùÓбäÁ¿µÄ×éºÏ,3£¬µÃµ½µÄ±äÁ¿µÄ×éºÏÊǾùÔȵķֲ¼µÄ£¨ÕâÒ»µã¿ÉÒÔ²ÎÕÕÉÏÃæµÄÕý½»±íµÄÌØµã£©£»¿öÏ£¬Ñ¡ÔñL±íʱ³£Îª¸ÃÑ¡´ó±í»¹ÊÇѡС±í¶øÓÌÔ¥¡£ÈôÌõ¼þÐí¿É£¬Ó¦¾¡Á¿Ñ¡Óôó±í£¬ÈÃÓ°Ïì´æÔڵĿÉÄÜÐԽϴóµÄÒòËØºÍ½»»¥×÷Óø÷Õ¼Êʵ±µÄÁС£4 OATSµÄ²½Ö裺1£¬ÏÈÒªÖªµÀÄãÓжàÉÙ¸ö±äÁ¿£¬Õâ¸ö²»ÓÃ˵ÁË£¬ºÜ¼òµ¥µÄ¾ÍÄÜÈ·¶¨ÁË¡£Ëü¶ÔÓ¦µ½Õý½»±íµÄ¸ÅÄîÖеÄÒòËØÊý¡£ 2£¬²é¿´Ã¿¸ö±äÁ¿µÄ²âÊÔȡֵ¸öÊý£¨ÕâÀïÎÒÓÃa´úÌæ£¬ÒÔ·½±ãºóÃæµ÷Óã©£¬Õâ¸öȡֵ²»ÊÇ˵Õâ¸ö±äÁ¿µÄȡֵ·¶Î§ÖаüÀ¨¶àÉÙ¸öÖµ£¬¶øÊÇÓõȼÛÀà»®·Ö³öÀ´µÄ¡£¹ØÓڵȼ


Ïà¹ØÎĵµ£º

oracle ´æ´¢¿Õ¼ä¹ÜÀí ³ÂţѧIT

1£¬segments µÄ·ÖÀà
       l  
        Êý¾Ý¶Î
l        
Ë÷Òý¶Î
l        
ÁÙʱ¶Î
l        
»ØÍË ......

oracleµ÷ÓÃjava

create or replace and compile java source named md5util as
import java.security.MessageDigest;
public class MD5Util
{
  public static String encrypt(String s)
  {
       char hexDigits[] = {'0', '1', '2', '3', '4', '5', '6', '7', '8', '9', 'a', 'b', 'c', ......

¹ØÓÚOracleÊý¾Ýµ¼Èëµ¼³öµÄһЩ²Ù×÷

OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹Ô­Ó뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
 
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ©ÖÐÖ´ÐУ¬ ......

Æô¶¯oracle ¹ùÒ«½ñ

ÓÃsqlplusÆô¶¯Êý¾Ý¿â
sqlplus /nolog
SQL> connect system/change_on_install as sysdba
SQL> startup
ÓÃsqlplusÍ£Ö¹Êý¾Ý¿â$ORACLE_HOME/bin/sqlplus /nolog
SQL> connect system/change_on_install as sysdba
SQL> shutdown ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ