oracle×Ö·û¼¯
×÷Ϊһ¸öORACLE DBA,ÔÚ¹¤×÷Öлᾳ£´¦ÀíÓÉÓÚ×Ö·û¼¯²úÉúµÄһЩÎÊÌâ¡£µ«Êǵ±ÕæÕýÏëдһЩÕâ·½ÃæµÄ¶«Î÷ʱ£¬È´Í»È»ÓÖûÓÐÁËÍ·Ð÷¡£·¢ÁË°ëÌì´ô£¬»¹ÊǾö¶¨ÓÃÁ½¸ö×Ö·û¼¯·½ÃæµÄÀý×Ó×÷ΪÇÐÈëµã£¬µ¹²»Ê§ÎªÒ»¸öÍ·Ð÷£¬Ëµ²»¶¨ÔÚʵÑéµÄ¹ý³ÌÖУ¬ÎÊÌâ¾Í»áÒ»¸ö½Ó×ÅÒ»¸öµÄ¸¡ÏÖ³öÀ´¡£
ÏÖÔÚ£¬ÈÃÎÒÃÇÇÐÈëÕýÌâ¡£
ÎÒÓõÄÊý¾Ý¿âÊÇoracle10.2.0.3,Êý¾Ý¿â×Ö·û¼¯ÊÇal32utf8¡£
¿Í»§¶Ë¾ÍÊÇͬһ̨»úÆ÷µÄwindows xp.
ÏÂÃæÊÇÑÝʾµÄÀý×Ó£º
SQL> drop table test purge;
Table dropped.
SQL> create table test(col1 number(1),col2 varchar2(10));
Table created.
--session 1 ÉèÖÿͻ§¶Ë×Ö·û¼¯Îª zhs16gbk£¨ÐÞ¸Ä×¢²á±ínls_langÏîµÄcharacterset Ϊzhs16gbk£© Ïò±íÖвåÈëÁ½¸öÖÐÎÄ×Ö·û¡£
SQL> insert into test values(1,'Öйú'); --1Ϊsession 1µÄ±ê¼Ç
1 row created.
SQL> commit;
Commit complete.
--session 2 ÉèÖÿͻ§¶Ë×Ö·û¼¯ al32utf8£¨ÐÞ¸Ä×¢²á±ínls_langÏîµÄcharacterset Ϊal32utf8£©£¬ÓëÊý¾Ý¿â×Ö·û¼¯Ïàͬ¡£ Ïò±íÖвåÈëÁ½¸öºÍsession 1ÏàͬµÄÖÐÎÄ×Ö·û¡£
SQL> insert into test values(2,'Öйú'); --2Ϊsession 2µÄ±ê¼Ç
1 row created.
SQL> commit;
Commit complete.
--session 1
SQL> select * from test;
COL1 COL2
---------- --------------------
2 £¿??
1 Öйú
--session 2
SQL> select * from test;
COL1 COL2
---------- ----------
2 Öйú
1 ä¸浗
´Ósession 1ºÍsession 2µÄ½á¹ûÖпÉÒÔ¿´µ½£¬ÏàͬµÄ×Ö·û£¨×¢Ò⣬ÎÒÖ¸µÄÊÇÎÒÃÇ¿´µ½µÄ£¬ÏÔʾΪÏàͬµÄ×Ö·û£©£¬ÔÚ²»Í¬µÄ×Ö·û¼¯ÊäÈë»·¾³Ï£¬ÏÔʾ³ÉÁËÂÒÂë¡£
ÔÚzhs16gbk×Ö·û¼¯µÄ¿Í»§¶Ë£¬ÎÒÃÇ¿´µ½ÁËutf8×Ö·û¼¯¿Í»§¶ËÊäÈëµÄÏàͬµÄÖÐÎıä³ÉÁËÂÒÂë-->col1=2µÄcol2×Ö¶Î
ÔÚutf8×Ö·û¼¯¿Í»§¶Ë£¬ÎÒÃÇ¿´µ½zhs16gbk×Ö·û¼¯µÄ¿Í»§¶ËÊäÈëµÄÖÐÎıä³ÉÁËÁíÍâµÄ×Ö·û -->col1=1µÄcol2×Ö¶Î
´ÓÕâ¸öÀý×ÓÀÎÒÃǺÃÏñ¸Ð¾õµ½³öÁËʲôÎÊÌ⣬Ҳ¿ÉÄÜ»áÁªÏëÆðÏÖʵ»·¾³ÖгöÏÖµÄÂÒÂëÎÊÌâ¡£
ÎÊÌâËƺõÓÐÁË˼·£¬ok£¬ÈÃÎÒÃǼÌÐø°ÑʵÑé×öÏÂÈ¥£º
--session 1 £¨»òÕßsession 2£¬ÔÚÕâÀïÎÞËùν£©
SQL> select col1,dump(col2,1016) from test;
COL1
----------
DUMP(COL2,1016)
--------------------------------------------------------------------------------
2
Typ=1 Len=4 CharacterSet=AL32UTF8: d6,d0,b9,fa
1
Typ=1 Len=6 CharacterSet=AL32UTF8: e4
Ïà¹ØÎĵµ£º
-- ²éѯÍâ¼üÔ¼Êø(²éij±íµÄËùÓи¸±í)
select c.constraint_name,cc.column_name,rcc.owner,rcc.table_name,rcc.column_name
from user_constraints c,user_cons_columns cc,user_cons_columns rcc
where c.owner=' ......
Oracle
SqlServer2000 2005
MySql
DB2
ORACLE sun SUN
Êý¾Ý¿â DataBase db
´æ´¢Êý¾Ý
Êý¾Ý Data
Êý×Ö   ......
££Õª×Ô¡¶PB8.0½ø½×ƪ¡·
ÔÚ°²×°ÁËOracle¿Í»§¶Ë³ÌÐòºó£¬ÔÚOracle°²×°Ä¿Â¼ÏÂÓÐÈçÏÂĿ¼ºÍÎļþÊÇÁ¬½ÓOracleÊý¾Ý¿â·þÎñÆ÷Ëù±ØÐèµÄ£º£¨×îºÃ±£³ÖĿ¼²ã´Î¹Øϵ½á¹¹£©
Oracle\BINĿ¼ÒÔ¼°ÏÂÃæµÄËùÓÐDLLÎļþ£¬²¢ÇÒ±£Ö¤Ó¦ÓóÌÐò¿ÉÒÔÕÒµ½¸ÃĿ¼£¬¼´¸ÃĿ¼ ......
package com.deng.oracle;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class TestOracle {
public static void main(String[] args) {
try {
Class.forName("oracle.jdbc.driver.OracleDriv ......
£±¡¢È·¶¨ÄãµÄ¼ÆËã»úÉÏ×°ÓÐoracleµÄ¿Í»§¶Ë£¬Èç¹ûûÓУ¬Çë°²×°oracle¿Í»§¶Ë
£²¡¢È·¶¨ÓÐÄãµÄoracle·þÎñÀïÓÐÄãÒªÐèÒª±¸·ÝµÄÊý¾Ý¿âµÄ·þÎñÃû¡£
£³¡¢ÖÆ×÷Ò»¸öÅú´¦ÀíÎļþ£¨oracleBackup.bat£©£¬¾ßÌå·½·¨£º´ò¿ª“¼Çʱ¾”£¬±£´æΪoracleBackup.bat£¬
¡¡¡¡´Ëʱ±£´æµÄÎļþÀàÐÍÑ¡ÔñΪ“ËùÓÐÎļþ”¡£Îҵı£´æÄ¿Â ......