oracle ±í¿Õ¼ä ±íȨÏÞ Óû§
Æô¶¯Êý¾Ý¿âÃüÁî·ÖΪÈý¸ö½×¶Î£º
startup nomount
alter database mount
alter database open
±¾Óû§¶ÁÈ¡ÆäËûÓû§¶ÔÏóµÄȨÏÞ:
¡¡¡¡select * from user_tab_privs;
±¾Óû§ËùÓµÓеÄϵͳȨÏÞ:
¡¡¡¡select * from user_sys_privs;
---------------------------------------------------------
ORACLEÖÐÊý¾Ý×ÖµäÊÓͼ·ÖΪ3´óÀà, ÓÃÇ°×ºÇø±ð£¬·Ö±ðΪ£ºUSER£¬ALL ºÍ DBA£¬Ðí¶àÊý¾Ý×ÖµäÊÓͼ°üº¬ÏàËÆµÄÐÅÏ¢¡£
USER_*:ÓйØÓû§ËùÓµÓеĶÔÏóÐÅÏ¢£¬¼´Óû§×Ô¼º´´½¨µÄ¶ÔÏóÐÅÏ¢
ALL_*£ºÓйØÓû§¿ÉÒÔ·ÃÎʵĶÔÏóµÄÐÅÏ¢£¬¼´Óû§×Ô¼º´´½¨µÄ¶ÔÏóµÄÐÅÏ¢¼ÓÉÏÆäËûÓû§´´½¨µÄ¶ÔÏ󵫸ÃÓû§ÓÐȨ·ÃÎʵÄÐÅÏ¢
DBA_*£ºÓйØÕû¸öÊý¾Ý¿âÖжÔÏóµÄÐÅÏ¢
---------------------------------------------
Oracle 10i
ALTER DATABASE DEFAULT TABLESPACE ÐÞ¸ÄÊý¾Ý¿âµÄĬÈϱí¿Õ¼ä
-----------------------------------
set echo off;
spool ²úÉú½Å±¾ÎļþµÄ·¾¶
select 'grant select,insert,delete,update on '|| table_name||' to Óû§Ãû;' from user_tables;
spool off;
select 'revoke select,insert,update,delete on '||table_name||' from Óû§Ãû;' from user_tables;
revoke select,insert,delete,update any table from Óû§Ãû with grant option;
--------------
grant select,insert,delete,insert,update any table to Óû§Ãû with grant option ;
Ð޸ıí ËùÊôµÄ±í¿Õ¼ä
alter table ±íÃû move tablespace ±í¿Õ¼äÃû
×¢Ò⣺Ôڴ˲Ù×÷Ö®ºó£¬Ò»¶¨Òª°Ñ±íÉϵÄË÷ÒýÖØ½¨£¬ alter index index-name rebuild
-------------------
´´½¨±í¿Õ¼äÓï¾ä£º
create tablespace tableName datafile 'e:oracle/dbName.dbf' size 1024M autoextend on next 100M maxsize unlimited;
Ïà¹ØÎĵµ£º
SQL> select * from emp where sal=800;
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
----- ---------- --------- ----- ----------- ----- ......
ÎÒÃǶ¼ÖªµÀORACLE²»»á·¢ÉúËøÉý¼¶£¬Ëø¶ÔÓÚORACLEÀ´Ëµ²¢²»ÊÇϡȱ×ÊÔ´£¬ÎªÊ²Ã´DML lock¶ÔÓÚORACLEÀ´Ëµ²»ÊÇϡȱ×ÊÔ´£¬ÏÂÃæÀ´Ñ°ÕҴ𰸡£
SQL> select * from emp where sal>2999;
EMPNO ENAME JOB MGR HIREDATE ......
參¿¼:http://blog.csdn.net/rainnyzhong/archive/2009/01/09/3740660.aspx
×÷ÕߣºRainny
ÈÕÆÚ£º2009-1-8
´´½¨²âÊÔ±í£º
create table test(c_id varchar2(20));
²åÈë²âÊÔÊý¾Ý£º
insert into test values ('1234');
insert into test values ('45678');
insert into test values ('-12 ......
. ´´½¨job
jobÊÇÊ²Ã´ÄØ? ¼òµ¥µÄ˵¾ÍÊǼƻ®(schedule)¼ÓÉÏÈÎÎñ˵Ã÷. ÁíÍ⻹ÓÐһЩ±ØÐëµÄ²ÎÊý.
ÕâÀïÌáµ½µÄ"ÈÎÎñ"¿ÉÒÔÊÇÊý¾Ý¿âÄÚ²¿µÄ´æ´¢¹ý³Ì,ÄäÃûµÄPL/SQL¿é,Ò²¿ÉÒÔÊDzÙ×÷ϵͳ¼¶±ðµÄ½Å±¾.
¿ÉÒÔÓÐÁ½ÖÖ·½Ê½À´¶¨Òå"¼Æ»®":
1) ʹÓÃDBMS_SCHDULER.CREATE_SCHEDULE ¶¨ÒåÒ»¸ö¼Æ»®;
2) µ÷ÓÃDBMS_SCHDULER.CREATE_JOBE¹ý³ÌÖ±½ÓÖ¸¶ ......
ÒòΪҵÎñÐèÒª,ÐÞÒªÐÞ¸Äij¸ö×Ö¶ÎÊý¾ÝÀàÐÍÓÐnumber(5),±äΪnumber(5,2)ÐÍ
ÒªÊÇûÓÐÊý¾ÝµÄ»°Ö±½ÓÓÃÒÔÏÂÓï¾ä¼´¿É
alter table tb_test modify permile number(5,2);
µ«ÊÇÓÐÊý¾ÝµÄ»° ¾Í²»ÄÜÓÃÉÏÃæ·½·¨ÁË,
alter table tb_test add permile_temp number(5,2)
update tb_test set permile_temp=permile;
alter t ......