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

[ת]Oracle½ÇÉ«¡¢È¨ÏÞ

OracleÄÚÖýÇÉ«connectÓëresourceµÄȨÏÞ
============================================================
Ò»¡¢ºÎΪ½ÇÉ«£¿
¡¡¡¡Èç¹ûÓÐÒ»×éÈË£¬ËûÃǵÄËùÐèµÄȨÏÞÊÇÒ»ÑùµÄ£¬¶ÔËûÃǵÄȨÏÞ½øÐйÜÀíµÄʱºò»á²»·½±ã¡£ÒòΪÄãÒª¶ÔÕâ×éÖеÄÿ¸öÓû§µÄȨÏÞ¶¼½øÐйÜÀí¡£
¡¡¡¡ÓÐÒ»¸öºÜºÃµÄ½â¾ö°ì·¨¾ÍÊÇ£º½ÇÉ«¡£½ÇÉ«ÊÇÒ»×éȨÏ޵ļ¯ºÏ£¬½«½ÇÉ«¸³¸øÒ»¸öÓû§£¬Õâ¸öÓû§¾ÍÓµÓÐÁËÕâ¸ö½ÇÉ«ÖеÄËùÓÐȨÏÞ¡£ÄÇôÉÏÊöÎÊÌâ¾ÍºÜºÃ´¦ÀíÁË£¬Ö»ÒªµÚÒ»´Î½«½ÇÉ«¸³¸øÕâÒ»×éÓû§£¬½ÓÏÂÀ´¾ÍÖ»ÒªÕë¶Ô½ÇÉ«½øÐйÜÀí¾Í¿ÉÒÔÁË¡£ Æäʵ£º½ÇÉ«¾ÍÊÇÒ»×éȨÏ޵ļ¯ºÏ¡£ÏÂÃæ·ÖÁ½¸ö²¿·ÖÀ´¶Ôoracle½ÇÉ«½øÐÐ˵Ã÷¡£ 
============================================================ 
 ¶þ¡¢ÏµÍ³Ô¤¶¨Òå½ÇÉ«
¡¡¡¡Ô¤¶¨Òå½ÇÉ«ÊÇÔÚÊý¾Ý¿â°²×°ºó£¬ÏµÍ³×Ô¶¯´´½¨µÄһЩ³£ÓõĽÇÉ«¡£Ï½é¼òµ¥µÄ½éÉÜÒ»ÏÂÕâЩԤ¶¨½ÇÉ«¡£½ÇÉ«Ëù°üº¬µÄȨÏÞ¿ÉÒÔÓÃÒÔÏÂÓï¾ä²éѯ£º
sql>select * from role_sys_privs where role='½ÇÉ«Ãû';  (×¢Òâ:ÕâÀïµÄROLE¾­¹ýϵͳ×Ô¶¯×ª»¯Îª´óд,²éѯµÄʱºòÒª´óд)
»òÕß
select grantee,privilege from dba_sys_privs
where grantee   =   '½ÇÉ«Ãû'   order by privilege;
¾ÙÀý:²é¿´RESOURCE½ÇÉ«µÄȨÏÞ
select grantee,privilege from dba_sys_privs  where grantee   =   'RESOURCE'   order by privilege;
GRANTEE   PRIVILEGE
------------      ----------------------
RESOURCE CREATE CLUSTER
RESOURCE CREATE INDEXTYPE
RESOURCE CREATE OPERATOR
RESOURCE CREATE PROCEDURE
RESOURCE CREATE SEQUENCE
RESOURCE CREATE TABLE
RESOURCE CREATE TRIGGER
RESOURCE CREATE TYPE
¸³ÓèuserÓû§connect½ÇÉ«ºÍresource½ÇÉ«£º
grant connect,resource to user;
ÔËÐгɹ¦ºóÓû§°üÀ¨µÄȨÏÞ:
CONNECT½ÇÉ«£º --ÊÇÊÚÓè×îÖÕÓû§µÄµäÐÍȨÀû£¬×î»ù±¾µÄ
ALTER SESSION --Ð޸ĻỰ
CREATE CLUSTER --½¨Á¢¾Û´Ø
CREATE DATABASE LINK --½¨Á¢Êý¾Ý¿âÁ´½Ó
CREATE SEQUENCE --½¨Á¢ÐòÁÐ
CREATE SESSION --½¨Á¢»á»°
CREATE SYNONYM --½¨Á¢Í¬Òå´Ê
CREATE VIEW --½¨Á¢ÊÓͼ
RESOURCE ½ÇÉ«£º --ÊÇÊÚÓ迪·¢ÈËÔ±µÄ
CREATE CLUSTER --½¨Á¢¾Û´Ø
CREATE PROCEDURE --½¨Á¢¹ý³Ì
CREATE SEQUENCE --½¨Á¢ÐòÁÐ
CREATE TABLE --½¨±í


Ïà¹ØÎĵµ£º

oracle¸´Ï°£¨Èý£© Ö®OracleÊý¾Ý×ÖµäºÍ¿ØÖÆÎļþ

      ½ñÌ츴ϰOracleµÄÊý¾Ý×ÖµäºÍ¿ØÖÆÎļþ¡£
Ò»¡¢Êý¾Ý×Öµä
      Êý¾Ý×ÖµäÊÇÓÉOracle·þÎñÆ÷´´½¨ºÍά»¤µÄÒ»×éÖ»¶ÁµÄϵͳ±í£¬Êý¾Ý×Öµä·ÖΪÁ½´óÀࣺһÀàΪ»ù±í£¬Ò»ÀàΪÊý¾Ý×ÖµäÊÓͼ¡£ÄÇôÊý¾Ý×ÖµäÖÐÓÖ´æÓÐÄÄЩÐÅÏ¢ÄØ£¿
1¡¢Êý¾Ý¿âµÄÂß¼­½á¹¹ºÍÎïÀí½á¹¹
2¡¢ËùÓÐÊý¾Ý¿â¶Ô ......

Oracle ³£ÓÃSQL


1¡¢²é¿´±í¿Õ¼äµÄÃû³Æ¼°´óС
select t.tablespace_name, round(sum(bytes/(1024*1024)),0) ts_size
from dba_tablespaces t, dba_data_files d
where t.tablespace_name = d.tablespace_name
group by t.tablespace_name;
2¡¢²é¿´±í¿Õ¼äÎïÀíÎļþµÄÃû³Æ¼°´óС
select tablespace_name, file_id, file_name,
round(by ......

ORACLEºÍSQLÓï·¨Çø±ð¹éÄÉ

ORACLEºÍSQLÓï·¨Çø±ð¹éÄÉ
Êý¾ÝÀàÐͱȽÏ
ÀàÐÍÃû³Æ
Oracle
SQLServer
±È½Ï
×Ö·ûÊý¾ÝÀàÐÍ CHAR CHAR ¶¼Êǹ̶¨³¤¶È×Ö·û×ÊÁϵ«oracleÀïÃæ×î´ó¶ÈΪ2kb£¬SQLServerÀïÃæ×î´ó³¤¶ÈΪ8kb
±ä³¤×Ö·ûÊý¾ÝÀàÐÍ VARCHAR2 VARCHAR OracleÀïÃæ×î´ó³¤¶ÈΪ4kb£¬SQLServerÀïÃæ×î´ó³¤¶ÈΪ8kb
¸ù¾Ý×Ö·û¼¯¶ø¶¨µÄ¹Ì¶¨³¤¶È×Ö·û´® NCHAR NCHA ......

OracleËø»úÖÆ

      ÔÚ´óÐÍÊý¾Ý¿âÖУ¬Ò»·½ÃæÊý¾Ý¿âÒªÌṩ¸ß²¢·¢·ÃÎʵÄÄÜÁ¦£¬ÓÖÒª±£Ö¤Ã¿Ò»¸öÓû§ÒÔÒ»Öµķ½Ê½·ÃÎʺÍÐÞ¸ÄÊý¾Ý¡£Ëø»úÖÆ¾ÍÊÇÓÃÀ´½â¾öÕâÒ»ÎÊÌ⣬ÓÃÓÚ¿ØÖƶԹ²Ïí×ÊÔ´µÄ²¢·¢·ÃÎÊ£¬±£Ö¤Êý¾Ý·ÃÎʵÄÒ»ÖÂÐÔºÍ׼ȷÐÔ¡£
      
      ÔÚoracleÖУ ......

[×ªÔØ]Oracle¿ª·¢ÓëʹÓÃÎÄÕÂÊÕ²Ø

ÊÕ¼¯Ò»Ð©Oracle¿ª·¢ÓëʹÓÃÎÄÕÂ,ÒÔ±ãÓÚºóÐø²éÕÒ.
¡¾»ù´¡Àà¡¿
1.ORACLEº¯Êý´óÈ«
2.Orace³£Óú¯Êý
3.oracle ÈÕÆÚº¯Êý½éÉÜ
4.OracleÖг£ÓõÄto_CharÓ÷¨Ïê½â£¨ÓÐFMTµÄÏêϸÁÐ±í£©
5.ORACLEÖÐÈÕÆÚºÍʱ¼äº¯Êý»ã×Ü(×ªÔØ)
6.SQL ServerºÍOracle³£Óú¯Êý¶Ô±È
7.Oracleº¯ÊýÏê½â
8.Oracle ·ÖÎöº¯ÊýµÄʹÓÃ
9.Oracle for ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ