Little and Mickle

All things are difficult before they are easy.

导航

随笔分类 -  Oracle

Oracle Database
to create table if table do not exist -- to backup and restore table in oracle
摘要：1.to backup tblPermission into tblPermissionBak. If tblPermissionBak does not exist, Create the table and insert all data of tblPermission into tblPermissionBak. If tblPermissionBak exists, insert all... 阅读全文

posted @ 2005-09-21 17:01 davidullua 阅读(1057) 评论(0) 推荐(0)

Oracle FAQ: 未在本地计算机上注册"OraOLEDB.Oracle"提供程序 (The 'OraOLEDB.Oracle' provider is not registered on the local machine) solution
摘要：使用OLEDB方式连接Oracle数据库，使用Provider=MSDAORA.1;可正常使用，改成Provider=OraOLEDB.Oracle;报错，显示说：未在本地计算机上注册"OraOLEDB.Oracle"提供程序(The 'OraOLEDB.Oracle' provider is not registered on the local machine.). 查了一下，发现是装Orac... 阅读全文

posted @ 2005-09-16 11:48 davidullua 阅读(7790) 评论(3) 推荐(0)

ora-00054 , alter system kill session 'id,serial#'
摘要：连接oracle运行drop table遇到了ora-00054的错误，提示资源正忙，需要提交transaction, 或者杀掉session,可以通过下面的命令找到活跃的session，select saddr,sid,serial#,paddr,username,machine,status from v$session where username is not null;然后kill掉未提... 阅读全文

posted @ 2005-09-13 15:11 davidullua 阅读(3657) 评论(0) 推荐(0)