ORA 07445 与 PL/SQL Developer 案例一则
ORA-07445 与 PL/SQL Developer 案例一则
作者：eygle |English Version 【转载时请以超链接形式标明文章出处和作者信息及本声明】
链接：http://www.eygle.com/archives/2009/02/ora_07445_plsql_developer.html
--------------------------------------------------------------------------------
前几天，又有一个客户的系统遇到了PL/SQL Developer引起的Bug，而且又是ORA-07445的骇人错误。
最近曾经遇到一起Oracle 10.2.0.3中和PL/SQL Developer相关的Bug，参考链接：
http://www.eygle.com/archives/2009/02/ora_07445_kprball.html
这次的错误信息如下：
Mon Dec 8 19:12:16 2008
Errors in file /opt/oracle/admin/orcl/udump/orcl1_ora_19228.trc:
ORA-07445: exception encountered: core dump [00000001022CEF08] [SIGSEGV] [Address not mapped to object] [0x000000010] [] []
Mon Dec 8 19:12:16 2008
Trace dumping is performing id=[cdmp_20081208191216]
Mon Dec 8 20:03:28 2008
Errors in file /opt/oracle/admin/orcl/udump/orcl1_ora_25214.trc:
ORA-07445: exception encountered: core dump [00000001022CEF08] [SIGSEGV] [Address not mapped to object] [0x000000010] [] []
Mon Dec 8 20:03:28 2008
Trace dumping is performing id=[cdmp_20081208200328]
Mon Dec 8 20:03:54 2008
Errors in file /opt/oracle/admin/orcl/udump/orcl1_ora_25941.trc:
ORA-07445: exception encountered: core dump [00000001022CEF08] [SIGSEGV] [Address not mapped to object] [0x000000010] [] []
Mon Dec 8 20:04:31 2008
Errors in file /opt/oracle/admin/orcl/udump/orcl1_ora_26610.trc:
ORA-07445: exception encountered: core dump [00000001022CEF08] [SIGSEGV] [Address not mapped to object] [0x000000010] [] []
Tue Dec 9 09:43:56 2008
Errors in file /opt/oracle/admin/orcl/udump/orcl1_ora_11477.trc:
ORA-07445: exception encountered: core dump [00000001022CEF08] [SIGSEGV] [Address not mapped to object] [0x000000010] [] []
在跟踪文件中记录了一大段如下代码,这个错误不会引起数据库的故障，Metalink上认为这个PL/SQL Developer的问题，在新版本中应该得到修正。所以如果你遇到这个错误，可以考虑升级一下PL/SQL Developer软
相关文档：
下列语句部分是Mssql语句，不可以在access中使用。
SQL分类：
DDL—数据定义语言(CREATE，ALTER，DROP，DECLARE)
DML—数据操纵语言(SELECT，DELETE，UPDATE，INSERT)
DCL—数据控制语言(GRANT，REVOKE，COMMIT，ROLLBACK)
首先,简要介绍基础语句：
1、说明：创建数据库 ......
---1、添加数据文件
use master
go
--Fam200901
alter database RedfDB
add filegroup FGAM200901
go
alter database RedfDB
add file(name='FGAM200901',filename='D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Fam200901.mdf',
size=20,maxsize=40,filegrowth=10% ......
