Oracle VPDʵÏÖÊý¾ÝϸÁ£¶È·ÃÎÊ£¨¸üºÃµÄȨÏÞ¿ØÖÆ£©
¸ÅÊö
ÐéÄâרÓÃÊý¾Ý¿â (VPD) ÌṩÁ˽ÇÉ«ºÍÊÓͼÎÞ·¨ÌṩµÄÐм¶·ÃÎÊ¿ØÖÆ¡£¶ÔÓÚ»¥ÁªÍø·ÃÎÊ£¬ÐéÄâרÓÃÊý¾Ý¿â¿ÉÒÔÈ·±£ÔÚÏßÒøÐеĿͻ§Ö»ÄÜ¿´µ½ËûÃÇ×Ô¼ºµÄÕÊ»§¡£Web Íйܹ«Ë¾¿ÉÒÔÔÚͬһ Oracle Êý¾Ý¿âÖÐά»¤¶à¸ö¹«Ë¾µÄÊý¾Ý£¬µ«Ö»ÔÊÐíÿ¸ö¹«Ë¾²é¿´Æä×ÔÉíÊý¾Ý¡£
ÔÚÆóÒµÄÚ²¿£¬ÐéÄâÊý¾Ý¿â¿ÉÔÚÓ¦ÓóÌÐò²¿Êð·½Ãæ½µµÍÓµÓгɱ¾¡£¿ÉÒÔÔÚÊý¾Ý¿â·þÎñÆ÷Ò»´ÎʵÏÖ°²È«ÐÔ£¬¶ø²»ÓÃÔÚ·ÃÎÊÊý¾ÝµÄÿ¸öÓ¦ÓóÌÐòÖзֱðʵÏÖ°²È«ÐÔ¡£ÒòΪÊÇÔÚÊý¾Ý¿âÖÐʵʩ°²È«ÐÔ£¬ËùÒÔ²»¹ÜÓû§·ÃÎÊÊý¾ÝµÄ·½Ê½ÈçºÎ£¬°²È«ÐÔ½ÏÒÔÇ°¸ü¸ß¡£·ÃÎʼ´Ï¯²éѯ¹¤¾ß»òб¨±íÉú³É³ÌÐòµÄÓû§²»ÔÙÄÜÈƹý°²È«»·½Ú¡£ÐéÄâרÓÃÊý¾Ý¿âÊÇÒ»ÏîÖØÒª¼¼Êõ£¬Ê¹ÆóÒµÄܹ»¹¹½¨Íйܵġ¢»ùÓÚ Web µÄÓ¦ÓóÌÐò¡£Êµ¼ÊÉÏ£¬Ðí¶à Oracle Ó¦ÓóÌÐò±¾ÉíʹÓà VPD ʵʩÊý¾Ý·Ö¸ô£¬°üÀ¨ Oracle SalesOnline.com ºÍ Oracle Portal µÈ³ÌÐò¡£
ÐéÄâרÓÃÊý¾Ý¿âÈçºÎ¹¤×÷
½«Ò»¸ö»ò¶à¸ö°²È«²ßÂÔÓë±í»òÊÓͼ¹ØÁªºó£¬¾Í¿ÉÒÔʵÏÖÐéÄâרÓÃÊý¾Ý¿â¡£¶Ô´ø°²È«²ßÂԵıí½øÐÐÖ±½Ó»ò¼ä½Ó·ÃÎÊʱ£¬Êý¾Ý¿â½«µ÷ÓÃÒ»¸öʵʩ¸Ã²ßÂԵĺ¯Êý¡£²ßÂÔº¯Êý·µ»ØÒ»¸ö·ÃÎÊÌõ¼þ£¨WHERE ×Ӿ䣩£¬¼´Î½´Ê¡£Ó¦ÓóÌÐò½«Ëü¸½¼Óµ½Óû§µÄ SQL Óï¾ä£¬´Ó¶ø¶¯Ì¬ÐÞ¸ÄÓû§µÄÊý¾Ý·ÃÎÊȨÏÞ¡£
Äã¿ÉÒÔͨ¹ý±àдһ¸ö´æ´¢¹ý³Ì½« SQL ν´Ê¸½¼Óµ½Ã¿¸ö SQL Óï¾ä£¨ÓÃÓÚ¿ØÖƸÃÓï¾äµÄÐ춱ð·ÃÎÊȨÏÞ£©À´ÊµÊ© VPD¡£ÀýÈ磬Èç¹û John Doe£¨ËûÊôÓÚ Department 10£©ÊäÈë SELECT * from emp Óï¾ä£¬Ôò¿ÉÒÔʹÓà VPD Ìí¼Ó WHERE DEPT = 10 ×Ӿ䡣ÕâÑù£¬Äú±ã¿ÉÒÔͨ¹ý¶Ô²éѯ½øÐÐÐÞ¸ÄÀ´ÏÞÖÆ·ÃÎÊijЩÐеÄÊý¾Ý¡£
ÐéÄâרÓÃÊý¾Ý¿âÈ·±£ÎÞÂÛÓû§ÒÔºÎÖÖ·½Ê½·ÃÎÊÊý¾Ý£¨Í¨¹ýÓ¦ÓóÌÐò¡¢±¨±í±àд¹¤¾ß»ò SQL*Plus£©£¬¶¼½«Ç¿ÖÆʵʩͬһǿ´óµÄ·ÃÎÊȨÏÞ¿ØÖƲßÂÔ¡£ÕâÑù£¬Ê¹Óà VPD £¬ÒøÐбã¿ÉÒÔÈ·±£¿Í»§Ö»¿´µ½ËûÃÇ×Ô¼ºµÄÕÊ»§£¬µçÐŹ«Ë¾¿ÉÒÔ°²È«µØ¸ôÀë¿Í»§¼Ç¼£¬ÈËÁ¦×ÊÔ´Ó¦ÓóÌÐò¿ÉÒÔÖ§³Ö¸´ÔÓµÄÔ±¹¤¼Ç¼Êý¾Ý·ÃÎÊÔÔò¡£
°¸Àý˵Ã÷
1. ´î½¨»·¾³--´´½¨Ä£Ê½ÓµÓÐÕߺÍÏàÓ¦µÄÓû§£¬¸³ÓèȨÏÞ
CONNECT sys/password@service AS SYSDBA;
CREATE USER schemaowner IDENTIFIED BY schemaowner
DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp;
GRANT connect, resource TO schemaowner;
CREATE USER user1 IDENTIFIED BY user1
DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp;
GRANT connect, resource TO user1;
CREATE USER user2 IDENTIFIED BY user2
DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp;
GR
Ïà¹ØÎĵµ£º
The following items are available in the network listener configuration file (listener.ora).
* Listener Address Section
* SID_LIST_listener_name Static Service Section
* Control Parameters
The listener.ora file is located in $ORACLE_HOME/n ......
±¾ÉíÕâ¸ö²½ÖèºÜ¶à¸ßÊÖ¶¼ÒѾÌù¹ýÁË£¬Ö»ÊÇÎÒÔÚʹÓÃÖз¢ÏÖ´óÌåÉÏ´ó¼ÒдµÄ¶¼ÓÐЩ¸´ÔÓ£¬ÓÚÊÇ£¬ÎÒ×ܽáÁ˸ö³¬¼¶¼ò»¯°æµÄ£¬·½±ã´ó¼ÒʹÓãº
1.°²×°LOGMNR°ü£¬ÐèÒª±¾²½Öèûʲô¿É¶à˵µÄ£¬Ö»ÊÇÐèҪעÒâÔÚÁ¬½ÓÊý¾Ý¿âµÄʱºòĬÈÏ×îºÃʹÓñ¾µØÑéÖ¤·½Ê½
C:\>sqlplus /nolog
SQL> conn / as sysdba
SQL> @D:\oracle\product\10 ......
»ù±¾µÄSql±àдעÒâÊÂÏî
¾¡Á¿ÉÙÓÃIN²Ù×÷·û£¬»ù±¾ÉÏËùÓеÄIN²Ù×÷·û¶¼¿ÉÒÔÓÃEXISTS´úÌæ¡£
²»ÓÃNOT IN²Ù×÷·û£¬¿ÉÒÔÓÃNOT EXISTS»òÕßÍâÁ¬½Ó+Ìæ´ú¡£
OracleÔÚÖ´ÐÐIN×Ó²éѯʱ£¬Ê×ÏÈÖ´ÐÐ×Ó²éѯ£¬½«²éѯ½á¹û·ÅÈëÁÙʱ±íÔÙÖ´ÐÐÖ÷²éѯ¡£¶øEXISTÔòÊÇÊ×Ïȼì²éÖ÷²éѯ£¬È»ºóÔËÐÐ×Ó²éѯֱµ½ÕÒµ½µÚÒ»¸öÆ¥ÅäÏî¡£NOT EXISTS±ÈNOT INЧÂÊ ......
select * from user_recyclebin where original_name like 'FINANCE_%' order by droptime desc;
FLASHBACK TABLE FINANCE_CASE_FEE_ITEM TO BEFORE DROP
¼´ËùÓÐdropµÄ±í¶¼ÔÚ user_recyclebin Õâ¸öoracle»ØÊÕÕ¾ÀïÃæµÄ£¬ÔÙͨ¹ýflashbackÃüÁԼ´¿É¡£
¿´ÁËÍøÉÏ»¹¿ÉÒÔͨ¹ýµ÷Õûoracleʱ¼ä £¬»Øµ½É¾³ýµÄÄ ......
Ëæ×Å΢ÈíÐÂÒ»´ú²Ù×÷ϵͳ Windows7 µÄÕýʽ·¢ÐУ¬Ê¹Óà Windows7 µÄÅóÓÑÒ²Ô½À´Ô½¶à£¬ºÜ¶àÈËÔÚ Windows7 »·¾³Ï°²×° Oracle »ò¶à»òÉÙÓöµ½ÁËһЩÎÊÌ⣬ÓеÄÉõÖÁ·¢³ö“Windows7ÎÞ·¨°²×°Oracle”µÄ¸Ð¿®¡£½ñÌì±ÊÕß½áºÏͼÎĺʹó¼Ò·ÖÏíÒ»ÏÂÔÚWindows7»·¾³ÏÂÈçºÎ³É¹¦°²×°OracleÊý¾Ý¿â¡£
&n ......