关于myeclipse中的DB Browser连接Oracle数据库的问题
我的myeclipse是6.5版, oracle是10.2.0.1的中文版.
myeclipse启动是英文的,DB Browser死活连不上oracle,报两个错误(具体不记得了).后来看了如下文章，知道了原因。
---------------------------------------------------------------------------------------------------------------------------
Hi,
a quick update on this for all interested parties as I had to research
into the very same problem and only found partial answers around.
I am not an Oracle representative so whatever I'm saying, you cannot
blame Oracle for it, and you should check for yourself if in doubt.
This is a known bug for Oracle with 10.2.x (up to 10.2.0.1) drivers
relating to mixing language and locales, e.g. en_DE or en_IT.
Normally you can set user.language and user.country or NLS_LANG with
vmargs on the Eclipse command line, but these drivers will not be able
to mix a language with a territory using a particular method, which
seems to be the method mostly everybody uses today :-)
It is declared as fixed in 10.2.0.2, for en_DE at least according to the
metalink db.
There is a patch for Oracle DBMS 10.2.0.2 on Windows available to
supported customers, but it is not available as a public download as of
today. I just checked and the 10.2.0.2 dist is available for public
download for Linux; adventurers might want to try downloading the whole
distro to extract the jdbc drivers. Check licenses carefully to
understand if it's acceptable - I'm not going to do it so I didn't
elaborate.
People with metalink access can monitor entry #4629654 (which is
specific to en_DE) and related entries to stay updated.
Currently, the easiest workaround is downgrading to 10.1 drivers, unless
you need 10.2 explicitly of course.
Generally speaking, if you routinely update your jdbc drivers only
because they become available, well my advice is simply *change habit*,
and update only if you need to do it for some specific reason. Bugs are
frequently solved and re-introduced, unfort
相关文档：
begin
for item in (select * from user_constraints a where a.constraint_type = 'R') loop
execute immediate 'alter table ' || item.table_name || ' disable constraint ' || item.constraint_name;
end loop;
end;
/ ......
从oracle8到oracle10，JDBC目录下的驱动包都各有不同。看了一下oracle的文档说明，了解了一下它们的用途，相信大家有时候也很迷惑，写出来共享一下。
这些是oracle10g下的驱动包的名称和它们的作用，其他版本的oracle基本类似。
支持所有平台的JDBC Thin驱动
classes12.jar (1,417,089 bytes) - JDK 1.2 和 JDK 1.3下使� ......
1、通过Toad将数据可结构生成SQL（注意用户）。
[DataBase] [Export] [GenerateSchmaScript]
2、创建DBLink.
DROP PUBLIC DATABASE LINK "ROOT.US.ORACLE.COM";
CREATE PUBLIC DATABASE LINK "ROOT.US.ORACLE.COM"
&nb ......
小型机路线，几乎已被封死。无法使用Sun，它已和Oracle紧密绑定，若还使用上述设计，会很难说服售前将小型机、存储、数据库分别从不同厂商采购；另外，亦无法使用IBM，据说FLY的某个老板不喜欢。 大力推进数据库系统PC化，这似乎是最佳策略。FLY应用对数据 ......
