Éý¼¶oracleÖеÄJDK°æ±¾
Oracle×Ô8iÆð¾ÍÈ«ÃæÖ§³Öjava£¬µ«¸÷¸ö°æ±¾µÄoracleÖÐĬÈÏjdk°æ±¾¾ù²»Ïàͬ£¬oracle8iÖÐΪ jdk1.2,oracle9iÖÐΪjdk1.3,oracle10gÖÐΪjdk1.4~~ÖÁ±ÊÕßÐÐΪ֮¼Ê£¬µ±Ç°µÄ×îа汾Ϊjdk1.5 update 11.
Òò±ÊÕßjava¿ª·¢³öÉí£¬ÔÚ×öoracle¿ª·¢Öо³£»áÓÃjavaÀ´À©Õ¹ oracle¹¦ÄÜ£¬µ«ÊÇÓÉÓÚoracle×Ô´øjdk°æ±¾¹ýµÍ£¬¿ÉÄÜ»áÔì³ÉһЩjava source±àÒëÎÞ·¨Í¨¹ý£¬ÓÚÊÇ°³ÏëÉý¼¶oracleÖеÄjdk£¬¾¹ý¸÷´óËÑË÷ÒýÇæËÑË÷£¬·¢ÏÖÏà¹ØÐÐÎÄÉõÉÙ£¬²¢ÇÒ¶¼²»ÍêÕû¡£±ÊÕß¾¹ýÒ»·¬Ñо¿£¬³É¹¦Éý¼¶£¬ÏÖ½«¹ý³Ìд³ö£¬¹©ÓÐÐÄÈ˲ο¼¡£
ITPUB¸öÈË¿Õ¼ä6B@ in1@)L.v,L J ?
ÒÔwindowsƽ̨ΪÀý¡£
Ê×ÏÈÐèÒªÏÂÔØ×îа汾µÄjdk£¬ÍƼöÖ±½Óµ½¹ÙÍøÏÂÔØ£¬µØÖ·ÈçÏ£º
https://sdlc3e.sun.com/ECom/EComActionServlet;jsessionid=CAB346E4103EE6D4FAE5F9B12FB3D928
ÏÂÔØÍê³ÉÖ®ºó£¬°´ÕÕ˵Ã÷°²×°£¬Ò»°ãÖ»ÐèÒªµã»÷next¼´¿É¡£¹ý³ÌÖлáÌṩÄãÑ¡ÔñjdkºÍjreµÄ°²×°Î»Ö㬿ÉÒÔĬÈÏÒ²¿ÉÒÔ×Ô¼ºÉ趨°²×°Ä¿Â¼£¬´ËĿ¼ÐèÒª¼ÇÒ䣬°²×°ÍêÖ®ºóÉ趨java_homeµÈ»·¾³±äÁ¿Ê±ÐèÒªÓõ½¡£±¾ÀýÖÐΪc:program filesjavajdk150,c:program filesjavajre150
°²×°Íê³ÉÖ®ºó´ò¿ª×ÀÃ棬ÓÒ¼üÎҵĵçÄÔ->ÊôÐÔ->¸ß¼¶->»·¾³±äÁ¿
ÔÚϵͳ±äÁ¿ÖÐÉ趨н¨£¬ITPUB¸öÈË¿Õ¼ä:Pjemma`
±äÁ¿Ãû£ºJAVA_HOME£¬±äÁ¿ÖµÎªjdk°²×°Ä¿Â¼c:program filesjavajdk150¡£
dBi,Vh3o7590422È·¶¨ºóÔÙн¨£¬ITPUB¸öÈË¿Õ¼ä(Ok3p?8[ J5_a-s
±äÁ¿Ãû£ºJRE_HOME,±äÁ¿ÖµÎª£ºc:program filesjavajre150.ITPUB¸öÈË¿Õ¼ä.h�c'd5X*TcNIF
È·¶¨ºóн¨£¬ITPUB¸öÈË¿Õ¼ä:s!vy+h'KR qd
±äÁ¿Ãû£ºCLASSPATH,±äÁ¿Öµ£º.;
È»ºóÉ趨path,oracle°²×°ºó»á×Ô¶¯½«ÆäĬÈϵÄjre·¾¶Ð´Èëpath±äÁ¿£¬Äã¿ÉÒÔ½«oracleÉ趨µÄjre·¾¶¸Ä³ÉÄã¸Õ¸Õ°²×°µÄз¾¶£¬Ò²¿ÉÒÔÖ±½Ó½«ÐµÄjdk·¾¶Ð´ÔÚ×îÇ°£¬×ÜÖ®¾ÍÊÇÈÃjava sources±àÒëµÄʱºòÒªÄܹ»ÕÒµ½Ð°汾µÄjdkËùÔÚ.
È«²¿Íê³ÉÖ®ºóÔÚcmd´°¿Újava -version£¬Èç¹ûÏÔʾjava version "1.5.0_xx"ÔòÉý¼¶³É¹¦¡£Èç¹ûÓÐÎ󣬼ì²éÒ»ÏÂÊÇ·ñÇ°ÃæµÄ²½ÖèÓвÙ×÷ʧÎóµÄµØÖ·£¬ÖØвÙ×÷¼´¿É¡£
Ïà¹ØÎĵµ£º
ImpºÍExp
ÃüÁîÏê½â:
Exp
µ¼³ö
ģʽ:
Fullģʽ---µ¼³ö
Õû¸öÊý¾Ý¿â
Userģʽ---µ¼³ö
Ö¸¶¨µÄÓû§
Tableģʽ—µ¼³ö
Ö¸¶¨µÄ±í
Tablespaceģʽ—µ¼³ö
±í
¿Õ¼ä
Exp
µ¼³ö
²ÎÊý:
OWNERÖ¸¶¨Òªµ¼³ö
µÄÓû§Áбí
FULL=y±íʾҪµ¼³ö
Õû¸öÊý¾Ý¿â
TablesÖ¸¶¨Òªµ¼³ö
µÄ±í
TablepacesÖ¸¶¨Òªµ¼³ö
µÄ±í
......
¡¡¡¡oracle% sqlplus /nolog
¡¡¡¡SQL> conn / as sysdba
¡¡¡¡Êý¾Ý¿âµÄÎïÀíÎļþ
¡¡¡¡Êý¾ÝÎļþ
¡¡¡¡select file_name from dba_data_files;
¡¡¡¡¿ØÖÆÎļþ
¡¡¡¡select name from v$controlfile;
¡¡¡¡ÈÕÖ¾Îļþ
¡¡¡¡select member from v$logfile;
¡¡¡¡---------------------------------------------------------
......
ORACLE SQLÓï¾äÓÅ»¯×ܽá
1£© Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)£º
ORACLEµÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬from×Ó¾äÖÐдÔÚ×îºóµÄ±í(»ù´¡±í driving table)½«±»×îÏÈ´¦Àí£¬ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏÂ,Äã±ØÐëÑ¡Ôñ¼Ç¼ÌõÊý×îÉٵıí×÷Ϊ»ù´¡±í¡£Èç¹ûÓÐ3¸öÒÔÉϵıíÁ¬½Ó²éѯ, Ä ......
(1) v$sql
¡¡¡¡Ò»ÌõÓï¾ä¿ÉÒÔÓ³Éä¶à¸öcursor,ÒòΪ¶ÔÏóËùÖ¸µÄcursor¿ÉÒÔÓв»Í¬Óû§(ÈçÀý1)¡£Èç¹ûÓжà¸öcursor(×ÓÓαê)´æÔÚ£¬ÔÚV$SQLAREAΪËùÓÐcursorÌṩ¼¯ºÏÐÅÏ¢¡£
Àý1£º
ÕâÀï½éÉÜÒÔÏÂchild cursor
user A: select * from tbl
user B: select * from tbl
´ó¼ÒÈÏΪÕâÁ½ÌõÓï¾äÊDz»ÊÇÒ»ÑùµÄ°¡£¬¿ÉÄÜ»áÓкܶàÈË»á˵ÊÇÒ»Ñù ......