OracleÊÚȨ¸øÓû§ÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí
ÓÐÒ»ÕÅѧÉú³É¼¨±í£¬Ö»ÏëÈÃÿ¸öÓû§²éѯ×Ô¼ºµÄ³É¼¨£¬²»Äܲéѯ±ðÈ˵ijɼ¨£¬Ó¦¸ÃÔõôÏÞÖÆ£¿
Õâ¸öÔÚǰ̨×öÊÇ¿ÉÒԵģ¬ ÔÚºóÌìÓÐÀ§ÄÑ¡£ ¼ÙÈçÓÐÒ»ÕÅ±í´æ·ÅѧÉú³É¼¨£¬ ѧÉúA£¬ÔÚǰ̨²éѯ£¬ÄÇô¿ÉÒÔÔÚ²éѯµÄSQLÀï¼ÓÈëAµÄѧºÅ£¬ ÕâÑù·µ»ØµÄ½á¹û¼¯¾ÍÊÇA µÄ³É¼¨¡£ ------------------------------------------------------------------------------ Blog£º http://blog.csdn.net/tianlesoftware ÍøÉÏ×ÊÔ´£º http://tianlesoftware.download.csdn.net Ïà¹ØÊÓÆµ£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx DBA1 Ⱥ£º62697716(Âú); DBA2 Ⱥ£º62697977 ÀÏʦ˵¹ý£¬ºÃÏñÊǼÓÉÏÒ»¸öʲô WHERE Óï¾ä£¬USERʲôµÄ£¬µ«ÊÇÎÒÍüÁË¡£¡£¡£ ¶÷ ʹÓÃsqlÓï¾äÀ´¿ØÖÆ¡£ÓÃÒ»ÕÅuser±í Óиöuserid ѧÉúAµÇ¼ Ò³Ãæ¼ÇÏÂËûµÄidºÅ ²éѯ¾Í¼Ó¸öwhere userid='';ÒýÓà ÀÏʦ˵¹ý£¬ºÃÏñÊǼÓÉÏÒ»¸öʲô WHERE Óï¾ä£¬USERʲôµÄ£¬µ«ÊÇÎÒÍüÁË¡£¡£¡£ ÊDz»Ðе쬽¨Òéǰ̨ʵÏÖ¡£¸ù¾Ýÿ¸öÓû§µÄµÇ¼µÄѧÉúID£¬×÷Ϊ²éѯ³É¼¨µÄÌõ¼þ¡£ Äܲ»ÄÜÉèÖÃÖ»Äܲéѯµ±Ç°µÇ¼Óû§µÄ³É¼¨£» ÀýÈ磬³É¼¨±íSC(SNAME,CNAME,SCORE) µ±Ç°µÇ¼Óû§ÊÇAA, È»ºóËûÖ»ÄܲéѯAAµÄ¿Î³ÌµÄ³É¼¨£¿ ÊÇWHERE SNAME=USER µ«ÊÇÕâ¾äÓ¦¸Ã·ÅÔÚÄÄÀ ¿ÉÒÔ½èÖúORCLE POLICYʵÏÖ¡£ ¾ßÌå·½·¨×Ô¼ºGOOGLEÒýÓà Äܲ»ÄÜÉèÖÃÖ»Äܲéѯµ±Ç°µÇ¼Óû§µÄ³É¼¨£» ÀýÈ磬³É¼¨±íSC(SNAME,CNAME,SCORE) µ±Ç°µÇ¼Óû§ÊÇAA, È»ºóËûÖ»Äܲ
Ïà¹ØÎÊ´ð£º
ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏ Errors in file /user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902: error in executing ODCIIndexStart() routine ORA-0 ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡ oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË ÒýÓà oracle ......
oracle 11g °²×° 01092 ´íÎó, ÈÕÖ¾ÐÅÏ¢£º [oracle@linux trace]$ vi alert_orcl.log MMON started with pid=14, OS id=9089 RESETLOGS after incomplete recovery UNTIL CHANGE 522752 Errors in file / ......
¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬ ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡ OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Â𣿠SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......