oracle¿çÊý¾Ý¿â·ÃÎÊ
oracle£¨²âÊÔ»·¾³Îªoralce10g£©ÖУ¬ÈôΪͬһ¿âÖУ¬²éѯʱÓÚ±íÃûÇ°Ìí¼ÓÓû§Ãû¼´¿É¡£ ÈôΪ¿ç¿â´¦Àí£¬ÓÐÁ½ÖÖ·½·¨¡£
µÚÒ»ÖÖ·½·¨£¬ÓÃDB_link´¦Àí¡£¶øÆä²»×ãÖ®´¦Îª²»ÄܲÙ×Ý´ó×ֶΡ£ÈçϲÙ×÷£º
1. ÉèÖüàÌý·þÎñtnsnames.ora¡£
2. ´´½¨ db_link£¬Ö´ÐÐÒÔÏÂÃüÁ
create database link db_linkÃû connect to Óû§Ãû identified by ÃÜÂë using '¼àÌý·þÎñÃû';
3. ʹÓÃÁ´½ÓµÄÊý¾Ý¿â£¨±íÃûΪ“ʵ¼Ê±íÃû@db_linkÃû”£©¡£
select * from ±íÃû@db_linkÃû;
»òΪ±í½¨Á¢Í¬Òå´Ê
create synonym aaa for ±íÃû@db_linkÃû;
µÚ¶þÖÖ·½·¨£¬ÓÃÎﻯÊÓͼmaterialized view¡£¶øÆä²»×ãÖ®´¦ÎªÍ¬²½Ê±¼äÉèÖùý¶ÌÕ¼ÓôóÁ¿ÏµÍ³×ÊÔ´¡£ÈçϲÙ×÷£º
1.ÒÔsysÕʺŵǼĿµÄÊý¾Ý¿âϵͳ£¬¸øÓû§descÊÚÈçÏÂȨÏÞ£º
grant create materialized view to desc;
2.µÇ¼ԴÊý¾Ý¿â(ÒÔtest1±íËùÊôµÄÓû§µÇ¼)£¬Ö´ÐÐÒÔÏÂÃüÁ
create materialized view log on test1 with primary key;
&n
Ïà¹ØÎĵµ£º
select dm_id, father_id, dm_name from gy_dmcode t
where level <= 2 --²ã¼¶
start with t.dm_id = '0' --¸ù½Úµã
connect by prior t.dm_id = t.father_id; --¶¨Òå¹Øϵ£¬prior ±íʾÓÅÏȼ¶ ......
1¡¢´ÓrootÓû§Çл»µ½oracleÓû§
#su - oracle
2¡¢ÀûÓÃnologÑ¡ÏîÆô¶¯sql*plus¹¤¾ß³ÌÐò
$slqplus /nolog
3¡¢ÀûÓÃsysdbaÉí·ÝÆô¶¯oracleÊý¾Ý¿â
sql>connect / as sysdba
sql>startup
4¡¢Æô¶¯Êý¾Ý¿âµÄ¼àÌýÆ÷listener
$lsnrctl start
»ò
$lsnrctl
lsnrctl>start
5¡¢¹Ø±ÕoracleÊý¾Ý¿â¼àÌý
$lsnrctl stop
6¡ ......
extent--×îС¿Õ¼ä·ÖÅ䵥λ --tablespace management
block --×îСi/oµ¥Î» --segment management
create tablespace james
datafile '/export/home/oracle/oradata/james.dbf'
size 100M ¡¡¡¡¡¡¡¡¡¡¡¡--³õʼµÄÎļþ´óС¡¡
autoextend On¡¡¡¡¡¡¡¡ --×Ô¶¯Ôö³¤
next 10M¡ ......