ITPub博客

一个数据库非正常关机，再次启动数据库时报错：ORA-12709:Error while loading create database character set 首先排除了环境变量的问题，最终发现是以下目录文件损坏：$ORACLE_HOME/ocommon/nls/admin/data从备份...

http://www.chinaitpower.com/A/2004-07-04/85503.html--------------------仅转一段----------------------------1 前言　 　　众所周知，MD5是目前应用最多的密码保护方法，该编码传说为不可逆加密编码＜也就是说...

关键字: 物化视图, migration,materialized views,快照,prebuilt table对于要求停机时间很短的迁移,可以一试.a) create empty tables in new database....b) put constraints etc on them (deferrable please, impor...

安装oracle,运行rootpre.sh时报以下错误：Configuring Asynchronous I/O... Asynchronous I/O is already defined /var/ha/soc/hagsdsocket./cdrom/rootpre.sh[338]: /usr/lpp/ssp/bin/spget_syspar: not found: No ...

This tip comes from Anirban Das, a Senior IA from Vernon Hills, IL. We have improved the SQL statement in some points, so WHERE clauses will be correctly executed.In SQL*Plus, it is often difficult to read the results of a SELECT *FROM 'table' statement since the output could wrap across multiple lines. For example, the normal output of SELECT * FROM 'dba_users' would be :USERNAME USER_ID PASSWORD------------------------------ ---------- ---------ACCOUNT_STATUS

·  企业版——行业领先的可伸缩性和可靠性（集群的、单一系统）、事务处理、决策支持及内容管理。  ·  标准版——为不需要企业版选项的中小企业或部门提供了低成本的选择。 &n...

来自网友1应用开发　　　　　1.1　应用程序接口和预编译器　　　　1.1.1　　提供ODBC FOR LINUX版本　　　1.1.2　　OCI客户端版本　　　1.1.3　　OCI启动关闭数据库直接在调用OCI的应用程序中就可以关闭和开启数据库...

p570 oracle9204 rboSQL> set autotrace traceonly;select a.czrkrybh,a.czrkxm,b.czrkpcs from t_person a ,t_huji bwhere a.czrkryid=b.czrkryid and a.czrkgmsfhm='510214197501131748';Execution Plan---------------------------------------------------------- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=48337 Card=274445 By tes=20583375) 1 0 HASH JOIN (Cost=48337 Card=274445 Bytes=20583375) 2 1 TABLE ACCESS (BY INDEX ROWID) OF 'T_PERSON' (Cost=2 Card =272416 Bytes=1

在做几个数据库的statspack时，某个数据库总是报错： ORA-00001: unique constraint (PERFSTAT.STATS$SQL_SUMMARY_PK) violatedORA-06512: at "PERFSTAT.STATSPACK", line 1361ORA-06512: at "PERFSTAT.STATSPACK", ...

One option for secure communication between the Net8 client and server is to tunnel the communication inside the Secure Shell protocol. Conceptually, it works like this. First, you install an SSH clie...

ora-29723:DML PROCESS STRUCTURE EXCEEDS PERMITTED VALUES解决方法: 加大ops参数， lm_procs .[127 --->  200]

During a migration it may be important, that nobody can connect to the database. You may have two possibilities to achieve thisOn Table Level using LOCK TABLEOn Database Level using RESTRICTED SESSION...

http://www.oracle.com/technology/deploy/security/critical-patch-updates/cpuoct2006.html http://www.oracle.com/technology/global/cn/deploy/security/alerts.htm

在广东，国际主流厂家设备和技术的引进，国内厂商设备的广泛使用，非开挖产业已在城市基.础设施的建设取得了令人印象深刻的成果，产业本身也获得了快速的发展，各级公司由2002年的. 50 家扩展到2004 年140 家，这期...

p570 oracle9204 rboSQL> set autotrace traceonly;select a.czrkrybh,a.czrkxm,b.czrkpcs from t_person a ,t_huji bwhere a.czrkryid=b.czrkryid and a.czrkgmsfhm='510214197501131748';Execution Plan----------...

One of the most powerful SQL features is often unknown - CASE Expressions in SQL Queries. An expression is a combination of one or more values, operators, and SQL functions that evaluate to a value. A...

ProblemIf you try to truncate a table on a remote database, you will get the following error:ORA-02021: DDL operations are not allowed on a remote database.You have a database link to the re...

This tip is from the Oracle Magazine, it shows the usage of the DBMS_OBFUSCATION_TOOLKIT. The DBMS_OBFUSCATION_TOOLKIT is the DES encryption package. This package shipped with Oracle8i Release 2 and l...

Internet portals are currently implementing document management systems as part of the offered services on their portal. We have been asked to review Oracle Internet File System (iFS) in order to enab...

昨天遇到一个问题，监听进程会自动消失. es4100 4.0d oracle734 双机热备系统一级没有任何日志,客户端和服务器端的oracle的一个版本.重新配了双机服务.并写了一个检测监听进程并自动重起的shell脚本cd 目录rm -f lsn...