oracle 文档
http://www.oracle.com/technology/documentation/database10gr2.html
Oracle Database 10g
Release 2 Documentation Library
Part Number
|
Link
|
Download
|
Description
|
B19306-01 |
View
Library
|
Download
(445.8MB) |
Documentation library for Oracle Database |
Oracle Database 10g
Lite Documentation Library
Part Number
Link
Download
Description
B19188-01 |
View Library
|
Download
(15 MB) |
Documentation library for Oracle Database Lite |
取oracle的error code 错误码查询
oerr - Oracle Error Code Lookup 20090424 / firefox search 插件
https://addons.mozilla.org/zh-CN/firefox/addon/11641
oracle 9i错误代码查询书
http://www.ixpub.net/viewthread.php?tid=894178&pid=8079387&page=1&extra=#pid8079387
http://www.ixpub.net/attachment.php?aid=561448&k=e1ad1c032ff9caa51b455fe162d4d127&t=1253264288&ck=0f28a96d&sid=41faJgW8TvspEtwfoyD1T7uYjnz5RFNvm7%2F1s%2FyDxXSA8j4
辅助开发工具 oracle 错误代码查询
http://www.oracle.com.cn/viewthread.php?tid=142070&pid=1097754&page=1&extra=#pid1097754
http://www.oracle.com.cn/attachment.php?aid=61153
http://tahiti.oracle.com/
http://www.ora-code.com/ 或 http://ora-12537.ora-code.com
http://dolphin-ygj.iteye.com/blog/361948
http://clarancepeng.iteye.com/blog/118394
file:///E:/program/database/Oracle/oracle%20doc/oracle-err-code.html
E:\program\database\Oracle\oracle doc\oracle错误代码和信息速查手册.chm
http://dl.iteye.com/topics/download/db9f7833-9fb3-4cfe-aae6-a4723c135ff2
http://dl.iteye.com/topics/download/c10f2b24-21d7-3a3b-a6e3-5740bcd828de
有时候需要知道oracle的error code的具体含义, 但总是找不全
不过可以通过以下方式直接从oracle数据库本身获得:
create type t_oracle_error is object (
error_num varchar2(9),
error_desc varchar2(1024)
);
create type t_oracle_error_tab is table of t_oracle_error;
create or replace function OracleErrors return t_oracle_error_tab pipelined is
l_error t_oracle_error := t_oracle_error(null,null);
begin
for errNo in reverse -32799..0 loop
l_error.error_num := errNo;
l_error.error_desc := sqlerrm(errNo);
if l_error.error_desc not like '%Message % not found;%' and l_error.error_desc != 'ORA'||to_char(errNo,'FM09999')||': ' then
pipe row(l_error);
end if;
end loop;
return;
end OracleErrors;
select * from table(oracleerrors);
一个简单的查询所有Oracle错误代码的语句
作者:fuyuncat
多年电信、航运行业经验的Oracle DBA
mail: fuyuncat@gmail.com; fuyuncat@sina.com
msn:fuyuncat@hotmail.com
Home
Page: http://www.HelloDBA.com/
http://fuyuncat.itpub.net/post/5203/64265
begin
dbms_output.enable(1000000);
for i in 0..10000 loop
dbms_output.put_line(SQLERRM(0-i));
end loop;
dbms_output.disable();
dbms_output.enable(1000000);
for i in 10001..20000 loop
dbms_output.put_line(SQLERRM(0-i));
end loop;
end;/
end
分享到:
相关推荐
su - oracle -c "exp system/manager full=y inctype=complete file=/oracle/export/db_comp$rq.dmp" 累计备份的SH文件:exp_cumu.sh rq=` date +"%m%d" ` su - oracle -c "exp system/manager full=y inctype=...
oracle学习文档 笔记 全面 深刻 详细 通俗易懂 doc word格式 清晰 第一章 Oracle入门 一、 数据库概述 数据库(Database)是按照数据结构来组织、存储和管理数据的仓库,它产生于距今五十年前。简单来说是本身可视...
针对数据库的启动和关闭、控制文件与数据库初始化、参数及参数文件、数据字典、内存管理、Buffer Cache与Shared Pool原理、重做、回滚与撤销、等待事件、性能诊断与SQL优化等几大Oracle热点主题,本书从基础知识入手...
See - tfmadmin_create.sql This account will be the repository for all of the Oracle objects used by the utility and will be responsible for retrieving information from the file system for presentation...
error_reporting ; Default Value: E_ALL & ~E_NOTICE & ~E_STRICT & ~E_DEPRECATED ; Development Value: E_ALL ; Production Value: E_ALL & ~E_DEPRECATED & ~E_STRICT ; html_errors ; Default Value: On ; ...
1、ExecuteNonQueryByTran func ExecuteNonQueryByTran(db *sql.DB, SqlList []string) error 批量执行 含事务 nil 成功 err 失败 MongoDB 禁止使用,其他数据库自行斟酌(目前支持Oracle) 测试指令: go test -v ...
ORA-00257: archiver error. Connect internal only, until freed 查看归档日志序列 SQL> archive log list; Automatic archival Enabled #自动归档 Archive destination USE_DB_RECOVERY_FILE_DEST #归档目录为...
The Test Window now supports Oracle12c implicit results, which are automatically detected and added to the variable list: A new Oracle / Output preference has been added to save dbms_output to a file....
The Test Window now supports Oracle12c implicit results, which are automatically detected and added to the variable list: A new Oracle / Output preference has been added to save dbms_output to a file....
The Test Window now supports Oracle12c implicit results, which are automatically detected and added to the variable list: A new Oracle / Output preference has been added to save dbms_output to a file...
The Test Window now supports Oracle12c implicit results, which are automatically detected and added to the variable list: A new Oracle / Output preference has been added to save dbms_output to a file...
Error Handling and Logging Functions XXXIII. Exif Functions XXXIV. Expect Functions XXXV. File Alteration Monitor Functions XXXVI. Forms Data Format Functions XXXVII. filePro Functions XXXVIII. ...
Error Handling and Logging Functions XXXIII. Exif Functions XXXIV. Expect Functions XXXV. File Alteration Monitor Functions XXXVI. Forms Data Format Functions XXXVII. filePro Functions XXXVIII. ...
* TClientDataset.FindKey will fail with an list index error when used on a cloned nested dataset (Quality Central 3786). * When the size of a Persistent field in TClientDataSet is set too large, it ...
Here is a list of major features implemented in sqlmap: * Full support for MySQL, Oracle, PostgreSQL and Microsoft SQL Server database management system back-end. Besides these four DBMS, sqlmap ...
By supplying a DSN entry, it will attempt to connect to that database and list all the tables in it. When you click on a table, it lists all <END><br>38,3a.zip An Inventory System, you can add, ...
卷 data 的文件夹 PATH 列表 卷序列号为 64ED-8C1D D:\我的酷盘\FTP\学员面试资料 │ 164个完整Java代码.zip │ J2EE综合--Struts常见错误的全面汇总.txt │ java程序员面试资料.zip │ JAVA笔试题(上海释锐)....
卷 data 的文件夹 PATH 列表 卷序列号为 64ED-8C1D D:\我的酷盘\FTP\学员面试资料 │ 164个完整Java代码.zip │ J2EE综合--Struts常见错误的全面汇总.txt │ java程序员面试资料.zip │ JAVA笔试题(上海释锐)....
卷 data 的文件夹 PATH 列表 卷序列号为 64ED-8C1D D:\我的酷盘\FTP\学员面试资料 │ 164个完整Java代码.zip │ J2EE综合--Struts常见错误的全面汇总.txt │ java程序员面试资料.zip │ JAVA笔试题(上海释锐)....
卷 data 的文件夹 PATH 列表 卷序列号为 64ED-8C1D D:\我的酷盘\FTP\学员面试资料 │ 164个完整Java代码.zip │ J2EE综合--Struts常见错误的全面汇总.txt │ java程序员面试资料.zip │ JAVA笔试题(上海释锐)....