ÔÚOracleÖеÄÊ÷ÐβÙ×÷
ÔÚOracleÖеÄÊ÷ÐβÙ×÷
1.È¡×ӽڵ㼰·¾¶(ÕýÊ÷):
select t.id ,t.code, t.name ,t.pid
,SYS_CONNECT_BY_PATH(t.id,'.')||'.' as IdPath
from tas_catalog t
--where id!=110
start with id=110
connect by pid = prior id
order siblings by id
2.È¡¸÷¼¶¸¸½Úµã(µ¹Ê÷)£º
select t.id ,t.code, t.name ,t.pid
,SYS_CONNECT_BY_PATH(t.id,'.')||'.' as IdPath --·¾¶´Ó·´µÄ
from tas_catalog t
--where id!=110
start with id=110
connect by id = prior pid
order siblings by id
ÎÞÂÛÕýÊ÷»¹Êǵ¹Ê÷, ¹Ø¼ü¾ÍÔÚÓÚconnect byµÄÌõ¼þ.
ÕýÊ÷: ±ØÐëÊÇ ‘¸¸’= prior ‘×Ó’
µ¹Ê÷: ±ØÐëÊÇ ‘×Ó’= prior ‘¸¸’
Ïà¹ØÎĵµ£º
Ë÷Òý
ΨһË÷Òý£º
ÁÐÖÐÎÞÖØ¸´Öµ£¬Î¨Ò»Ô¼Êø¡£
oracle×Ô¶¯ÎªÖ÷¼üºÍΪһ¼üÁд´½¨Î¨Ò»Ë÷Òý
Óï·¨£ºcreate unique index Ë÷ÒýÃû on ±íÃû(ÁÐÃû);
×éºÏË÷Òý£º
ÔÚ±íÖжà¸ö×Ö¶ÎÉÏ´´½¨µÄË÷Òý
Áа´ÈÎÒâ˳ÐòÅÅÁÐ
where×Ó¾äÖаüº¬¶à¸öÁеIJéѯ£¬¿ÉÌá¸ß·ÃÎÊËÙ¶È¡£
Óï·¨£ºcreate index Ë÷ÒýÃû on ±íÃû(ÁÐÃû1,ÁÐÃû2,...,ÁÐÃûn)£º
·´ ......
´Ø£º
Óй«¹²ÁеÄÁ½¸ö»ò¶à¸ö±íµÄ¼¯ºÏ
´Ø±íÖеÄÊý¾Ý´æ´¢ÔÚ¹«¹²Êý¾Ý¿éÖÐ
´Ø¼ü£º
Ψһ±êʶ·û
´´½¨´Ø£º
¼õÉÙI/O²Ù×÷£¬¼õÉÙ´ÅÅ̿ռ䣬µ«ÊDzåÈëÐÔÄܽµµÍ¡£
Á½ÕűíÖÐÓй²Í¬µÄÁУ¬±ÈÈçѧÉú±íÖÐÓа༶±àºÅ£¬°à¼¶±íÖÐÒ²Óа༶±àºÅ£¬¿ÉÒÔ½«°à¼¶±àºÅ´æ·ÅÔÚ´ØÖÐ
create cluster ´ØÃû(
×Ö¶ÎÃû ÀàÐÍ
)tablespace ±íÃüÃû¿Õ¼ä;
cr ......
±¾ÎÄÖ÷Òª´Ó´óÐÍÊý¾Ý¿âORACLE»·¾³Ëĸö²»Í¬¼¶±ðµÄµ÷Õû·ÖÎöÈëÊÖ£¬·ÖÎöORACLEµÄϵͳ½á¹¹ºÍ¹¤×÷»úÀí£¬´Ó¾Å¸ö²»Í¬·½Ãæ½ÏÈ«ÃæµØ×ܽáÁËORACLEÊý¾Ý¿âµÄÓÅ»¯µ÷Õû·½°¸¡£
¹Ø¼ü´Ê ORACLEÊý¾Ý¿â»·¾³µ÷ÕûÓÅ»¯Éè¼Æ·½°¸
¶ÔÓÚORACLEÊý¾Ý¿âµÄÊý¾Ý´æÈ¡£¬Ö÷ÒªÓÐËĸö²»Í¬µÄµ÷Õû¼¶±ð£¬µÚÒ»¼¶µ÷ÕûÊDzÙ×÷ÏµÍ ......
Oracle µÄ¹ÜÀí¿ÉÒÔͨ¹ýOEM»òÕßÃüÁîÐнӿڡ£ Oracle ClusterwareµÄÃüÁ¿ÉÒÔ·ÖΪÒÔÏÂ4ÖÖ£º
½Úµã²ã£ºosnodes
ÍøÂç²ã£ºoifcfg
¼¯Èº²ã£ºcrsctl, ocrcheck,ocrdump,ocrconfig
Ó¦Óò㣺srvctl,onsctl,crs_stat
ÏÂÃæ·Ö±ðÀ´½éÉÜÕâЩÃüÁî¡£
Ò»£® ½Úµã²ã
Ö»ÓÐÒ»¸öÃüÁ¡¡osnodes£¬ Õâ ......
ORACLE 10 ѧϰ±Ê¼ÇÃüÁîµÚÒ»¿Î¡£
1.
sqlplus /nolog
connect /as sysdba
alter user scott account unlock;
alter user scott identified by manager;
2.
grant select on dept to nmerp;
revoke select on dept to nmerp;
select * from scott.dept
create table abc(a varchar2(10),b char(10));
alter& ......