ORACLEÊý¾Ýµ¼Èëµ½Ö¸¶¨µÄ±í¿Õ¼ä
create user Óû§Ãû identified by ÃÜÂë default tablespace ȱʡ±í¿Õ¼ä¡¡Temporary tablespace ÁÙʱ±í¿Õ¼ä;
grant connect,resource,dba to Óû§Ãû;
¡¡¡¡
revoke unlimited tablespace from Óû§Ãû;
¡¡¡¡
alter user Óû§Ãû quota 0 on Users;
alter user Óû§Ãû¡¡quota unlimited on Óû§È±Ê¡±í¿Õ¼ä;
--¹Ø¼üÊǺóÃæ3ÐÐÃüÁ±ØÐëÖ´ÐС£
--½Ó×ÅʹÓÃIMP¹¤¾ßµ¼ÈëÊý¾Ý¼´¿Éµ¼Èëµ½Óû§È±Ê¡±í¿Õ¼ä.
--EXAMPLE: USER NAME: GROUPCMS; tablespace:GROUPCMS
--DROP USER GROUPCMS CASCADE;
create user GROUPCMS identified by ABC123 default tablespace GROUPCMS¡¡ ;
grant connect,resource,dba to GROUPCMS;
revoke unlimited tablespace from GROUPCMS;
alter user GROUPCMS quota 0 on Users;
alter user GROUPCMS¡¡quota unlimited on GROUPCMS;
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
ÏîÄ¿¿ª·¢ÖУ¬ÐèÒªÔ¶³Ì±¸·ÝÊý¾Ý¿â£¬ÒÔÏÂΪC#Ô¶³Ì±¸·ÝÊý¾Ý¿âµÄ´úÂë
/// <summary>
/// Êý¾Ý¿â±¸·Ý
/// </summary>
/// <param name="fileName">dmpÎļþÃû³Æ</param>
/// <param name="logFileName">logÎļþÃû³Æ</param>
/// <re ......
1.GSD global services daemon
oracle¹Ù·½ÎĵµµÄÃèÊö
The Global Services Daemon (GSD) runs on each node with one GSD process per node. The GSD coordinates with the cluster manager to receive requests from clients such as the DBCA, EM, and the SRVCTL utility to execute administrative ......
declare
STR VARCHAR2(400);
begin
-- ÖØ½¨ORACLEË÷Òý
FOR TMP_IDX IN (SELECT TABLESPACE_NAME, OWNER, TABLE_NAME, INDEX_NAME
&nb ......