oracle ÐÂÔöÓû§,ÉèÖÃȨÏÞ
ÿ¸öOracleÓû§¶¼ÓÐÒ»¸öÃû×ֺͿÚÁî,²¢ÓµÓÐһЩÓÉÆä´´½¨µÄ±í¡¢ÊÓͼºÍÆäËû×ÊÔ´¡£Oracle½ÇÉ«£¨role£©¾ÍÊÇÒ»×éȨÏÞ£¨privilege£©(»òÕßÊÇÿ¸öÓû§¸ù¾ÝÆä״̬ºÍÌõ¼þËùÐèµÄ·ÃÎÊÀàÐÍ)¡£Óû§¿ÉÒÔ¸ø½ÇÉ«ÊÚÓè»ò¸³ÓèÖ¸¶¨µÄȨÏÞ£¬È»ºó½«½ÇÉ«¸³¸øÏàÓ¦µÄÓû§¡£Ò»¸öÓû§Ò²¿ÉÒÔÖ±½Ó¸øÆäËûÓû§ÊÚȨ¡£
Êý¾Ý¿âϵͳȨÏÞ£¨Database System Privilege£©ÔÊÐíÓû§Ö´ÐÐÌض¨µÄÃüÁ¡£ÀýÈ磬CREATE TABLEȨÏÞÔÊÐíÓû§´´½¨±í£¬GRANT ANY PRIVILEGE ȨÏÞÔÊÐíÓû§ÊÚÓèÈκÎϵͳȨÏÞ¡£
Êý¾Ý¿â¶ÔÏóȨÏÞ£¨Database Object Privilege£©Ê¹µÃÓû§Äܹ»¶Ô¸÷¸ö¶ÔÏó½øÐÐijЩ²Ù×÷¡£ÀýÈçDELETEȨÏÞÔÊÐíÓû§É¾³ý±í»òÊÓͼµÄÐУ¬SELECTȨÏÞÔÊÐíÓû§Í¨¹ýselect´Ó±í¡¢ÊÓͼ¡¢ÐòÁУ¨sequences£©»ò¿ìÕÕ £¨snapshots£©ÖвéѯÐÅÏ¢¡£
Ò»¡¢´´½¨Óû§
OracleÄÚ²¿ÓÐÁ½¸ö½¨ºÃµÄÓû§£ºSYSTEMºÍSYS¡£Óû§¿ÉÖ±½ÓµÇ¼µ½SYSTEMÓû§ÒÔ´´½¨ÆäËûÓû§£¬ÒòΪSYSTEM¾ßÓд´½¨±ðµÄÓû§µÄȨÏÞ¡£ÔÚ°²×°Oracleʱ£¬Óû§»òϵͳ¹ÜÀíÔ±Ê×ÏÈ¿ÉÒÔΪ×Ô¼º½¨Á¢Ò»¸öÓû§¡£ÀýÈ磺
create user user01 identified by u01;
¸ÃÃüÁ¿ÉÒÔÓÃÀ´ÉèÖÃÆäËûȨÏÞ£¬ÏêϸÇé¿ö²Î¼û×Ôѧ×ÊÁÏ¡£Òª¸Ä±äÒ»¸ö¿ÚÁ¿ÉÒÔʹÓÃalter userÃüÁ
alter user user01 identified by usr01;
ÏÖÔÚuser01µÄ¿ÚÁîÒÑÓÉ“u01”¸ÄΪ“usr01”¡£
³ýÁËalter userÃüÁîÒÔÍ⣬Óû§»¹¿ÉÒÔʹÓÃpasswordÃüÁî¡£Èç¹ûʹÓÃpasswordÃüÁÓû§ÊäÈëµÄпÚÁ²»ÔÚÆÁÄ»ÉÏÏÔʾ¡£ÓÐdbaÌØȨµÄÓû§¿ÉÒÔͨ¹ýpasswordÃüÁî¸Ä±äÈκÎÆäËûÓû§µÄ¿ÚÁÆäËûÓû§Ö»Äܸıä×Ô¼ºµÄ¿ÚÁî¡£
µ±Óû§ÊäÈëpasswordÃüÁîʱ£¬ÏµÍ³½«ÌáʾÓû§ÊäÈë¾É¿ÚÁîºÍпÚÁÈçÏÂËùʾ£º
password
Changing password for user01
Old password:
New password:
Retype new password:
µ±³É¹¦µØÐÞ¸ÄÁË¿ÚÁîʱ£¬Óû§»áµÃµ½Èçϵķ´À¡£º
Password changed
¶þ¡¢É¾³ýÓû§
ɾ³ýÓû§£¬¿ÉÒÔʹÓÃdrop userÃüÁÈçÏÂËùʾ£º
drop user user01;
Èç¹ûÓû§ÓµÓжÔÏó£¬Ôò²»ÄÜÖ±½Óɾ³ý£¬·ñÔò½«·µ»ØÒ»¸ö´íÎóÖµ¡£Ö¸¶¨¹Ø¼ü×ÖCASCADE£¬¿Éɾ³ý
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹ÔÓ뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ©ÖÐÖ´ÐУ¬
......
ORACLEûÓÐÏóSQL SERVERÖÐÒ»ÑùµÄ×ÔÔö¼Ó×ֶΣ¬ÒªÊµÏÖÖ»ÄÜͨ¹ýSEQUENCEÀ´ÊµÏÖ
1.´´½¨ÐòÁУº
create sequence your_seq
nocycle
maxvalue 9999999999
start with 1;
2.ʹÓô¥·¢Æ÷ʵÏÖ×ÔÔö£º
create or replace trigger your_seq_tri
before insert on your_table1 for each row
declare
next_id number;
begin
se ......
--´´½¨´¥·¢Æ÷£¨Ðм¶´¥·¢Æ÷£©
create or replace trigger tri_update_emp_bak
after update
on emp_bak
for each row --ÿ¸üÐÂÒ»ÐÐ ¾Í´¥·¢Ò»´Î
begin
--oracle ÀïÃæ ¶Ô´¥·¢Æ÷ Ò²ÌṩÁËÌØÊâµÄ¶ÔÏó :NEW :OLD À´·ÃÎÊ ¸üÐÂÇ°ºóµÄÊý¾Ý
dbms_output.put_line('¸üкó' || :NEW.sal);
dbms_outpu ......
±¾ÎĽÚÑ¡×Ô¡¶Oracle DBAÊּǗ—Êý¾Ý¿âÕï¶Ï°¸ÀýÓëÐÔÄÜÓÅ»¯Êµ¼ù¡·µÚ1Õ“EygleµÄDBA¹¤×÷Êּǔ£¨×÷Õߣº¸Ç¹úÇ¿£©
DBAÈÕ³£¹¤×÷Ö°Ôð——ÎÒ¶ÔDBAµÄ7µã½¨Òé
DBAµÄ¹¤×÷Ö°ÔðÊÇʲô£¿Ã¿ÌìDBAÓ¦¸Ã×öÄÄЩ¹¤×÷£¿Îȶ¨»·¾³ÖеÄDBA¸ÃÈçºÎ³É³¤ÓëÓÅ»¯£¿ÕâÊǺܶàÈ˶¼Ôø¾Ìá³ö¹ýµÄÎÊÌ⣬ÏÂÃæÊÇÎҵĹ۵ãºÍ½¨Òé£ ......