Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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


Ïà¹ØÎĵµ£º

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ÔÚlinuxÏÂÆô¶¯Ïà¹ØÃüÁî

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¡ ......

Oracle±í¿Õ¼ä¹ÜÀí

extent--×îС¿Õ¼ä·ÖÅ䵥λ --tablespace management
block --×îСi/oµ¥Î»      --segment    management
create tablespace james
datafile '/export/home/oracle/oradata/james.dbf'
size 100M ¡¡¡¡¡¡¡¡¡¡¡¡--³õʼµÄÎļþ´óС¡¡
autoextend On¡¡¡¡¡¡¡¡ --×Ô¶¯Ôö³¤
next 10M¡ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ