OracleÊý¾Ý¿â×Ö·û¼¯ÎÊÌâ½âÎö
OracleÊý¾Ý¿â×Ö·û¼¯ÎÊÌâ½âÎö(±¾ÎÄϵÕûÀíËûÈËÌû×ÓÐγÉ)
¾³£¿´µ½Ò»Ð©ÅóÓÑÎÊORACLE×Ö·û¼¯·½ÃæµÄÎÊÌ⣬ÎÒÏëÒÔµü´úµÄ·½Ê½À´½éÉÜһϡ£
µÚÒ»´Îµü´ú£ºÕÆÎÕ×Ö·û¼¯·½ÃæµÄ»ù±¾¸ÅÄî
ÓÐЩÅóÓÑ¿ÉÄÜ»áÈÏΪÕâÊǶà´ËÒ»¾Ù£¬µ«Êµ¼ÊÉÏÕýÊÇÓÉÓÚ¶ÔÏà¹Ø»ù±¾¸ÅÄî°ÑÎÕ²»Ç壬²Åµ¼ÖÂÁËÖî¶àÎÊÌâºÍÒÉÎÊ¡£
Ê×ÏÈÊÇ×Ö·û¼¯µÄ¸ÅÄî¡£
ÎÒÃÇÖªµÀ£¬µç×Ó¼ÆËã»ú×î³õÊÇÓÃÀ´½øÐпÆÑ§¼ÆËãµÄ£¨ËùÒÔ½Ð×ö“¼ÆËã»ú”£©£¬µ«Ëæ×ż¼ÊõµÄ·¢Õ¹£¬»¹ÐèÒª¼ÆËã»ú½øÐÐÆäËü·½ÃæµÄÓ¦Óô¦Àí¡£Õâ¾ÍÒªÇó¼ÆËã»ú²»½öÄÜ´¦ ÀíÊýÖµ£¬»¹ÄÜ´¦ÀíÖîÈçÎÄ×Ö¡¢ÌØÊâ·ûºÅµÈÆäËüÐÅÏ¢£¬¶ø¼ÆËã»ú±¾ÉíÄÜÖ±½Ó´¦ÀíµÄÖ»ÓÐÊýÖµÐÅÏ¢£¬ËùÒÔ¾ÍÒªÇó¶ÔÕâЩÎÄ×Ö¡¢·ûºÅÐÅÏ¢½øÐÐÊýÖµ±àÂ룬×î³õµÄ×Ö·û¼¯ÊÇÎÒÃǶ¼·Ç³£ÊìϤµÄASCII£¬ËüÊÇÓÃ7¸ö¶þ½øÖÆÎ»À´±íʾ128¸ö×Ö·û£¬¶øºóÀ´Ëæ×Ų»Í¬¹ú¼Ò¡¢×éÖ¯µÄÐèÒª£¬³öÏÖÁËÐíÐí¶à¶àµÄ×Ö·û¼¯£¬Èç±íʾÎ÷Å·×Ö·ûµÄ ISO8859ϵÁеÄ×Ö·û¼¯£¬±íʾºº×ÖµÄGB2312-80¡¢GBKµÈ×Ö·û¼¯¡£
×Ö·û¼¯µÄʵÖÊ
¾ÍÊǶÔÒ»×éÌØ¶¨µÄ·ûºÅ£¬·Ö±ð¸³Ó費ͬµÄÊýÖµ±àÂ룬ÒÔ±ãÓÚ¼ÆËã»úµÄ´¦Àí¡£
×Ö·û¼¯Ö®¼äµÄת»»¡£
×Ö·û¼¯¶àÁË£¬¾Í»á´øÀ´Ò»¸öÎÊÌ⣬±ÈÈçÒ»¸ö×Ö·û£¬ÔÚijһ×Ö·û¼¯Öб»±àÂëΪһ¸öÊýÖµ£¬¶øÔÚÁíÒ»¸ö×Ö·û¼¯Öб»±àÂëΪÁíÒ»¸öÊýÖµ£¬±ÈÈçÎÒÀ´´´ÔìÁ½¸ö×Ö·û¼¯demo_charset1Óëdemo_charset2£¬ÔÚdemo_charset1ÖУ¬Îҹ涨ÁËÈý¸ö·ûºÅµÄ±àÂë Ϊ£ºA£¨0001£©£¬B£¨0010£©£¬£¿£¨1111£©£»¶øÔÚdemo_charset2ÖУ¬ÎÒÒ²¹æ¶¨ÁËÈý¸ö·ûºÅµÄ±àÂë Ϊ£ºA£¨1001£©£¬C£¨1011£©£¬£¿£¨1111£©£¬ÕâʱÎÒ½Óµ½Ò»¸öÈÎÎñ£¬Òª±àдһ¸ö³ÌÐò£¬¸ºÔðÔÚdemo_charset1Óë demo_charset2Ö®¼ä½øÐÐת»»¡£ÓÉÓÚÖªµÀÁ½¸ö×Ö·û¼¯µÄ±àÂë¹æÔò£¬¶ÔÓÚdemo_charset1ÖеÄ0001£¬ÔÚת»»Îª demo_charset2ʱ£¬Òª½«Æä±àÂë¸ÄΪ1001£»¶ÔÓÚdemo_charset1ÖеÄ1111£¬×ª»»Îªdemo_charset2ʱ£¬ÆäÊýÖµ²» ±ä£»¶ø¶ÔÓÚdemo_charset1ÖеÄ0010£¬Æä¶ÔÓ¦µÄ×Ö·ûΪB£¬µ«ÔÚdemo_charset2ûÓжÔÓ¦µÄ×Ö·û£¬ËùÒÔ´ÓÀíÂÛÉÏÎÞ·¨×ª»»£¬¶ÔÓÚËùÓÐÕâÀàÎÞ·¨×ª»»µÄÇé¿ö£¬ÎÒÃÇ¿ÉÒÔ½«ËüÃÇͳһת»»ÎªÄ¿±ê×Ö·û¼¯ÖеÄÒ»¸öÌØÊâ×Ö·û£¨³ÆÎª“Ìæ»»×Ö·û”£©£¬±ÈÈçÔÚÕâÀïÎÒÃÇ¿ÉÒÔ½«£¿×÷ÎªÌæ»»×Ö·û£¬ËùÒÔB¾Íת»»Îª ÁË£¿£¬³öÏÖÁËÐÅÏ¢µÄ¶ªÊ§£»Í¬ÑùµÀÀí£¬½«demo_charset2µÄC×Ö·ûת»»µ½demo_charset1ʱ£¬Ò²»á³öÏÖÐÅÏ¢¶ªÊ§¡£
ËùÒÔ˵£¬ÔÚ×Ö·û¼¯×ª»»¹ý³ÌÖУ¬Èç¹ûÔ´×Ö·û¼¯ÖеÄij¸ö×Ö·ûÔÚÄ¿±ê×Ö·û¼¯ÖÐûÓж¨Ò壬½«»á³öÏÖÐÅÏ¢¶ªÊ§¡£
Êý¾Ý¿â×Ö·û¼¯µÄÑ¡Ôñ¡£
ÎÒÃÇÔÚ´´½¨Êý¾Ý¿âʱ£¬ÐèÒª¿¼ÂǵÄÒ»¸öÎÊÌâ¾ÍÊ
Ïà¹ØÎĵµ£º
²âÊÔ»·¾³:
Ô´£º windows 2003, oracle 10202
Ä¿±ê£ºwindows 2000, oracle 10203
×¢£º±¾ÎÄÖÐËù˵µÄ schema ºÍ user ÊÇÒ»¸öÒâ˼¡£
impdp µÄÊý¾ÝÔ´¼È¿ÉÒÔÊÇexpdp µ¼³öÀ´µÄDMPÎļþ£¬Ò²¿ÉÒÔÊÇÒ»Êý¾Ý¿â£¬Í¨¹ýnetwo ......
Èç¹ûtemp_t1²»´æÔÚ£¬
oracle:
create table temp_t1
as
select * from t1
sql server:
select * into temp_t1 from t1
Èç¹ûtemp_t1´æÔÚ£¬
oracle:
insert into table temp_t1
select * from t1
sql server:
insert into table temp_t1
select * from t1 ......
Ñ¡Ôñ10gÊÇÒòΪ¶ÔÍø¸ñ¼¼Êõ±È½ÏºÃÆæ£¬ºÃÏñ»¹Ã»µÃµ½¹ã·ºÓ¦Óã¬Ò²¾ÍÎÞËùνÓëÇ°Ãæ°æ±¾ÓкܴóÇø±ðÁË¡£
ÔÚѸÀ×ÉÏÏÂÁ˸öÈí¼þ£¬ÔËÐÐsqlplusw£¬È»ºóÕÕ×ÅÊ飬¿ñÇÃÁËÒ»·£¬ÓÐÔÚÍøÉÏÏÂÁ˸öÊÓÆµ½Ì³Ì£¨MLDNħÀֿƼ¼_Oracle¿ÎÌã©£¬½²µÃͦºÃµÄ£¬¾ÍÊÇʱ¼ä³¤Á˵㣬²»Èç¿´ÊéÀ´µÃ¿ì¡£·´ÕýÏÖÔÚÖ»ÊÇÏëÊìϤһÏ»ù±¾Óï¾ä¡£
¿´ÁËÁ½ÌìÊéÁË¡£Á˽âÁËÒ» ......
ÁгöÅäÖõÄËùÓÐÊý¾Ý¿â
[root@node1 ~]# srvctl config database
NOVADB
ËùÓÐʵÀýºÍ·þÎñµÄ״̬
[root@node1 ~]# srvctl status database -d NOVADB
Instance NOVADB1 is running on node node1
Instance NOVADB2 is running on node node2
µ¥¸öʵÀýµÄ״̬
[root@node1 ~]# srvctl status instance -d NOVADB -i NOVA ......
Ô¤¶¨Òå½ÇÉ«ÊÇoracleÌṩµÄ½ÇÉ«,ÕâЩ½ÇÉ«ÊÇÔÚ½¨Á¢Êý¾Ý¿â,°²×°Êý¾Ý×ÖµäÊÓͼºÎPL/SQL°üʱ½¨Á¢µÄ,²¢ÇÒÿÖÖ½ÇÉ«¶¼ÓÃÓÚÖ´ÐÐÒ»Ð©ÌØ¶¨¹ÜÀíÈÎÎñ.
1,CONNECT½ÇÉ«
CONNECT½ÇɫʱÔÚ½¨Á¢Êý¾Ý¿âʱ,oracleÖ´Ðнű¾SQL.BSQ×Ô¶¯½¨Á¢µÄ½ÇÉ«,¸Ã½ÇÉ«¾ßÓÐÓ¦Óÿª·¢ÈËÔ±ËùÐèµÄ¶àÊýȨÏÞ.CONNECT½ÇÉ«¾ßÓеÄËùÓÐϵͳȨÏÞÈçÏÂ:
ALTER SESS ......