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

¡¶Í¿Ä¨Oracle£­Èý˼±Ê¼ÇÖ®Ò»²½Ò»²½Ñ§Oracle¡·³ö¯ÊÖ¼Ç

¡öÀÖÖª
  “Ë­ÊÇË­µÄË­”£¬ÕâÊÇΨÃÀÖÐ͸×ÅÓÄÔ¹µÄÒ»Ê׸裬µ«È´»áĪÃûµØµçµ½ÐÄÖеÄÀÛ¡£Ñ§Ï°Ì«ÀÛ£¬¹¤×÷Ì«ÀÛ£¬Éú»îÌ«ÀÛ£¬Á¬¸èÃûÌý×Ŷ¼ÄÇôÀÛ¡£
²ß»®µÄµÚÒ»±¾Ê顶´óÏó——Thinking in UML¡·£¬´ÓÔË×÷£¬µ½ÉÏÊУ¬µ½³©Ïú£¬µ½¾­µä£¬µ½¹úÄÚUMLµÚÒ»Ê飬һÄêÖ®ÄÚʵÏÖÁËÒ»¸ö¸öûÓÐÃιýµÄÃÎÏë¡£ÕýÈçÕâÊ׸èÖеÄÒ»¾ä¸è´Ê£ºÄã¿´´°Í⻨¿ªÄÇôÃÀ¡£
    ÎÒϲ»¶»¨¿ª¡£³É¾ÍÒ»¶ä»¨¿ª£¬²¥ÖÖ¡¢½½Ë®¡¢Ê©·Ê¡¢´òÀí£¬ËäÈ»ÓÐȤ£¬ÀÛÈ´ÊÇÃâ²»Á˵ġ£Èç¹ûÏ뻨¿ª»¨ÔÙ¿ª£¬ÄǾ͸üÀÛÁË¡£
    ²»¹ýÕâÖÖÀÛ£¬ÓëÔÚѧϰOracleµÄ½¹ÓÍ¿ÓÖÐÉíÐľãÆ£µÄÃâ×ÓÃǵÄÀÛÏà±È£¬ÏÔÈ»²»ÖµÒ»Ìá¡£Ó£ÌҺóÔÊ÷ÄÑÔÔÕâ¾ä»°£¬¾ÍÊÇÏÈÈËΪ¹æÈ°ºóÈËǧÍò²»ÒªÑ§Ï°Oracle¶ø×¼±¸µÄ¡£OracleÃλõÄְҵǰ¾°Èü¼ÊõÈËÇ÷Ö®ÈôðÍ£¬ÆäÅÓ´óÓ븴ÔÓÈ´ÓÖÍùÍùÈÃÈË°ë;¶ø·Ï¡£×÷Ϊ¼¼ÊõÀàͼÊéµÄ²ß»®±à¼­£¬ÎÒʱʱÔÚÏ룬ʲôÑùµÄOracleͼÊéÄܹ»½â¾öÈÃÈË°ë;¶ø·ÏµÄÎÊÌâÄØ£¿ÈëÃÅ¡¢°¸Àý¡¢ÊµÕ½£¿¾«Í¨¡¢¾«½â¡¢¾«½²£¿¸ß¿ÉÓᢸßÐÔÄÜ¡¢¸ß°²È«£¿Ò»¸ö¸öµãÃæ²»ÇåµÄ˼·ÔÚ»ìÂÒÖгåײ£¬ÔÚ³åײÖлìÂÒ¡£
    ijÄêijÔÂijһÌì¡£
        ITPUBÏй䣬¿´Ä³²©ÎÄÖÐÓÐÒ»¾ä³ö×Ô¿××ӵĻ°£ºÖªÖ®Õß²»ÈçºÃÖ®Õߣ¬ºÃÖ®Õß²»ÈçÀÖÖ®Õß¡£Õâ¶úÊìÄÜÏêµÄÒ»¾ä»°£¬È´Áî¶àÈյĻìÂÒÓë³åײͻȻͣϢ¡£¿´À´Ê¥ÈËÕæ²»ÊÇ°×µ±µÄ£¬Ò»Ï¾ÍÄÜ¿´µ½ÎÊÌâµÄ±¾ÖÊ¡£ÀÖÖª£¬¾ÍÊÇ°Ñѧϰ±ä³É°®ºÃ£¬±ä³ÉÐËȤ£¬±ä³ÉÏíÊÜ¡£ÈË£¬Ê²Ã´¶¼ºÃ·ÅÆú£¬Î¨¶À²»ºÃ·ÅÆúµÄ¾ÍÊÇÏíÊÜ£¬ËùÒÔÈç¹ûÄÜ°ÑOracle¸É²ÝÒ»°ãµÄ¿ÝÔïת±ä³É÷Ò÷Ñ´ó²ÍµÄÏíÊÜ£¬²»¾ÍÊÇÕÒµ½ÁËÄÇÕµ¹¥¿ËOracleµÄ°¢À­¶¡ÉñµÆÂð£¿
¡öɨµØÉ®
        Oracle£¬ÕõÇ®ÈÝÒ×ѧÆðÀ´ÄÑ£¬ÕýÈç°¢À­¶¡ÉñµÆ£¬ÓÃÆðÀ´ÈÝÒ×Ñ°ÆðÀ´ÄÑ¡£ÎÞÊý¸öÈÕÒ¹µÄÑ°ÃÙ£¬×ܲ»¼ûÉñµÆµÄÉíÓ°¡£
    ÓÖÊÇijÄêijÔÂijһÌì¡£
    Îҵ㿪ÁËһƪ²©¿Í£¬Ó³ÈëÑÛÁ±µÄÊÇÒ»ÐÐÇ©Ãû£º
ɨµØ²»¹ýÊÇÎÒ±íÃæÉϵŤ×÷£¬ÎÒÕæÕýµÄÉí·ÝÆäʵÊÇÎÞÃûÀÏÉ®——ÊÖÀïÄǸùɨ°Ñ~
 
    Õâ¾ÍÊǾýÈý˼£¨¹úÄÚÊý¾Ý¿âÁìÓò×î¾ßÓ°ÏìÁ¦µÄÍøÕ¾Ö®Êý¾Ý¿â°æ°æÖ÷Àî±ûÑóµÄÍøÃû£©µÄ²©¿Í¡£Ëæ±ãµã¿ªÁËһƪÃûΪ¡¶Ð¡¼Çpub08Äê»áÈýÁ½ÊÂÖ®Èý¡¢´òÆË¿Ë~~~¡·£¨Á´½Ó¼ûhttp://space.itpub.net/7607759/viewspace-151194£©µÄ²©ÎÄ¡£¶ÁÍêºó£¬Ëäδ¼ûÆäÈË£¬µ«Ò»¸öÈ÷ÍÑ¡¢»úÖÇ¡¢ÓÄĬ¡¢²Å»ªºáÒç»òÐí»¹ÓÐЩ»µµÄ¾ýÈý˼ÒѾ­»îÍÑÍѸ¡ÏÖÓÚÄÔº£¡£ÎÒ¿ªÊ¼ä¯À


Ïà¹ØÎĵµ£º

oracleË÷ÒýÏê½â

Ô­ÎĵØÖ·£ºhttp://fandayrockworld.javaeye.com/blog/540509 
»Ø¹Ë£º
Ò»¡¢ ROWIDµÄ¸ÅÄî
¡¡¡¡´æ´¢ÁËrowÔÚÊý¾ÝÎļþÖеľßÌåλÖãº64λ±àÂëµÄÊý¾Ý£¬A-Z, a-z, 0-9, +, ºÍ /£¬
¡¡¡¡rowÔÚÊý¾Ý¿éÖеĴ洢·½Ê½
¡¡¡¡SELECT ROWID, last_name from hr.employees WHERE department_id = 20;
¡¡¡¡±ÈÈ磺OOOOOOFFFBBBBBBRRR ......

oracle sqlplus Óëdos ÖÐÎÄÂÒÂë

1.SQL> select * from v$nls_parameters;
PARAMETER                           VALUE
----------------------------------- ------------------------------------
---------- ......

oracle exp imp ³õ̽

Êý¾Ýµ¼³ö£º
 1 ½«Êý¾Ý¿âTESTÍêÈ«µ¼³ö,Óû§Ãûsystem ÃÜÂëmanager µ¼³öµ½D:\daochu.dmpÖÐ
   exp system/manager@TEST file=d:\daochu.dmp full=y
 2 ½«Êý¾Ý¿âÖÐsystemÓû§ÓësysÓû§µÄ±íµ¼³ö
   exp system/manager@TEST file=d:\daochu.dmp owner=(system,sys)
 3 ½«Êý¾Ý¿âÖеıíin ......

28.5 OracleͼÐλ¯¹ÜÀí¹¤¾ß——OEM

28.5  OracleͼÐλ¯¹ÜÀí¹¤¾ß——OEM
OracleÆóÒµ¹ÜÀíÆ÷£¨Oracle Enterprise Manager£¬OEM£©ÊÇOracleÌṩµÄÒ»¸ö»ùÓÚWebµÄͼÐλ¯Êý¾Ý¿â¹ÜÀí¹¤¾ß¡£Í¨¹ýOEM£¬Óû§¿ÉÒÔÍê³É¼¸ºõËùÓеÄÔ­À´Ö»ÄÜͨ¹ýÃüÁîÐз½Ê½Íê³ÉµÄ¹¤×÷£¬°üÀ¨Êý¾Ý¿â¶ÔÏó¡¢Óû§È¨ÏÞ¡¢Êý¾ÝÎļþ¡¢¶¨Ê±ÈÎÎñµÄ¹ÜÀí£¬Êý¾Ý¿â²ÎÊýµÄÅäÖ㬱¸·ÝÓë»Ö¸´£¬ÐÔÄÜ ......

28.6 Oracle³£¼ûÎÊÌâ´¦Àí

28.6  Oracle³£¼ûÎÊÌâ´¦Àí
±¾½Ú½éÉÜÔÚRed Hat Enterprise Linux 5.2ÉÏ°²×°¼°ÅäÖÃOracleÊý¾Ý¿â·þÎñÆ÷ÖУ¬³£¼ûµÄÎÊÌâ¼°½â¾ö·½·¨£¬°üÀ¨ÈçºÎ»ñµÃÊý¾Ý¿â´´½¨¹ý³ÌÖеÄÏêϸÐÅÏ¢£¬·ÃÎÊOEM³öÏÖ“°²È«Á¬½Óʧ°Ü£¬Ê¹ÓÃÁËÎÞЧµÄ°²È«Ö¤Êé”´íÎóÒÔ¼°Íü¼ÇsysÓû§¿ÚÁîºóµÄ´¦Àí·½·¨µÈ¡£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ