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±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)
2007Äê11ÔÂ02ÈÕ ÐÇÆÚÎå 16:03
¸ÅÒª
1¡¢Á˽âʲôÊDZ¸·Ý
2¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
3¡¢Àí½âÊý¾Ý¿âµÄÁ½ÖÖÔËÐз½Ê½
4¡¢Àí½â²»Í¬µÄ±¸·Ý·½Ê½¼°ÆäÇø±ð
5¡¢Á˽âÕýÈ·µÄ±¸·Ý²ßÂÔ¼°ÆäºÃ´¦
Ò»¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
¿ÉÒÔ˵£¬´Ó¼ÆËã»úϵͳ³öÊÀµÄÄÇÌìÆ𣬾ÍÓÐÁ˱¸·ÝÕâ¸ö¸ÅÄ ......
OracleËÀËø
1¡¢Ê²Ã´ÊÇËÀËø
¡¡¡¡ËÀËøÊÇÖ¸ÔÚÒ»×é½ø³ÌÖеĸ÷¸ö½ø³Ì¾ùÕ¼Óв»»áÊͷŵÄ×ÊÔ´£¬µ«Òò»¥ÏàÉêÇë±»ÆäËû½ø³ÌËùÕ¾Óò»»áÊͷŵÄ×ÊÔ´¶ø´¦ÓÚµÄÒ»ÖÖÓÀ¾ÃµÈ´ý״̬¡£ËÀËø²úÉúÓÐËĸö±ØÒªµÄÌõ¼þ£º»¥³âÌõ¼þ£¬²»¿É°þ¶áÌõ¼þ£¬²¿·Ö·ÖÅ䣬ѻ·µÈ´ý£¬ÕâËĸöÌõ¼þ²»Êdzä·ÖÌõ¼þ£¬¼´Ê¹ÕâËĸöÌõ¼þͬʱ´æÔÚ£¬ÏµÍ³Ò²²»Ò»¶¨·¢ÉúËÀËø£¬µ«ÏµÍ³Ò»µ ......
1¡¢Ê¹ÓÃ%TYPE
ÔÚÐí¶àÇé¿öÏ£¬PL/SQL±äÁ¿¿ÉÒÔÓÃÀ´´æ´¢ÔÚÊý¾Ý¿â±íÖеÄÊý¾Ý¡£ÔÚÕâÖÖÇé¿öÏ£¬±äÁ¿Ó¦¸ÃÓµÓÐÓë±íÁÐÏàͬµÄÀàÐÍ¡£ÀýÈ磬students±íµÄfirst_nameÁеÄÀàÐÍΪVARCHAR2(20),ÎÒÃÇ¿ÉÒÔ°´ÕÕÏÂÊö·½Ê½ÉùÃ÷Ò»¸ö±äÁ¿
DECLARE
v_FirstName VARCHAR2(20);
µ«ÊÇÈç¹ûfirst_nameÁеĶ¨Òå¸Ä±äÁ˻ᷢÉúʲô£¨±ÈÈç˵±í¸Ä±äÁË£¬first ......