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

oracle database link

Êý¾Ý¿âÖ®¼äµÄÁ´½Ó½¨Á¢ÔÚDATABASE LINKÉÏ¡£Òª´´½¨Ò»¸öDB LINK£¬±ØÐëÏÈ
ÔÚÿ¸öÊý¾Ý¿â·þÎñÆ÷ÉÏÉèÖÃÁ´½Ó×Ö·û´®¡£ 
1¡¢   Á´½Ó×Ö·û´®¼´·þÎñÃû£¬Ê×ÏÈÔÚ±¾µØÅäÖÃÒ»¸ö·þÎñÃû£¬µØÖ·Ö¸ÏòÔ¶³ÌµÄÊý¾Ý¿âµØÖ·£¬·þÎñÃûȡΪ½«À´ÄãҪʹÓõÄÊý¾Ý¿âÁ´Ãû£º
2¡¢´´½¨Êý¾Ý¿âÁ´½Ó£¬
½øÈëϵͳ¹ÜÀíÔ±SQL>²Ù×÷·ûÏ£¬ÔËÐÐÃüÁ
SQL>create public database link beijing connect to scott identified by tiger
         using 'tobeijing';
Ôò´´½¨ÁËÒ»¸öÒÔscottÓû§ºÍ±±¾©Êý¾Ý¿âµÄÁ´½Óbeijing£¬ÎÒÃDzéѯ±±¾©µÄscottÊý¾Ý:
SQL>select * from emp@beijing;
ÕâÑù¾Í¿ÉÒÔ°ÑÉîÛںͱ±¾©scottÓû§µÄÊý¾Ý×ö³ÉÒ»¸öÕûÌåÀ´´¦Àí¡£
3¡¢½¨Á¢Í¬Òå´Ê£¬ÎªÁËʹÓйطֲ¼Ê½²Ù×÷¸ü͸Ã÷£¬ORACLEÊý¾Ý¿âÀïÓÐͬÒå´ÊµÄ¶ÔÏósynonym
SQL>create synonym bjscottemp for emp@beijing;
ÓÚÊǾͿÉÒÔÓÃbjscottempÀ´Ìæ´ú´ø@·ûºÅµÄ·Ö²¼Ê½Á´½Ó²Ù×÷emp@beijing¡£
4¡¢²é¿´ËùÓеÄÊý¾Ý¿âÁ´½Ó£¬½øÈëϵͳ¹ÜÀíÔ±SQL>²Ù×÷·ûÏ£¬ÔËÐÐÃüÁ
SQL>select owner,object_name from dba_objects where object_type='DATABASE LINK';
¸ÕºÃÓõ½, È¡Ïûdblink
3¡¢²é¿´Êý¾Ý¿âÁ¬½Ó
sql> select owner, db_link from dba_db_links;
ower db_link
public TEST.US.ORACLE.COM
4¡¢É¾³ýÊý¾Ý¿âÁ¬½Ó
ÏÈ´ÓµÚÈý²½Öв鿴Êý¾Ý¿âÁ¬½Ó£¬È¡µÃÆädb_linkµÄÃû³Æ
sql>drop public database link TEST.US.ORACLE.COM
Êý¾Ý¿âÁ¬½ÓËȶªÆú
±ÈÈ磺ÔÚÒ»¸öÊý¾Ý¿âBÖзÃÎÊÊý¾Ý¿âAÖÐµÄ±í£º
1.ÔÚÊý¾Ý¿âBÖд´½¨Êý¾Ý¿âÁ´£º
CREATE PUBLIC DATABASE LINK Êý¾Ý¿âÁ´½ÓÃû CONNECT TO Óû§Ãû identified by ÃÜÂë using 'Á¬½Ó˵Ã÷'
ÆäÖУ¬Á¬½Ó˵Ã÷±ØÐëΪÈçϸñʽ£º
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.142.10.201)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME=ORCL)
)
)
2.·ÃÎÊÁ´½ÓÊý¾Ý¿âÖеĶÔÏóµÄÓï·¨£º
Óû§Ãû.Êý¾Ý¿â¶ÔÏó@Êý¾Ý¿âÁ´½ÓÃû
3.²é¿´ËùÓеÄÊý¾Ý¿âÁ´½Ó£º
select owner,object_name from dba_objects where object_type='DATABASE LINK';
4.Àý×Ó£º
´´½¨Ò»¸öÊý¾Ý¿âÁ´½Ó£º
CREATE PUBLIC DATABASE LINK DBL_ORCL CONNECT TO province identified by province_pwd
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.142.10.201)(PORT = 1521))
)
(CON


Ïà¹ØÎĵµ£º

oracleѧϰ±Ê¼Ç——ÊÓͼ


1.ÊÓͼ£¨VIEW£©
1.1 ¸ÅÄî
       ÊÓͼ-----ÊÇÓÉSELECT²éѯÓï¾ä(¿ÉÒÔÊǵ¥±í»òÕ߶à±í²éѯ)¶¨ÒåµÄÒ»¸ö"Âß¼­±í",Ö»Óж¨Òå¶øÎÞÊý¾Ý,ÊÇÒ»¸ö"Ðé±í". ÔÚ´´½¨ÊÓͼʱ,Ö»Êǽ«ÊÓͼµÄ¶¨ÒåÐÅÏ¢±£´æÔÚÊý¾Ý×ÖµäÖÐ, ¶ø²¢²»½«Êµ¼ÊµÄÊý¾Ý¸´ÖƵ½Èκεط½, ¼´²»ÐèÒªÔÚ±í¿Õ¼äÖÐΪÊÓͼ·ÖÅä´æ´¢¿Õ¼ä. ÊÓͼÊDz鿴º ......

±±´óÇàÄñoracleѧϰ±Ê¼Ç8 9


±í·ÖÇøά»¤£º
Ìí¼Ó·ÖÇø£º
Alter table student add partition ·ÖÇøÃû values less than(100);
ɾ³ý·ÖÇø£º
Alter table student drop partition ·ÖÇøÃû;
½Ø¶Ì·ÖÇø£º
Alter table student truncate partition ·ÖÇøÃû;
ºÏ²¢·ÖÇø£º
Alter table student merge partitions ·ÖÇøÃû,...,·ÖÇøÃû into partition зÖÇøÃû; ......

OracleÓëAIXµÄ½ÇÉ«

1.2.1  OracleÓëAIXµÄ½ÇÉ«
OracleÔËÐÐÔÚAIXÉÏ£¬Ìṩ×ÅÊý¾ÝµÄ´æ´¢ºÍ¹ÜÀí·þÎñ¡£Êý¾Ý¼´ÐÅÏ¢£¬OracleÊý¾Ý¿â¾ÍÊÇÓ¦ÓÃϵͳÖд洢Êý¾ÝÐÅÏ¢µÄÒ»¸ö¼¯Öд洢λÖá¢Ò»ÖÖ´æÈ¡·½·¨µÄÉÌÆ·»¯ÊµÏÖ¡£AIXÊdzÐÔØOracleÔËÐеĵײãƽ̨£¬½øÐÐ×ÅCPUµ÷¶È¡¢ÄÚ´æµ÷¶È¡¢´æ´¢¹ÜÀí¡¢Îļþ¹ÜÀí¡¢ÍøÂçÇý¶¯µÈϵͳÔËÐкÍά»¤¹¤×÷¡£
×÷Ϊ¶ÔÓ¦ÓÃϵͳµÄÖ§ ......

oracleͬÒå´Ê

----------------------------------------------------------------------------
Ïà¹Ø֪ʶ£ºOracle SYNONYM£¨Í¬Òå´Ê£©
----------------------------------------------------------------------------
ÊÇÒ»ÖÖÓ³Éä¹Øϵ£¬¿ÉÒÔÀí½âΪ±íµÄÒ»Ö̶ֹ¨±ðÃû
ͬÒå´ÊµÄºÃ´¦£º½¨Á¢Ò»¸öͬÒå´Ê¿ÉÒÔÅųýÒ»¸ö¶ÔÏóÃû×ÖµÄÏÞÖÆ
Èç¹ûÄãµÄ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ