ORACLEÈÕÆÚʱ¼äº¯Êý´óÈ«
ORACLEÈÕÆÚʱ¼äº¯Êý´óÈ«
TO_DATE¸ñʽ(ÒÔʱ¼ä:2007-11-02 13:45:25ΪÀý)
Year:
yy two digits Á½Î»Äê ÏÔʾֵ:07
yyy three digits ÈýλÄê ÏÔʾֵ:007
yyyy four digits ËÄλÄê ÏÔʾֵ:2007
Month:
mm number Á½Î»Ô ÏÔʾֵ:11
mon abbreviated ×Ö·û¼¯±íʾ ÏÔʾֵ:11ÔÂ,ÈôÊÇÓ¢ÎÄ°æ,ÏÔʾnov
month spelled out ×Ö·û¼¯±íʾ ÏÔʾֵ:11ÔÂ,ÈôÊÇÓ¢ÎÄ°æ,ÏÔʾnovember
Day:
dd number µ±Ôµڼ¸Ìì ÏÔʾֵ:02
ddd number µ±ÄêµÚ¼¸Ìì ÏÔʾֵ:02
dy abbreviated µ±Öܵڼ¸Ìì¼òд &
Ïà¹ØÎĵµ£º
¸ü¸Äoracle Listener ÅäÖãºD:\Oracle\moon\product\11.1.0\db_1\NETWORK\ADMIN Ŀ¼֮Ï£ºListener.oraÎļþ½øÐÐÅäÖãº
# listener.ora Network Configuration File: d:\Oracle\moon\product\11.1.0\db_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SI ......
1¡¢´´½¨±í£º
create table stud(
sid int,
sname varchar2(50)
)
²¢²åÈëÒ»ÌõÊý¾Ý
&n ......
ÏîÄ¿ÖÐÓÐÉæ¼°´æ´¢¹ý³Ì¶Ô×Ö·û´®µÄ´¦Àí£¬ËùÒԾͽ«ÔÚÍøÉϲéÕÒµ½µÄ×ÊÁÏ»ã×Ü£¬×öÒ»¸öÐÅϢƴ½ÓʽµÄ×ܽᡣ
ÒÔÏÂÐÅÏ¢¾ùÀ´×Ô»¥ÁªÍø£¬Ìù³öÀ´Ò»Ôò×Ô¼º±£´æÒÔ´ýÒÔºóʹÓã¬Ò»Ôò¹©´ó¼Ò·ÖÏí¡£
×Ö·ûº¯Êý——·µ»Ø×Ö·ûÖµ
ÕâЩº¯ÊýÈ«¶¼½ÓÊÕµÄÊÇ×Ö·û×åÀàÐ͵IJÎÊý(CHR³ýÍâ)²¢ÇÒ·µ»Ø×Ö·ûÖµ.
³ýÁËÌرð˵Ã÷µÄÖ®Íâ,ÕâЩº¯Êý´ó²¿·Ö·µ» ......
°²×°
1. Íê³ÉRAC°²×°Ç°µÄ×¼±¸¹¤×÷
1.1 ͬÕý³£°²×°Oracle RACµÄ°²×°Ç°ÅäÖá£Ö÷Òª°üÀ¨ÒÔϼ¸¸ö²¿·Ö£º
£¨1£© ÈíÓ²¼þ»·¾³¼ì²é
£¨2£© ÍøÂçÅäÖÃ
£¨3£© Ïà¹ØÓû§ºÍĿ¼µÄ´´½¨
£¨4£© Óû§»·¾³¼°ÏµÍ³»·¾³ÉèÖÃ
£¨5£© ÅäÖÃÔ¶³Ì·ÃÎÊ
£¨6£©  ......
1¡¢ÔÚ±¾»ú69ÉÏ´´½¨Êý¾Ý¿âorcl £¬global_name=orcl£¬Ê¹ÓÃÓï¾ä
alter database rename global_name to orcl.us.oracle.com ÐÞ¸ÄÊý¾Ý¿âµÄÈ«¾ÖÊý¾Ý¿âÃûΪorcl.us.oracle.com
2¡¢ÔÚÐé»ú188ÉÏ´´½¨Êý¾Ý¿âviotest£¬global_name=viotest£¬Ê¹ÓÃÓï¾ä
alter database rename global_name to viotest.us.oracle.com ÐÞ¸ÄÊý¾Ý¿âµÄÈ«¾ÖÊ ......