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

ÈçºÎÓÃODBCÁ¬½ÓOracleÊý¾Ý¿â - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒÔÚOracleÖн¨Á¢ÁËÒ»¸östudent±í£¬È»ºóÏÖÔÚÔÚvcÖвÙ×÷£¬¿ÉÊÇÔÚvcµÄÏòµ¼ÖÐÓöµ½ÁËÎÊÌ⣬ÔÚDatabase optionsÖÐODBCÎÒÑ¡ÔñÁËorcl£¬recordset typeÑ¡ÔñÁËdynaset£¬ÎÒµ¥»÷okºóµ¯³öOracle ODBC driver connect¶Ô»°¿òuser nameдsysÔõô¶¼Ã»ÓÃÓÚÊÇÎÒ×Ô¼ºÔÚ´´½¨ÁËÒ»¸öÓû§lijin£¬½øÈëµ½select database tables¶Ô»°¿òÖУ¬ÔÚÕâ¸ö¶Ô»°¿òÖоÓÈ»ÕÒ²»µ½studentÕâ¸ö±í£¬¸ßÈËÖ¸µãÒ»ÏÂÒªÔõô×ö£¿£¿£¿
Èç¹û¿ÉÒÔÕý³£Á¬½Óµ½Êý¾Ý¿â
ÐèҪʹÓÃschema À´·ÃÎÊÊý¾Ý¿â¡£
Æä´ÎÊÇ·ñ¶Ô¸ÃÓû§ÊÚÓèÁËselect ȨÏÞ

grant select on schema.talbename to lijin

½øÈëµ½select database tables¶Ô»°¿òÖУ¬ÔÚÕâ¸ö¶Ô»°¿òÖоÓÈ»ÕÒ²»µ½studentÕâ¸ö±í,¾ÍÊÇÕâ¸ö²»ÖªµÀ¸ÃÔõô°ì°¡

ͬһ¥£¬¾õµÃÓ¦¸ÃÊÇȨÏÞÎÊÌâ

ÎÒÔÚÃüÁîÖмÓÁËÕâÌõÃüÁîGRANT UNLIMITED TABLESPACE TO "linjin"°ÑËùÓбí¿Õ¼äµÄʹÓÃȨ¶¼¸ølijin£¬¿ÉÊǽøÈëµ½select database tables¶Ô»°¿òÖУ¬»¹ÊÇÕÒ²»µ½studentÕâ¸ö±í£¬ÀïÃæ¸ü±¾¾ÍûÓÐlijinÕâ¸öÓû§´æÔÚ¡£µ½µ×ÒªÔõô×ö°¡£¬Äܲ»ÄÜÏêϸµã

grant select anytable to lijin

ÒýÓÃ
grant select anytable to lijin

ÄãÕâ¸öÓï¾äû·¨Ö´ÐУ¬ÌáʾȨÏÞȱʧ»òÎÞЧ¡£

ÓÃusername/password as sysdbaµÇ½
grant select on table to user1;

ÎÒÔÚOracleÖн¨Á¢ÁËÒ»¸östudent±í£¬È»ºóÏÖÔÚÔÚvcÖвÙ×÷£¬¿ÉÊÇÔÚvcµÄÏòµ¼ÖÐÓöµ½ÁËÎÊÌ⣬ÔÚDatabase optionsÖÐODBCÎÒÑ¡ÔñÁËorcl£¬recordset typeÑ¡ÔñÁËdynaset£¬ÎÒµ¥»÷okºóµ¯³öOracle ODBC driver connect¶Ô»°¿òuser nameдsysÔõô¶¼Ã»ÓÃÓÚÊÇÎÒ×Ô¼ºÔÚ´´½¨ÁËÒ»¸öÓû§lijin£¬½øÈëµ½select database tables¶Ô»°¿òÖУ¬ÔÚÕâ¸ö¶Ô»°¿òÖоÓÈ»ÕÒ²»µ½studentÕâ¸ö±í£¬¸ßÈË


Ïà¹ØÎÊ´ð£º

oracle²¢·¢´¦ÀíSOS - Oracle / ¿ª·¢

ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾ­ºÜ³ÉÊìÁË

ÒýÓÃ
oracle ......

oracleÓëaix - Oracle / ¸ß¼¶¼¼Êõ

ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼­¾íºÅlv04 
#lslv -l lv04 ......

JavaÖ®¸¸À뿪Oracle£¬±¯Í´°¡£¡£¡ - Java / ·Ç¼¼ÊõÇø

¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬
ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡
OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Âð£¿
SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......

oracle 10g data guard - Oracle / »ù´¡ºÍ¹ÜÀí

×öÍædata guard ºó
ÔÚPrimary·þÎñÆ÷ Ö´ÐР
SQL>SELECT SEQUENCE#,APPLIED from V$ARCHIVED_LOG ORDER BY SEQUENCE#;
 SEQUENCE# APP
---------- ---
  13 NO
  13 YES ......

OracleÈÏÖ¤ - Oracle / ÈÏÖ¤Ó뿼ÊÔ

ORACLEÅàѵ(OCA)ÈÏÖ¤½éÉÜ 
Oracle10g Certified Associate (OCA) Oracle ÈÏ֤רԱ¡£
¿¼ÊԳɼ¨Í¨¹ýÄÜ»ñµÃOracle¹«Ë¾ÎªÄú°ä·¢µÄÈ«ÇòÈÏÖ¤µÄÓ¢ÎÄOCAÖ¤Êé¡£OCAÓÉOracle¹«Ë¾³öÌâ¡£
¸ÃÖ¤Êé¿É×÷Ϊ¸÷ÆóÊÂÒµµ¥Î»Êý¾Ý¿ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ