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;
Ïà¹ØÎĵµ£º
ÎÒÃǶ¼ÖªµÀORACLE²»»á·¢ÉúËøÉý¼¶£¬Ëø¶ÔÓÚORACLEÀ´Ëµ²¢²»ÊÇϡȱ×ÊÔ´£¬ÎªÊ²Ã´DML lock¶ÔÓÚORACLEÀ´Ëµ²»ÊÇϡȱ×ÊÔ´£¬ÏÂÃæÀ´Ñ°ÕҴ𰸡£
SQL> select * from emp where sal>2999;
EMPNO ENAME JOB MGR HIREDATE ......
CREATE TABLE T_BI_CurrentAccountDetailed
(
OrderDate DATE,
BranchFlag varchar2(3),
SortId varchar2(11),
OrderNo&n ......
1¡¢pfile Îı¾Îļþ client¶Ë²ÎÊýÎļþ£»²»Äܶ¯Ì¬Ð޸ģ¬¿ÉÒÔÓÃÆÕͨµÄ±à¼Æ÷Ð޸ģ¬ÐÞ¸ÄÖ®ºóÐèÒªÖØÆô¡£pfile¿ÉÄܻᵼÖ·þÎñÆ÷Æô¶¯²»Ò»Ö£¬ÒòΪ¿ÉÒÔÔÚ¿Í»§¶ËÆô¶¯¡£ 2¡¢spfile ¶þ½øÖÆÎļþ·þÎñÆ÷¶Ë²ÎÊýÎļþ£¬ÓÐÁËspfile£¬oracle¿ÉÒÔʵÏÖ¶¯Ì¬²ÎÊýÔÚÏßÐ޸쬲¿·Ö²ÎÊýÐÞ¸ÄÖ®ºóÎÞÐèÖØÆô¡£µ«ÊÇ£¬ÒòΪÊǶþ½øÖÆÎļþ£¬ËùÒÔ²»ÄÜÓÃÆÕͨµÄ±à¼ ......
½ñÌìÓиö¹¦ÄÜÐèÒª¶ÔCLOB×ֶνøÐвÙ×÷£¬ÆÚ¼äÓöµ½¼¸¸öÎÊÌ⣬ÀÏÌì¾ì¹Ë£¬¶¼ËãÊǽâ¾öÁË£¬¼Çһϣ¬ÃâµÃÈÕºóÖØµ¸¸²ÕÞ¡£
´íÎóÒ»£º
ORA-22920: Î´Ëø¶¨º¬ÓÐ LOB ÖµµÄÐÐ
³öÏÖÕâ¸öÎÊÌâµÄÔÒò£¬ÊÇÓÉÓÚselect³öLOB×Ö¶Îʱδ¼Ó for update£¬ORACLE¹Ù·½Îĵµ¶Ô¸Ã´íÎóµÄ˵Ã÷£º
ÒýÓÃÎÄ×Ö´úÂë
ORA-22920 ro ......
Ò». Ora-24801:ÔÚOCI_lobº¯ÊýÖзǷ¨µÄ²ÎÊýÖµ
°ÑÒ»Õź¬ÓГ±¸×¢”×ֶεıíͨ¹ýODBCµ¼³öµ½OracleµÄʱºòÒ»Ö±³öÏÖÈçÉÏͼËùʾµÄÌáʾÐÅÏ¢¡£³¢ÊÔÈ¥µôÏà¹Ø×Ö¶ÎÖпոñ×Ö·û£¬È¥µô×Ö¶ÎΪ¿ÕµÄ¼Ç¼£¬»¹Êǵ¼³öʧ°Ü¡£×îºóżȻ·¢ÏÖ£¬ÖØÐ½¨Ò»ÕÅÏàͬ½á¹¹µÄ¿Õ±í£¬È»ºó¸´ÖÆÔ±íµÄ¼Ç¼£¬ÔÙÕ³Ìùµ½Ð±íÖУ¬µ¼³öµ½Oracle¾ ......