-
编辑 删除
prebuilt table
http://www.itpub.net/showthread.php?threadid=309939&pagenumber=值得推荐.
-
编辑 删除
ORA-26040: Data block was loaded using the NOLOGGING option
最近也遇到了这个问题：ORA-01578: ORACLE data block corrupted (file # 17, block # 271)ORA-01110: data file 17: '/dev/rlv_sgyfz_dat01'ORA-26040: Data block was loaded using the NOLOGGING optionORA-06512...
-
编辑 删除
ORA-01157
ORA-01157: cannot identify/lock data file 4 - see DBWR trace file ORA-01110: data file 4: '/dev/rdrsys_lv'国庆前用户将网络、主机、数据库全部正常关闭，10.8日开机时遇到这个错。经检查，是由于交换机出故...
-
编辑 删除
exp很慢
升级前准备做一个全库的 exp, 于是就直接运行 crontab 里的脚本，却发现很慢，速度越是50 k/s.es40 ora805 ra7000 1cpu开始以为sga开小了，只有75M(估计是buffer少了一个0)可加大以后,速度依然。于...
-
编辑 删除
Interacting with Oracle via the UNIX Korn shell [adakia]
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...
-
编辑 删除
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...
-
编辑 删除
张靓颖新东家终落定 千万巨资齐力打造“巨星”
这真是一个很不错的消息。http://ent.sina.com.cn/y/2005-10-25/1914875776.html
-
编辑 删除
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 ...
-
编辑 删除
足彩常用缩水算法-7-16
7个310,7个31,中14包13.3333333333333333333331113333333333313311333333333311113333333333131313333333313113133333333113311333333333313113333333311313313333333331133133333333133131333333313131313333333133...
-
编辑 删除
问题解决小记[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...
