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

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µÄ½â¾ö°ì·¨


 
 oracle 10g
°²×°Íê³Éºó,
怫EM
ÊäÈëϵͳÓû§ÃûºÍÃÜÂëºÍÊý¾Ý¿âÓû§ÃûºÍÃÜÂëºó,
µãÆô¶¯±¨´í,
¿ÉÄÜÊÇÒòΪÊý¾Ý¿âµÄ×´Ì¬Îª×°ÔØ»ò²»×°ÔØ,
ʼÖÕÎÞ·¨µÇ½½øEM
µÄ½â¾ö°ì·¨......
×´¿ö£º
´ò¿ªhttp://ty-:5500/em
£¬ÏµÍ³ÏÔʾÈçÏÂÐÅÏ¢£º
Êý¾Ý¿â״̬µ±Ç°²»¿ÉÓ᣿ÉÄÜÊÇÒòΪÊý¾Ý¿âµÄ×´Ì¬Îª×°ÔØ»ò²»×°ÔØ¡£µ¥»÷ ......

oracle »ù´¡

½ñÌì¸Õ×°ÁË oracle
¼Ç¼һ²¿·Ö´úÂë ÒÔ±¸Ê¹ÓÃ
cmd²Ù×÷
Á¬½ÓÊý¾Ý¿â sqlplus "Óû§Ãû/ÃÜÂë"
²»Çø·Ö´óСд
c/Ô­´Ê/Ð޸ĺ󠠠 ÐÞ¸ÄsqlÓï¾ä
lÊý×Ö  Êý×Ö  ÏÔʾ¼¸Ðе½¼¸ºÅµÄsqlÓï¾ä
/Ö´ÐÐ
shutdown  ¹Ø±Õ·þÎñ
startup Æô¶¯·þÎñ
save ·¾¶/ÎļþÃû.ºó׺  ±£´æ»º³åÇøsqlÓï¾ä
get Îļþ ......

Oracle Database µÄѧϰ±Ê¼Ç

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 ......

RAWÉ豸ÓëORACLEµÄÎÊ´ð


1£®Ê²Ã´½Ð×öÂãÉ豸£¿
¡¡¡¡ÂãÉ豸£¬Ò²½ÐÂã·ÖÇø£¨Ô­Ê¼·ÖÇø£©£¬ÊÇÒ»ÖÖûÓо­¹ý¸ñʽ»¯£¬²»±»Unixͨ¹ýÎļþϵͳÀ´¶ÁÈ¡µÄÌØÊâ×Ö·ûÉ豸¡£ËüÓÉÓ¦ÓóÌÐò¸ºÔð¶ÔËü½øÐжÁд²Ù×÷¡£²»¾­¹ýÎļþϵͳµÄ»º³å¡£
2£®ÈçºÎ±æ±ðÂãÉ豸£¿
¡¡¡¡ÔÚUnixµÄ/dev Ŀ¼Ï£¬ÓÐÐí¶àÎļþ£¬ÆäÖÐÓÐÁ½¸ö´óÀࣺ×Ö·ûÉ豸ÎļþºÍ¿éÉ豸Îļþ¡£
¡¡¡¡×Ö·ûÉè±¸Ì ......

Oracle¶¨ÒåÔ¼Êø Íâ¼üÔ¼Êø

Íâ¼üÔ¼Êø±£Ö¤²ÎÕÕÍêÕûÐÔ¡£Íâ¼üÔ¼ÊøÏÞ¶¨ÁËÒ»¸öÁеÄȡֵ·¶Î§¡£Ò»¸öÀý×Ó¾ÍÊÇÏÞ¶¨ÖÝÃûËõдÔÚÒ»¸öÓÐÏÞÖµ¼¯ºÏÖУ¬Õâ¸öÖµ¼¯ºÏÊÇÁíÍâÒ»¸ö¿ØÖƽṹ——Ò»ÕŸ¸±í
    ÏÂÃæÎÒÃÇ´´½¨Ò»ÕŲÎÕÕ±í£¬ËüÌṩÁËÍêÕûµÄÖÝËõдÁÐ±í£¬È»ºóʹÓòÎÕÕÍêÕûÐÔÈ·±£Ñ§ÉúÃÇÓÐÕýÈ·µÄÖÝËõд¡£µÚÒ»ÕűíÊÇÖݲÎÕÕ±í£¬State×÷ΪÖ÷¼ü
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ