28.2 OracleÊý¾Ý¿â·þÎñÆ÷µÄ°²×°
28.2 OracleÊý¾Ý¿â·þÎñÆ÷µÄ°²×°
Óû§¿ÉÒÔͨ¹ýOracleµÄ¹Ù·½ÍøÕ¾ÏÂÔØµ½×îеÄOracleÊý¾Ý¿â²úÆ·µÄÈí¼þ°²×°°ü£¬ÔÚ°²×°Oracle 11gǰÐèÒª¼ì²éϵͳµÄÈíÓ²¼þ»·¾³ÊÇ·ñ·ûºÏ°²×°ÒªÇó¡£Oracle 11gÌṩͼÐλ¯µÄ°²×°³ÌÐò½çÃæ£¬Óû§¿ÉÒÔͨ¹ýµ¥»÷Êó±êÍê³ÉOracleµÄ°²×°¡£
Ïà¹ØÎĵµ£º
1.²é¿´ËùÓÐÓû§£º
select * from dba_users;
select * from all_users;
select * from user_users;
2.²é¿´Óû§»ò½ÇɫϵͳȨÏÞ(Ö±½Ó¸³Öµ¸øÓû§»ò½ÇÉ«µÄϵͳȨÏÞ)£º
select * from dba_sys_privs;
select * from user_sys_privs;
3.²é¿´½ÇÉ«(Ö»Äܲ鿴µÇ½Óû§ÓµÓеĽÇÉ«)Ëù°üº¬µÄÈ ......
Ò». Ora-24801:ÔÚOCI_lobº¯ÊýÖзǷ¨µÄ²ÎÊýÖµ
°ÑÒ»Õź¬ÓГ±¸×¢”×ֶεıíͨ¹ýODBCµ¼³öµ½OracleµÄʱºòÒ»Ö±³öÏÖÈçÉÏͼËùʾµÄÌáʾÐÅÏ¢¡£³¢ÊÔÈ¥µôÏà¹Ø×Ö¶ÎÖпոñ×Ö·û£¬È¥µô×Ö¶ÎΪ¿ÕµÄ¼Ç¼£¬»¹Êǵ¼³öʧ°Ü¡£×îºóżȻ·¢ÏÖ£¬ÖØÐ½¨Ò»ÕÅÏàͬ½á¹¹µÄ¿Õ±í£¬È»ºó¸´ÖÆÔ±íµÄ¼Ç¼£¬ÔÙÕ³Ìùµ½Ð±íÖУ¬µ¼³öµ½Oracle¾ ......
µÚ28Õ Oracle·þÎñÆ÷ÅäÖú͹ÜÀí
ÌáÆðÊý¾Ý¿â£¬µÚÒ»¸öÏëÆðµÄ¹«Ë¾Ò»°ã¶¼»áÊÇOracle¡£Oracle¹«Ë¾ÓÚ1977Äê³ÉÁ¢£¬×¨×¢ÓÚÊý¾Ý¿â²úÆ·µÄ¿ª·¢£¬ÔÚÊý¾Ý¿âÁìÓòÒ»Ö±¶¼´¦ÓÚÁìÏȵØÎ»£¬Æä²úÆ·¸²¸ÇÁË´ó¡¢ÖС¢Ð¡ÐÍ»úµÈÊýÊ®ÖÖ»úÐÍ£¬ÊÇĿǰÊÀ½çÉÏʹÓÃ×î¹ã·ºµÄ¹ØÏµÊý¾Ý¿âϵͳ֮һ¡£±¾½ÚÒÔÆä×îеÄÊý¾Ý¿â²úÆ·Oracle 11gΪÀý£¬½éÉÜÈçºÎÔÚRed ......
28.1 Oracle 11g¼ò½é
¾¹ýÁËÈýÄêµÄ×¼±¸£¬Oracle£¨¼×¹ÇÎÄ£©¹«Ë¾ÓÚ2007Äê7ÔÂ12ÈÕÔÚÈ«Çò·¶Î§ÄÚͬ²½ÍƳöÁËÆä×îа汾µÄÊý¾Ý¿â²úÆ·——Oracle 11g¡£ÐµÄOracleÊý¾Ý¿âÈÔÈ»ÒÔg×÷Ϊ°æ±¾ºó׺£¬ÒÔ´ú±íÕâÊÇÒ»¸ö°üº¬ÁËÍø¸ñ¼ÆËã¼¼ÊõµÄÊý¾Ý¿âÈí¼þ£¨Oracle×Ô10°æ±¾¿ªÊ¼ÒÔg×÷Ϊ°æ±¾ºó׺£¬¶øÔÚÕâ֮ǰÊÇʹÓÃi£¬ÈçOracle 8i¡¢ ......