ORACLE
文章平均质量分 87
开发者开聊
24年经验老码农,重新开始学编程。
展开
-
LOB
首页 > 数据库 > Oracle > 正文转载 2006-03-31 19:59:00 · 991 阅读 · 0 评论 -
Calling Pro*C program from a package", version 8.0.5
You Asked (Jump to Toms latest followup)Can you provide any information/examples ofa package that calls a Pro*C program.The package must pass several parameters to the Pro*C program.It would转载 2006-04-14 22:51:00 · 894 阅读 · 0 评论 -
How do i prevent end users from connecting to the database other than my application?", version 8.1.5
You Asked (Jump to Toms latest followup)Hi Tom, Thanks for your help.We have a client/Server and a web interface. We want our end usersto connect to the database only through our applicati转载 2006-04-14 22:48:00 · 5472 阅读 · 0 评论 -
How to Update millions or records in a table", version 8.1.7
You Asked (Jump to Toms latest followup)Good Morning Tom.I need your expertise in this regard. I got a table which contains millions or records. I want to update and commit every time for so m转载 2006-04-14 22:45:00 · 14538 阅读 · 0 评论 -
Creating dll for executing external procedure('c' language)", version Version 8i
You Asked (Jump to Toms latest followup)Hi Tom, I am using Wint NT,Oracle 8i(server) and C language. My goal is calling c routine thru stored procedure. For that I had made n转载 2006-04-14 22:41:00 · 2310 阅读 · 0 评论 -
DIFFERENCES BETWEEN PROCESSES, SESSIONS AND CONNECTIONS", version 8.1.7.4
You Asked (Jump to Toms latest followup)TomCan you give an example carried out in pro* c and the same done in pl/sql, and show us which is faster and why.I guess pro*c also does array in转载 2006-04-14 22:21:00 · 1099 阅读 · 0 评论 -
Thanks for the question regarding "About utl_smtp", version 8.1.7
You Asked (Jump to Toms latest followup)Hi Tom,I created the procedure send_mail as in your book in the user System. create or replace procedure send_mail( p_sender in varchar2, p_reci转载 2006-04-14 21:54:00 · 4079 阅读 · 0 评论 -
关于P4安装ORACLE解决方法
P4的计算机最好安装ORACLE 9I 如果不方便的话可以按照以下的方法安装ORACLE 8I (其实也不是所有的P4CPU都不可以安装ORACLE8 I 我的一台P4 1。7 安装ORACLE 8.1.6就一点问题没有) 在P4机器上安装Oracle 8i 一、系统环境及准备工作 硬件: Intel P4的处理器 256M的内存 硬盘有三个分区C、D、E,光驱为F 软件: 操作系统WIN转载 2006-04-06 22:19:00 · 718 阅读 · 0 评论 -
RHAS3 and oracle9204
http://support.geisnic.com/file_detail/2006-3-9/2006391120393210.htm1、从网上下载redhat Enterprise Linux Advanced Server3的四个安装文件,安装时swap分区设置为内存的二倍。不要采用DHCP设置主机名和IP地址,而是“手工设置”。否则会在安装oracle的时候出现如下错误: 引用:Thr转载 2006-04-05 19:25:00 · 1359 阅读 · 0 评论 -
Linux AS3 ORACLE RAC策略安装手册
Linux AS3 ORACLE RAC策略安装手册作者:Linux AS3 ORACLE RAC策略安装手册验证 RAC 集群 / 数据库配置 当 DBCA 完成时,您将拥有一个功能完全的、运行的 Oracle RAC 集群。 这一部分提供了可用来验证您的 Oracle9 i RAC 配置的几条命令和 SQL 查询。 --Look for Oracle Cluster Manager-- $转载 2006-04-05 19:58:00 · 1430 阅读 · 0 评论 -
如何收集Oracle进程中的sql跟踪信息
在诊断数据库系统性能的过程中,总会涉及到跟踪效率低下的sql语句,现在就如何跟踪sql语句来做一个简单的总结。权做抛砖引玉之用。 如果我们可以修改应用系统的源代码,则可以直接在程序中加入如下的语句: 1)alter session set timed_statistics=true; /*适用于Oracle 7.3以后的版本*/ 2)alter session set max_dump转载 2006-04-05 19:56:00 · 854 阅读 · 0 评论 -
如何在其他Session跳过被锁定的记录
如何在其他Session跳过被锁定的记录作者:eygle出处:http://www.eygle.com/blog日期:March 04, 2005浏览次数:187本文链接:http://www.eygle.com/archives/2005/03/eciouaeeeusessi.html? 如何重建UNDO TABLESPACE | Blog首页 | CSDN的Blog,我们最需要什么? ?转载 2006-03-31 12:59:00 · 718 阅读 · 0 评论 -
ORA-04091错误解决
ORA-04091错误解决 ORA-04091错误是常见的一个错误,下面这个描述了该错误及在那种情况下触发器会产生这个错误。原文链接出处:http://www.databasejournal.com/features/oracle/article.php/3329121The Mutating table error is a well-known problem enco转载 2006-03-31 22:13:00 · 3416 阅读 · 0 评论 -
最好解决方案
查看完整版本: [-- 最好解决方案 --] 最好解决方案登录 -> 注册 云计算综合交流访谈IT资讯发展成长薪资揭秘行业分析职业规划业界市场项目软件求职招聘职业生涯原创 2009-10-19 23:24:00 · 1623 阅读 · 0 评论