ORACLE³£Óýű¾ÃüÁî
Óû§µÄ¹ÜÀí
Ò»¡¢ORACLEµÄ°²È«Óò
1¡¢TABLESPACE QUOTAS£º±í¿Õ¼äµÄʹÓö¨¶î
2¡¢DEFAULT TABLESPACE£ºÄ¬Èϱí¿Õ¼ä
3¡¢TEMPORARY TABLESPACE£ºÖ¸¶¨ÁÙʱ±í¿Õ¼ä¡£
4¡¢ACCOUNT LOCKING£ºÓû§Ëø
5¡¢RESOURCE LIMITE£º×ÊÔ´ÏÞÖÆ
6¡¢DIRECT PRIVILEGES£ºÖ±½ÓÊÚȨ
7¡¢ROLE PRIVILEGES£º½ÇÉ«ÊÚȨÏȽ«Ó¦ÓÃÖеÄÓû§»®Îª²»Í¬µÄ½ÇÉ«£¬
¶þ¡¢´´½¨Óû§Ê±µÄÇåµ¥£º
1¡¢Ñ¡ÔñÒ»¸öÓû§Ãû³ÆºÍ¼ìÑé»úÖÆ£ºA£¬¿´µ½Óû§Ãû£¬Êµ¼Ê²Ù×÷ÕßÊÇË£¬ÒµÎñÖнÇÉ«¡£
2¡¢Ñ¡ÔñºÏÊʵıí¿Õ¼ä£º
3¡¢¾ö¶¨¶¨¶î£º
4¡¢¿ÚÁîµÄÑ¡Ôñ£º
5¡¢ÁÙʱ±í¿Õ¼äµÄÑ¡Ôñ£ºÏȽ¨Á¢Ò»¸öÁÙʱ±í¿Õ¼ä£¬È»ºóÔÚ·ÖÅä¡£²»·ÖÅ䣬ʹÓÃSYSTEM±í¿Õ¼ä
6¡¢CREATE USER
7¡¢ÊÚȨ£ºA£¬Óû§µÄ¹¤×÷Ö°ÄÜ
B£¬Óû§µÄ¼¶±ð
Èý¡¢Óû§µÄ´´½¨£º
1¡¢ÃüÁ
CREATE USER Ãû³Æ IDENTIFIED BY ¿ÚÁî DEFAULT TABLESPACE ĬÈϱí¿Õ¼äÃû TEMPOARAY
TABLESPACE ÁÙʱ±í¿Õ¼äÃû
QUOTA 15M ON ±í¿Õ¼äÃû
[PASSWORD EXPIRE]£ºµ±Óû§µÚÒ»´ÎµÇ½µ½ORACLE£¬´´½¨Ê±ËùÖ¸¶¨µÄ¿ÚÁî¹ýÆÚʧЧ£¬Ç¿ÆÈÓû§×Ô¼º¶¨ÒåÒ»¸öпÚÁî¡£
[ACCOUNT LOCK]£º¼ÓÓû§Ëø
QUOTA UNLIMITED ON TABLESPACE£º²»ÏÞÖÆ£¬ÓжàÉÙÓжàÉÙ¡£
[PROFILE Ãû³Æ]£ºÊÜPROFILEÎļþµÄÏÞÖÆ¡£
ËÄ¡¢ÈçºÎ¿ØÖÆÓû§¿ÚÁîºÍÓû§Ëø
1¡¢Ç¿ÆÈÓû§Ð޸ĿÚÁALTER USER Ãû³Æ IDENTIFIED BY пÚÁî PASSWORD EXPIRE£»
2¡¢¸øÓû§¼ÓËø£ºALTER USER Ãû³Æ ACCOUNT [LOCK|UNLOCK]
3¡¢×¢ÒâÊÂÏ
A¡¢ËùÓвÙ×÷¶Ôµ±Ç°Á¬½ÓÎÞЧ
B¡¢1µÄ²Ù×÷ÊÊÓÃÓÚµ±Óû§Íü¼Ç¿ÚÁîʱ¡£
Îå¡¢¸ü¸Ä¶¨¶î
1¡¢ÃüÁALTER USER Ãû³Æ QUOTA 0 ON ±í¿Õ¼äÃû
ALTER USER Ãû×Ö QUOTA £¨ÊýÖµ£©K|M|UNLIMITED ON ±í¿Õ¼äÃû£»
2¡¢Ê¹Ó÷½·¨£º
A¡¢¿ØÖÆÓû§Êý¾ÝÔö³¤
B¡¢µ±Óû§ÓµÓÐÒ»¶¨µÄÊý¾Ý£¬¶ø¹ÜÀíÔ±²»ÏëÈÃËûÔÚÔö¼ÓеÄÊý¾ÝµÄʱºò¡£
C¡¢µ±½«Óû§¶¨¶îÉèΪÁãµÄʱºò£¬Óû§²»ÄÜ´´½¨ÐµÄÊý¾Ý£¬µ«ÔÓÐÊý¾ÝÈÔ¿É·ÃÎÊ¡£
Áù¡¢DROPÒ»¸öUSER
1¡¢DROP USER Ãû³Æ
ÊʺÏÓÚɾ³ýÒ»¸öеÄÓû§
2¡¢DROP USER Ãû³Æ CASCADE£º ɾ³ýÒ»¸öÓû§£¬½«Óû§µÄ±í£¬Ë÷ÒýµÈ¶¼É¾³ý¡£
3¡¢¶ÔÁ¬½ÓÖеÄÓû§²»ºÃÓá£
Æß¡¢ÐÅÏ¢»ñÈ¡£º
1¡¢DBA_USERS:Óû§Ãû£¬×´Ì¬£¬¼ÓËøÈÕÆÚ£¬Ä¬Èϱí¿Õ¼ä£¬ÁÙʱ±í¿Õ¼ä
2¡¢DBA_TS_QUOTAS:Óû§Ãû£¬±í¿Õ¼äÃû£¬¶¨¶î¡£
Á½¸ö±íµÄÁ¬½Ó×ֶΣºUSERNAME
GRANT CREATE SESSION TO Óû§Ãû
PROFILEµÄ¹ÜÀí£¨×ÊÔ´
Îļþ£©
Ò»¡¢PROFILEµÄ¹ÜÀíÄÚÈÝ£º
1¡¢CPUµÄʱ¼ä
2¡¢I/OµÄʹÓÃ
3
Ïà¹ØÎĵµ£º
oracle 10g
°²×°Íê³Éºó,
怫EM
ÊäÈëϵͳÓû§ÃûºÍÃÜÂëºÍÊý¾Ý¿âÓû§ÃûºÍÃÜÂëºó,
µãÆô¶¯±¨´í,
¿ÉÄÜÊÇÒòΪÊý¾Ý¿âµÄ×´Ì¬Îª×°ÔØ»ò²»×°ÔØ,
ʼÖÕÎÞ·¨µÇ½½øEM
µÄ½â¾ö°ì·¨......
×´¿ö£º
´ò¿ªhttp://ty-:5500/em
£¬ÏµÍ³ÏÔʾÈçÏÂÐÅÏ¢£º
Êý¾Ý¿â״̬µ±Ç°²»¿ÉÓ᣿ÉÄÜÊÇÒòΪÊý¾Ý¿âµÄ×´Ì¬Îª×°ÔØ»ò²»×°ÔØ¡£µ¥»÷ ......
½ñÌì¸Õ×°ÁË oracle
¼Ç¼һ²¿·Ö´úÂë ÒÔ±¸Ê¹ÓÃ
cmd²Ù×÷
Á¬½ÓÊý¾Ý¿â sqlplus "Óû§Ãû/ÃÜÂë"
²»Çø·Ö´óСд
c/Ô´Ê/Ð޸ĺó ÐÞ¸ÄsqlÓï¾ä
lÊý×Ö Êý×Ö ÏÔʾ¼¸Ðе½¼¸ºÅµÄsqlÓï¾ä
/Ö´ÐÐ
shutdown ¹Ø±Õ·þÎñ
startup Æô¶¯·þÎñ
save ·¾¶/ÎļþÃû.ºó׺ ±£´æ»º³åÇøsqlÓï¾ä
get Îļþ ......
SQL:½á¹¹»¯²éѯÓïÑÔ
C R U D: Ôöɾ¸Ä²é
table : name age score
desc+±íÃû ---> ²éѯ±í½á¹¹
»òÕßÓà describe ÃüÁî (descÊÇdescribeµÄ¼òд)
²éѯÓïÑÔ£ºSELECT [DISTINCT] {*,column[alias],...} from table;
SELECT identifies what columns from identifies which tab ......
1£®Ê²Ã´½Ð×öÂãÉ豸£¿
¡¡¡¡ÂãÉ豸£¬Ò²½ÐÂã·ÖÇø£¨Ôʼ·ÖÇø£©£¬ÊÇÒ»ÖÖûÓо¹ý¸ñʽ»¯£¬²»±»Unixͨ¹ýÎļþϵͳÀ´¶ÁÈ¡µÄÌØÊâ×Ö·ûÉ豸¡£ËüÓÉÓ¦ÓóÌÐò¸ºÔð¶ÔËü½øÐжÁд²Ù×÷¡£²»¾¹ýÎļþϵͳµÄ»º³å¡£
2£®ÈçºÎ±æ±ðÂãÉ豸£¿
¡¡¡¡ÔÚUnixµÄ/dev Ŀ¼Ï£¬ÓÐÐí¶àÎļþ£¬ÆäÖÐÓÐÁ½¸ö´óÀࣺ×Ö·ûÉ豸ÎļþºÍ¿éÉ豸Îļþ¡£
¡¡¡¡×Ö·ûÉè±¸Ì ......
Íâ¼üÔ¼Êø±£Ö¤²ÎÕÕÍêÕûÐÔ¡£Íâ¼üÔ¼ÊøÏÞ¶¨ÁËÒ»¸öÁеÄȡֵ·¶Î§¡£Ò»¸öÀý×Ó¾ÍÊÇÏÞ¶¨ÖÝÃûËõдÔÚÒ»¸öÓÐÏÞÖµ¼¯ºÏÖУ¬Õâ¸öÖµ¼¯ºÏÊÇÁíÍâÒ»¸ö¿ØÖƽṹ——Ò»ÕŸ¸±í
ÏÂÃæÎÒÃÇ´´½¨Ò»ÕŲÎÕÕ±í£¬ËüÌṩÁËÍêÕûµÄÖÝËõдÁÐ±í£¬È»ºóʹÓòÎÕÕÍêÕûÐÔÈ·±£Ñ§ÉúÃÇÓÐÕýÈ·µÄÖÝËõд¡£µÚÒ»ÕűíÊÇÖݲÎÕÕ±í£¬State×÷ΪÖ÷¼ü
......