关于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;
/ ......
最近忙于公司的项目开发，很久没有来csdn了。今天无事，上来写点东西。供大家参考，不对的地方还希望大家批评指正。
一下是对oracle数据库表的一些操作语句：
已经建好的表添加字段
alter table Tablename add(column1&nb ......
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 ......
1.曾经不小心把开发库的数据库表全部删除，当时吓的要死。结果找到下面的语句恢复到了1个小时之前的数据！很简单。
注意使用管理员登录系统：
select * from 表名 as of timestamp sysdate-1/12 //查询两个小时前的某表数据！既然两小时以前的数据都得到了，继续怎么做，知道了吧。。
如果drop了表，怎么办？？见下 ......
