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
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
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 ±íʾÓÅÏȼ¶ ......
Oracle¼à¿Ø¹¤¾ß¸ÅÀÀ
Kaya ·¢±íÓÚ os2ora.com
дÁËLinuxÉϵļà¿ØÓë·ÖÎö¹¤¾ß
Ö®ºó£¬Ð´Ð´OracleÉÏÏàÓ¦µÄ¼à¿ØÓë·ÖÎö¹¤¾ß»¹ÊÇͦÓÐÒâ˼µÄ£¬Ò»·½Ãæ¿ÉÒÔ¸ü¼ÓÍêÕû£¬Ò»·½Ãæ¿ÉÒÔ½øÐкáÏò¶Ô±È¡£
LinuxÉϵÄÐÔÄÜÊý¾ÝÒ»°ã¶¼À´×ÔÓÚ/procÎļþϵͳ£¬¶øOracleÔòÊÇÀ´×ÔÓÚV$ÊÓͼ¡£Òò´Ë£¬ËùÓеÄOracle¼à¿Ø¹¤¾ßµÄʵÏÖ¶¼Íò±ä²»Àë
V$
ÊÓͼ¡ ......
extent--×îС¿Õ¼ä·ÖÅ䵥λ --tablespace management
block --×îСi/oµ¥Î» --segment management
create tablespace james
datafile '/export/home/oracle/oradata/james.dbf'
size 100M ¡¡¡¡¡¡¡¡¡¡¡¡--³õʼµÄÎļþ´óС¡¡
autoextend On¡¡¡¡¡¡¡¡ --×Ô¶¯Ôö³¤
next 10M¡ ......