-
编辑 删除
Oracle 10gR2 RAC+ RHEL4 + VMWare GSX 简明安装步骤--推荐参考
http://bbs.chinaunix.net/viewthread.php?tid=691938&extra=page%3D2%26filter%3Ddigest&page=1 ********************************************Oracle 10gR2 RAC + RHEL AS4U2 +VMWare GSX 3.2.0 Deployment bri...
-
编辑 删除
Oracle客户端穿过防火墙连接服务器[转载]
http://www.cnblogs.com/zyk/archive/2004/11/16/59538.htmlOracle客户端连接服务器，首先去找1521监听端口，服务器的1521监听端口再向server process进程发出请求，并返回一个随机端口，返回给客户端，客户端再来连...
-
编辑 删除
oracle9i的新特性
来自网友1关键基础结构领域的新特征 1.1 实现连续的数据可用性 1.1.1 世界领先的数据保护环境1.1.2 联机数据演变1.1.3 准确的数据库修复1.1.4 自我服务错误更正1.2 可伸缩性和性能 1.2.1 Orac...
-
编辑 删除
How to create a LOB Table ?[akadia]
If you plan to store LOB data, together with other data in the same table, then you should store the LOB data in a separate tablespace.CREATE TABLE news ( id NUMBER(12) NOT NULL, ne...
-
编辑 删除
Interacting with Oracle via the UNIX Korn shell [akadia]
UNIX remains a fabulous choice for hosting Oracle databases. Both technologies have proven to be more flexible and more stable for more time than most of us care to remember.The remarkable 'Korn' shel...
-
编辑 删除
数据库实例崩溃一例
只要数据库的监听打开一会，数据库实例很快就崩溃:错误信息如下：Fri Mar 2 15:59:37 2007Errors in file /ora9i/app/oracle/admin/ora9i/udump/ora9i_ora_28760.trc:ORA-00600: internal error code, arguments: [...
-
编辑 删除
GBK不是CGB的超集
第四次遇到这个情况了 ora805 exp by cgb 不能 imp gbk ora817.某些字符不能被gbk解析。使用gbk exp的情况没有试，因为没有时间了 。两种方式都不行的案例不久前也遇到过。 只好装成 cgb了.幸好先做了一个...
-
编辑 删除
oracle7的一个建库过程
比高版本简单 connect internal; startup nomount; CREATE DATABASE CCPROD1 LOGFILE GROUP 1 ('/user5/oradata/CCPROD1/log11.log') SIZE 100000K...
-
编辑 删除
Slow count(*) and the Highwater Mark[akadia]
For each object, Oracle also maintains a record of the highest relative block of the table used to hold data. This highwater mark is maintained in multiples of five blocks and is not reset unless the ...
-
编辑 删除
问题解决小记[20040825]：EXP-00003: no storage definition found for segment ....
服务器：oracle9.2.0.5客户端：oracle9.2.0.1用户表中含有clob,long类型，用客户端exp则报错EXP-00003,在服务器上exp没有问题.经查metalink,又是bug，给客户端打补丁：9205，问题解决....
-
编辑 删除
如何冻结数据库
from metalink.GoalWhat is the behaviour of the following two SQL statements? ALTER SYSTEM SUSPEND;ALTER SYSTEM RESUME; FixWhen SUSPEND / RESUME should be used===============================These two c...
-
编辑 删除
Unregister a Database From RMAN[9i]
First we start up RMAN with a connection to the catalog and the target, making a note of the DBID in the banner:First we start up RMAN with a connection to the catalog and the target, making a note of...
-
编辑 删除
LONG to BLOB Migration[akadia]
In release 8.1, a new SQL function, TO_LOB, copies data from a LONG column in a table to a LOB column. The datatype of the LONG and LOB must correspond for a successful copy. For example, LONG RAW dat...
-
编辑 删除
The Power of EXECUTE IMMEDIATE and CASE WHEN[akadia]
Never do procedurally what you can do in a single SQL statement. If you have a typical CASE construct you can use EXECUTE IMMEDIATE with a CASE statement.Suppose you have the following UPDATE:DECLARE ...
-
编辑 删除
CREATE TABLE AS and LONG RAW[from akadia]
Long Raw data types cannot be included in the CREATE TABLE AS syntax. This is documented in the Oracle 7.3 or 8.0 Server SQL Reference Guide 'AS subquery' clause explanation of the CREATE TABLE syntax...
-
编辑 删除
最近优化了两个很烂的系统
已经用了好几年了,数据量的增长较快,不做优化就只能换新的硬件了.全表扫描的语句很多,简单地创建合适的索引/修改部分代码后就快了很多.只有两个东西值得说一下:1. 某些表的字段由于类型是char,导致索引无法使用,将类...
-
编辑 删除
ORA-01114: 将块写入文件 %s 时出现 IO 错误 (块 # %s) 错误
sqlplus里执行某条语句，报错：ORA-01114: 将块写入文件 %s 时出现 IO 错误 (块 # %s) 错误文件号和块号没有报出来.:(查看alert文件，后台却报出来了.
-
编辑 删除
Wait Event Enhancements in Oracle 10g
http://www.dbspecialists.com/presentations/wait_events_10g.html
-
编辑 删除
Restrict the Number of Records[akadia]
While developping database application we often have to restrict the number of records an end user can insert into a table. A simple solution is the following code fragment in the BEFORE-INSERT-FOR-EA...
-
编辑 删除
Dynamic SQL queries that return multirow result sets[akadia]
The OPEN FOR clause allows to build dynamic SQL with variable table-, or column names that return multirow result sets. Let's take a closer look at OPEN FOR and multirow queries with a concrete exampl...
