yxyup's footprint http://space.itpub.net/7364032 投入多少，收获多少；投入多深，领悟多深。太阳底下没有新鲜事，排列组合就是创新。每天多做一点点，就是进步的开始，每天进步一点点，就是成功的开始，每天创新一点点，就是领先的开始。 Copyright(C) yxyup's footprint SupeSite/X-Space Wed, 08 Oct 2008 11:00:26 GMT [原创] HP小机更换cell板 http://space.itpub.net/7364032/viewspace-468215
经和HP工程师沟通决定今天晚上更换坏掉的cell板.更换步骤过下,大致记录以下
1.将应用和数据库都切到备机(MC/SG环境)
2.更换cell板
3.更新cell板的firmware版本. blog yxyup Tue, 07 Oct 2008 16:00:35 GMT [原创] 手把手安装设置ASM http://space.itpub.net/7364032/viewspace-468209 (包的下载地址 http://www.oracle.com/technology/software/tech/linux/asmlib/rhel5.html)

[root@dbatest1 asm]# ll
total 180
-rw-r--r-- 1 root root 125743 Aug 31 18:15 oracleasm-2.6.18-8.el5-2.0.4-1.el5.i686.rpm
-rw-r--r--...]]> blog yxyup Tue, 07 Oct 2008 15:03:37 GMT 上海到处是流氓 http://space.itpub.net/7364032/viewspace-462988 上海到处是流氓

上海，上海，呵呵
远看上海像天堂...]]> blog yxyup Thu, 25 Sep 2008 11:20:01 GMT [原创] 如何抽取Emial中有两个@的无法地址 http://space.itpub.net/7364032/viewspace-462909 环境是mysql哦

mysql> select * from t_test_1;
+--------------+
| mail         |
+--------------+
| a@16@163.com |
| a@163....]]> blog yxyup Wed, 24 Sep 2008 16:38:55 GMT [原创] Oracle数据库资源管理 http://space.itpub.net/7364032/viewspace-448453 1.创建一个挂起区域：

SQL> exec dbms_resource_manager.create_pending_area;

PL/SQL procedure successfully completed.

2.创建资源规划

SQL> exec dbms_resource_manager.create_plan(plan =>'test_plan',COMMENT=>'th...]]> blog yxyup Mon, 15 Sep 2008 21:02:59 GMT [原创] expdp 问题快解 http://space.itpub.net/7364032/viewspace-442939 1.问题1

ORA-04063: package body "SYS.DBMS_LOGREP_UTIL" has errors

[oracle@test1 exp]$ exp userid=yxyup/abc123 tables=t1 file=t1.dmp log=t1.log

Export: Release 10.2.0.3.0 - Production on Tue Sep 9 19:00:33 2008

Copyrig...]]> blog yxyup Wed, 10 Sep 2008 18:33:05 GMT [原创] ORA-22868 快速解决 http://space.itpub.net/7364032/viewspace-442424 1.问题现象

SQL> drop tablespace TS_LOB including contents and datafiles ;
drop tablespace TS_LOB including contents and datafiles
*
ERROR at line 1:
ORA-22868: table with LOBs contains segments in different tablespaces

 blog yxyup Mon, 08 Sep 2008 20:45:30 GMT 摘抄biti大师一句话 http://space.itpub.net/7364032/viewspace-438939 跳出 oracle领域 到 数据库领域，跳出数据库领域 到 数据领域，跳出 数据领域 到整体的信息系统架构规划

 

]]> blog yxyup Fri, 29 Aug 2008 15:36:49 GMT [原创] mysql表字段多少限定 http://space.itpub.net/7364032/viewspace-438829 我们知道在Oracle中一个表上的字段最多只能有1000个,那么在mysql,一个表上能有多少个字段呢?
今天在PUB上看到一个贴子(http://www.itpub.net/thread-1045069-1-1.html)于是查了下文档,没有发现相关说明...]]> blog yxyup Fri, 29 Aug 2008 10:39:53 GMT [原创] expdp 杂记一箩筐 http://space.itpub.net/7364032/viewspace-438683 ---全库expdp
oracle@dbatest1:/data01 #expdp system/password full=y parallel=4 directory=dumpdir dumpfile=fulldb%U.dump filesize=50m

---限定条件导出
o...]]> blog yxyup Thu, 28 Aug 2008 16:52:33 GMT [原创] expdp在限定文件大小时,注意dump文件名字变化 http://space.itpub.net/7364032/viewspace-438681 使用expdp限定文件大小,使用filesize
注意一点在限定文件大小时,注意dump文件名字变化.

测试如下

SYS@dbatest>create directory dumpdir as '/data01' ;

Directory created.

 
1.用RMAN启动到nomount
RMAN> st...]]> blog yxyup Fri, 22 Aug 2008 17:05:23 GMT [原创] 一个朋友的错误EXP记录 http://space.itpub.net/7364032/viewspace-433011 朋友是一位ORACLE初学者，可以说刚刚接触ORACLE，昨天晚上试着学习EXP，结果出现了以下几种不同的错误，总结了一下，供初学者参考
 
1.C:\>exp system/abc123 wner=(test01) file='d:\orabak\exp060912.dmp';
Export: R...]]> blog yxyup Fri, 22 Aug 2008 17:03:07 GMT [原创] 一个朋友的错误EXP记录 http://space.itpub.net/7364032/viewspace-433012 朋友是一位ORACLE初学者，可以说刚刚接触ORACLE，昨天晚上试着学习EXP，结果出现了以下几种不同的错误，总结了一下，供初学者参考
 
1.C:\>exp system/abc123 wner=(test01) file='d:\orabak\exp060912.dmp';
Export: R...]]> blog yxyup Fri, 22 Aug 2008 17:03:07 GMT [原创] move table 的注意事项 http://space.itpub.net/7364032/viewspace-433010 move table 的注意事项
 
1.table上的index要rebuild
SQL> r
  1  select index_name,table_name,column_name from user_ind_columns
  2* where table_name='T'
INDEX_NAME &nb...]]> blog yxyup Fri, 22 Aug 2008 17:02:04 GMT [原创] 小议rank(),dense_rank(),row_number()使用与区别 http://space.itpub.net/7364032/viewspace-433009
SQL> desc t * from t
 Name                             ...]]> blog yxyup Fri, 22 Aug 2008 17:01:05 GMT [原创] How to Quiesce a Database http://space.itpub.net/7364032/viewspace-433008

SQL> alter system quiesce restricted;
alter system quiesce restricted
*
ERROR at line 1:
ORA-25507: resource manager has not been continuously on


SQL> alter system quiesce restricted;
alter system quiesce rest...]]> blog yxyup Fri, 22 Aug 2008 16:59:59 GMT 抓紧攒钱,迎接拍卖 http://space.itpub.net/7364032/viewspace-433007 几次拍卖都让别人在最后几秒得手.心中极其不爽

为了攒钱,只能将从以前的测试案例中一篇一篇贴过来了

]]> blog yxyup Fri, 22 Aug 2008 16:56:32 GMT [原创] 当表空间不足时,Oracle是这样管理Recyclebin http://space.itpub.net/7364032/viewspace-432974 我们知道,在Oracle 10g中,drop table如果没有加 purge选项.实际数据并没有删除,因而没有释放表空间.
那么当被删除的对象占用了所有空间时，会发生什么? 相信看完以下测试,一切皆会明白

YXYUP@dbatest>select ...]]> blog yxyup Fri, 22 Aug 2008 13:15:07 GMT [原创] FlashBack表后, 如何处理有依赖关系的对象 http://space.itpub.net/7364032/viewspace-431718 .当我们意外的drop掉一张表时,在Oracle 10g中可以很轻松的flashback回来,只要在开启recyclebin功能的情况下.
那么如果被drop的表上有其他依赖关系的对象(比如存储过程,触发器,索引等),这些对象会出现怎样的情况,同时我们flashback表后,这些对象又当如何处理?
针对...]]> blog yxyup Thu, 21 Aug 2008 17:13:34 GMT [原创] 在Radhat 5 上安装Oracle 10g http://space.itpub.net/7364032/viewspace-426913 第一次在Redhat 5上安装 oracle 10g ,遇到了几个小问题,记录一下.同时也分享一下

环境:
1.操作系统
[root@dbatest1 ~]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 5 (Tikanga)
[root@dbatest1 ~]# uname -a
Linux dba...]]> blog yxyup Thu, 14 Aug 2008 13:03:09 GMT Oracle runInstaller 's Usage http://space.itpub.net/7364032/viewspace-426910 Usage:
runInstaller  [-options] [(<CommandLineVariable=Value>)*]

Where options include:
  -clusterware oracle.crs,<crs version> 
        Version of Cluster ready servic...]]> blog yxyup Thu, 14 Aug 2008 12:57:49 GMT ORA-00600:[kghstack_alloc], [koklsotyopn alloc], http://space.itpub.net/7364032/viewspace-425562 Subject: ORA-600 [kghstack_alloc]   blog yxyup Tue, 12 Aug 2008 17:04:53 GMT dbms_lob.write 测试 http://space.itpub.net/7364032/viewspace-425556 HUNTER@test>create table t_lob(id number,name clob);

Table created.

HUNTER@test>desc t_lob;
 Name       &n...]]> blog yxyup Tue, 12 Aug 2008 16:47:39 GMT [原创] 在Linux下给主机添加新的硬盘空间 http://space.itpub.net/7364032/viewspace-422877 1.划分新的分区.(以/dev/sdb硬盘为例)

[root@dbatest1 ~]# fdisk /dev/sdb

The number of cylinders for this disk is set to 4427.
There is nothing wrong with that, but this is larger than 1024,
and could in certain setups cause probl...]]> blog yxyup Sun, 10 Aug 2008 11:29:11 GMT Shrinks a LOB segment [原创] http://space.itpub.net/7364032/viewspace-421425 在oracle10G中，如果表的内容被删除后想回收使用空间和降低HWM,我们可以通过shrink的方式在线完成.
那么如果表中有LOB字段时,也可以做吗?答案是肯定的,当然可以.
我们可以通过两种方法来做.一种是可以通过普通的alter table <table_name > shrink space ca...]]> blog yxyup Thu, 07 Aug 2008 13:59:29 GMT Instance Service Registration to Listeners http://space.itpub.net/7364032/viewspace-421321
Subject: Instance Service Registration to Listeners
  blog yxyup Wed, 06 Aug 2008 17:50:01 GMT Mysql Explain 详解 [原创] http://space.itpub.net/7364032/viewspace-421320 一.语法

explain < table_name >

例如: explain select * from t3 where id=3952602;

二.explain输出解释

+----+-------------+-------+-------+-------------------+---------+---------+-------+------+-------+
| id | se...]]> blog yxyup Wed, 06 Aug 2008 17:45:03 GMT