OracleÒì³£ÎÊÌâ½â¾ö·½°¸
1. ÔÚ´ò¿ªEnterprise Manager Consolʱ±¨´í: "ÕÒ²»µ½Ä¿±êÖ÷»ú";
¡¾½â¾ö·½°¸¡¿¸ÃÎÊÌâÔÚʹÓÃGhostÖÆ×÷µÄϵͳÖг£¼û, ³ö´íÔÒòÊÇOracleÖÐÅäÖõÄÖ÷»úÃû
ºÍʵ¼ÊµÄÖ÷»úÃû²»Ò»ÖÂ. ½â¾ö·½·¨ÈçÏÂ:
(1) Enterprise Manager Consol -> ¹¤¾ß²Ëµ¥ ->·þÎñ¹ÜÀí -> Oracle Net Manager;
(2) ½«"±¾µØ"µÄ"·þÎñÃüÃû"ºÍ"¼àÌý³ÌÐò"ÏÂÃæ×ÓÏîµÄÖ÷»úÃûÐÞ¸ÄΪºÍ±¾»úÒ»Ö¼´¿É.
2. ¼àÌý³ÌÐòÒì³£½â¾ö·½°¸:
(1) ´ò¿ªOracle - OraHome90 -> Configuration and Migration Tools -> Net Configuration Assistant;
(2) ÖØÐÂÅäÖüàÌý³ÌÐò.
3. "OracleÊý¾Ý¿â²»¿ÉÓÃ"ÎÊÌâ½â¾ö·½°¸:
¡¾ÎÊÌâÏÖÏó¡¿Oracle·þÎñÕý³£Æô¶¯, Enterprise Manager ConsolÕý³£µÇ¼, µ«ÔÚ´ò¿ªÊý¾Ý¿âµÄ·½°¸Ïîʱ±¨´í:
"OracleÊý¾Ý¿â²»¿ÉÓÃ";
¡¾½â¾ö·½°¸¡¿
(1) ½øÈëEnterprise Manager Consol;
(2) Ñ¡Ôñ"Àý³Ì"ÖеÄ"ÅäÖÃ"×ÓÏî;
(3) ½«"Àý³Ì״̬"ÉèÖÃΪ"´ò¿ª"¼´¿É.
Ïà¹ØÎĵµ£º
--´´½¨¶ÔÏóÀàÐÍ
create or replace type emp_typ as object (
id number,
name varchar2(30),
sal number,
comm number,
member procedure change_comm(new_comm number),
member function get_info return varchar2
) ;
--´´½¨¶ÔÏóÀàÐ͹¹Ô캯Êý¶¨Òå
create or replace type body emp_typ is
member proce ......
Á©Ì¨²»Í¬µÄÊý¾Ý¿â·þÎñÆ÷£¬´Óһ̨Êý¾Ý¿â·þÎñÆ÷µÄÒ»¸öÓû§¶ÁÈ¡Áíһ̨Êý¾Ý¿â·þÎñÆ÷ϵÄij¸öÓû§µÄÊý¾Ý£¬Õâ¸öʱºò¿ÉÒÔʹÓÃdblink¡£
ÆäʵdblinkºÍÊý¾Ý¿âÖеÄview²î²»¶à£¬½¨dblinkµÄʱºòÐèÒªÖªµÀ´ý¶ÁÈ¡Êý¾Ý¿âµÄipµØÖ·£¬ssidÒÔ¼°Êý¾Ý¿âÓû§ÃûºÍÃÜÂë¡£
´´½¨¿ÉÒÔ ......
ORACLE±í·ÖÇøÒÔ¼°ÐÅÏ¢²éÕÒ
http://www.sysab.cn/a/db/oracle/2009/1020/2433.html
·ÖÇø¸ÅÊö ΪÁ˼ò»¯Êý¾Ý¿â´ó±íµÄ¹ÜÀí,ÀýÈçÔÚÊý¾Ý²Ö¿âÖÐÒ»°ã¶¼ÊÇTB¼¶µÄÊýÁ¿¼¶.ORACLE8ÒÔºóÍƳöÁË·ÖÇøÑ¡Ïî.·ÖÇø½«±í·ÖÀëÔÚÈôÓÚ²»Í¬µÄ±í¿Õ¼äÉÏ,Ó÷ֶøÖÎÖ®µÄ·½·¨À´Ö§³ÅÔªÏÞÅòÕ͵Ĵó±í,×é´ó±íÔÚÎïÀíÒ»¼¶µÄ¿É¹ÜÀíÐÔ.½«´ó±í·Ö¸î³É½ÏСµÄ·ÖÇø¿ÉÒÔ¸ ......
http://tianzt.blog.51cto.com/459544/171759 ½ö½ö¹©×Ô¼ºÑ§Ï°Ö®ÓÃ
´ËÎÄ´ÓÒÔϼ¸¸ö·½ÃæÀ´ÕûÀí¹ØÓÚ·ÖÇø±íµÄ¸ÅÄî¼°²Ù×÷:
1.±í¿Õ¼ä¼°·ÖÇø±íµÄ¸ÅÄî
2.±í·ÖÇøµÄ¾ßÌå×÷ÓÃ
3 ......