lorikyo的个人空间 http://space.itpub.net/92530 Copyright(C) lorikyo的个人空间 SupeSite/X-Space Mon, 08 Sep 2008 02:59:22 GMT Using DBMS_METADATA To Get The DDL For Objects http://space.itpub.net/92530/viewspace-438711


The purpose of this document is illustrate the usage of dbms_metadata to generate the DDL for objects.



SCOPE & APPLICATION



The DBMS_METADATA package is a powerful tool for obtaining the comple...]]> blog lorikyo Thu, 28 Aug 2008 22:56:17 GMT Oracle 数据库 系统使用经验六则 http://space.itpub.net/92530/viewspace-438710

Oracle 数据库 系统使用经验六则


---- 1.having 子句的用法


---- having 子句对 group by 子句所确定的行组进行控制 ,having 子句条件中只允许涉及常量 , 聚组函数或 grou...]]> blog lorikyo Thu, 28 Aug 2008 22:55:40 GMT Oracle 数据库管理脚本命名规范 http://space.itpub.net/92530/viewspace-438709 Oracle 数据库管理脚本命名规范


Oracle 中的数据字典是数据库中的非常重要的一部分，提供了相关数据库的信息，它是所有 Oracle 用户（从应用的最终用户、应用的设计开发者到数据库管理员）的非常重要的信息来源。数据字典的创建，是在 Oracle 数据库创建...]]> blog lorikyo Thu, 28 Aug 2008 22:54:49 GMT Oracle 9i轻松取得建表和索引的DDL语句 http://space.itpub.net/92530/viewspace-438708 Oracle 9i轻松取得建表和索引的DDL语句


我们都知道在9i之前，要想获得建表和索引的语句是一件很麻烦的事。我们通常的做法都是通过export with


rows=no来得到，但它的输出因为格式的问题并不能直接拿来用。而另一种方法就是写复杂的脚本来查询...]]> blog lorikyo Thu, 28 Aug 2008 22:54:02 GMT solaris下使用lsof恢复删除的文件[转帖] http://space.itpub.net/92530/viewspace-434866 使用lsof删除恢复的文件


模拟 blog lorikyo Wed, 27 Aug 2008 09:29:06 GMT 重建OEM过程以及遇到的一些问题 http://space.itpub.net/92530/viewspace-402627 OEM打不开

...]]> blog lorikyo Thu, 17 Jul 2008 10:50:31 GMT :How to Recreate the Database Control Repository(ORA10G_R2)[ZT] http://space.itpub.net/92530/viewspace-401214 The following is about recreate the Database Control Repository of ORA10g_R2:

This article provides steps-by-step details on how to create, drop and recreate the Database Control Repository and configuration files in a 10g R2 database.

...]]> blog lorikyo Mon, 14 Jul 2008 17:32:09 GMT reconfig dbconsole can't start http://space.itpub.net/92530/viewspace-401213 The summary of Troubleshooting the problem about when recreate or reconfigure the dbconsole,the dbconsole can't be started

Problem description
When droping the dbconsole, prompt some folders can't remove
$ emca -deconfig dbcontrol db -...]]> blog lorikyo Mon, 14 Jul 2008 17:31:00 GMT about job and MATERIALIZED VIEW issue http://space.itpub.net/92530/viewspace-374374 ORA-12012: error on auto execute of job 5717
ORA-12537: TNS:connection closed~
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2254
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2460
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2429
ORA-06512: at line 1...]]> blog lorikyo Mon, 07 Jul 2008 16:39:38 GMT LISTENER WAS HANG AND WAS NOT ALLOWING NEW CONNECTIONS http://space.itpub.net/92530/viewspace-369013 This issue occurred last friday as well. Listener was hung and was not allowing connections. When you attempt to connect
via the listener or check the listener status it would hang the connection and
not respond. I identified the listener an...]]> blog lorikyo Thu, 03 Jul 2008 14:31:02 GMT AGENT IS UNREACHABLE http://space.itpub.net/92530/viewspace-369012 === Agent Configuration Problem Description ===
Target Name=<https://kpdbps07.jewelry.acn:1159/em/redirect?encoded=FALSE&targetType=host&pageType=TARGET_HOMEPAGE&targetName=kpdbps03.j
ewelry.acn>kpdbps03.jewelry.acn
Target...]]> blog lorikyo Thu, 03 Jul 2008 14:30:03 GMT 配置SQLNET.ORA文件 http://space.itpub.net/92530/viewspace-368777 blog lorikyo Tue, 01 Jul 2008 16:32:02 GMT 【征文】我的Oracle数据库学习之路 http://space.itpub.net/92530/viewspace-366460 说句不怕大家笑话的话。我虽然是计算机专业毕业，但是刚毕业那会还有专门维护数据库的这种职业。实际知道的数据库就学习《数据库原理》的时候。在书上看到过sqlserver，还有ACCESS。我那时认为一个计算机系毕业生的最高...]]> blog lorikyo Mon, 30 Jun 2008 17:40:40 GMT regarding step for apply patch "CPU2008" http://space.itpub.net/92530/viewspace-332394         blog lorikyo Thu, 05 Jun 2008 11:44:46 GMT recreate temporary tablespace on datagurd http://space.itpub.net/92530/viewspace-269165                         recreate temporary tablespace on datagurd
the primary database temporary tablespace is at 32GB,so i feel it...]]> blog lorikyo Thu, 15 May 2008 10:10:40 GMT Apply Patch (6864068 and 6602742)Installation Procedures http://space.itpub.net/92530/viewspace-263234   blog lorikyo Thu, 08 May 2008 13:48:51 GMT ORA-03113错误分析{zt} http://space.itpub.net/92530/viewspace-263210


ORA-03113错误分析

版本历史
2003-5-22  v0.1  Created by Fenng  (Fenng@itpub.net)
版权声明...]]> blog lorikyo Thu, 08 May 2008 13:47:20 GMT 利用alter_log确定scn号的时间进行flashback操作 http://space.itpub.net/92530/viewspace-246139 这个是 blog lorikyo Mon, 21 Apr 2008 10:19:50 GMT 找工作 胡扯下 http://space.itpub.net/92530/viewspace-235598
的要求 不是很高好象适合自己，但是，有一点要求英语好，我郁闷了。我的英语烂的很，读书的时候别

人都说：“中国人学什么英语咯！”现在好了，我发...]]> blog lorikyo Sun, 13 Apr 2008 13:58:29 GMT install mysql for linux http://space.itpub.net/92530/viewspace-230925 在linux环境中安装mysql需要

blog lorikyo Sun, 06 Apr 2008 05:47:56 GMT 难以忽略的真相 http://space.itpub.net/92530/viewspace-217992 from v$sysstat cur,v$sysstat con,v$sysstat phy
where cur.name='db block gets'
and   con.name='consistent gets'
and   phy.name='physical reads';
~

blog lorikyo Wed, 26 Mar 2008 14:35:23 GMT Installing SAP® R/3® http://space.itpub.net/92530/viewspace-207298