-
编辑 删除
Manually Removing all Oracle Components from NT / 2000 [akadia]
This important Tip was published on Oracle Metalink.If you have many Oracle Releases and Tools on your NT or W2000 Workstation, you may encounter problems to deinstall all of them with the Oracle Inst...
-
编辑 删除
昨天去做了一会专家
一个政府部门打算重新规划所有的应用系统,但是在采取大集中模式还是分布式模式时,讨论了一两个月,定不下来,当然开发方不希望大集中模式.最终,由我拍板,还是采用大集中模式,呵呵:)...
-
编辑 删除
dbca error: the database name must be between 1 and 8 characters
同事用dbca创建数据库的时候，运行到了输入 Global database name和sid的时候， 已经输入了，但是next的时候提示 the database name must be between 1 and 8 characters the sid name must be between 1 and 8 alphanumic characters in length. 原因是：跟建库的终端程序有关。解决方法：在本地即可.[@more@]
-
编辑 删除
EXP-00000: Message 0 not found; No message file for product=RDBMS, facility=EXP
在open vms操作系统上面装了一个oracle734的数据库，在用exp的时候报以下的错误：ES400$expMessage 206 not found; No message file for product=RDBMS, facility=EXP: Release7.3.4.3.0 - Production on Thu Apr 28...
-
编辑 删除
帮记羊肉馆真不错
这可能是江门最好的羊肉馆.开了很远的车, 感觉快到了农村了.门口停满了车,看来真的是很旺.羊肉涮得味道真不错,回来牙都软了:)
-
编辑 删除
Use of the NVL2 Function[akadia]
NVL2: check for the existence of NOT NULLMost of us are familiar with the NVL function which checks for the existence of NULL values. Oracle provides a new function called NVL2 which checks for the ex...
-
编辑 删除
部署了一个Data Guard数据库
os:p570 aix5.3db:oracle9.2.0.4 两边都是裸设备管理 存储是异地的.模式：采用最大性能并多次测试了switchover功能[连用户和新来的同事都练了手],挺爽的.经验教训：关键时候还是要看oracle的官方文挡，网上的很多帖...
-
编辑 删除
The Power of Inline Views[akadia]
A subquery in the FROM clause of a SELECT statement is also called an inline view. When a query contains an inline view, the inline is merged into the query. Powerful constructs can be built using inl...
-
编辑 删除
Oracle Applications Release 10.7 Installation Checklist
最近在做一个ERP项目http://appsdba.omp.net/oa_check.htmAuthor: Andy Rivenes (arivenes@appsdba.com)Copyright AppsDBA Consulting, all rights reservedLast Updated: September 1, 1999 This is a checklist th...
-
编辑 删除
ora-00600[6302]错误解决一例
一个旅业系统,insert数据库时偶尔会抱:ora-00600[6302][8]经检查,是跟index的pctfree(=5)过小有关,加大到10,重建所有的索引,ok
-
编辑 删除
How to connect to a system regardless of machine failure ? [akadia]
You can place multiple address entries for a single connection alias in the TNSNAMES.ORA file. This means that you can connect to a database, even if some kind of physical failover occurred. Look at t...
-
编辑 删除
64位曙光x86_64 linux 安装64位的oracle9204
遇到一个link出错，参考以下博客后解决：http://yangtingkun.itpub.net/在安装过程中，报错误： Error in invoking target install of makefile /opt/oracle/product/9.2/rdbms/lib/ins_rdbms.mk ，这里也点击 ignor...
-
编辑 删除
Sizing of Locally Managed Tablespaces[from akadia]
More and more we are using locally managed tablespaces. They offer a large amount of benefits, so why should we not use this new feature?Some thoughts are needed when you decided to use Uniform Extent...
-
编辑 删除
五一期间完成了某市交警系统的一个系统升级迁移项目
原系统的tru64 5.1a oracle9204 adtx,100多G的照片不需要转换，数据量不大.新系统是p570 aix5300-03, ora9204, cx500所涉及到的外挂系统有10左右,需要和多个单位协调工作.原先做调研的同事并没有好好调研，很多东西...
-
编辑 删除
Top-N SQL queries with Inline Views[akadia]
Top-N queriesSuppose you want to retrieve and sort information on the 4 most recently hired employees in a very efficient way. This can be achieved using an inline view combined with ORDER BY and ROWN...
-
编辑 删除
Speed up Queries using Function based Indexes[akadia]
When you use an application that often select rows based on an expression, then a function based index (an index on a function) can help to avoid full table scans. A function-based index is based on e...
-
编辑 删除
磁盘柜的常用操作(控制卡为hsz70)
1.磁盘柜的连接2.添加盘 (add disk disk-name scsi-location )3.删除盘 (delete disk-name)4.添加镜像(add mirrorset mirrorset-name disk-names)5.手工移掉镜像中的盘 (set mirrorset-name remove=disk-name)6.手工...
-
编辑 删除
2005年,这个id变成一个TEAM
2005年,这个id变成一个TEAM,提供网络,主机,数据库,存储,机房装修,中小型MIS开发等服务.欢迎留言.
-
编辑 删除
澳网男单决赛正在进行
而我却还要加班,看来只能晚上看录象了:(
-
编辑 删除
oracle中有没有针对字符串做位运算的方法 ？
4pal提出如下问题：数据库中有如下数据：字段1 字段21 0a0000001 c00000001 00000b001 000a00002 0000000d2 00000a003 0c0000003 0000b0003 000000g0......字段2是个N位字符串，有规律的，要么全部是0，要么只有一位...
