yxyup's footprint http://space.itpub.net/?uid-7364032 投入多少，收获多少；投入多深，领悟多深。太阳底下没有新鲜事，排列组合就是创新。每天多做一点点，就是进步的开始，每天进步一点点，就是成功的开始，每天创新一点点，就是领先的开始。 Copyright(C) yxyup's footprint SupeSite/X-Space Wed, 09 Jul 2008 18:23:33 GMT 数据库应用管理 http://space.itpub.net/?uid-7364032-action-viewspace-itemid-371982 1．数据库的性能
数据库的性能是一个企业或组织在选择数据库时首先要考虑的，尤其是一些大型的，关键的联机事务处理应用，对数...]]> blog yxyup Fri, 04 Jul 2008 18:24:04 GMT [原创] sql mode与 enum 类型 http://space.itpub.net/?uid-7364032-action-viewspace-itemid-368907  
1.sql mode简介
 
在Mysql中,sql mode可以用来解决以下问题
(1).通过设置不同的sql mode,可以在不同严格程序进行数据...]]> blog yxyup Wed, 02 Jul 2008 16:00:35 GMT WHERE TO_NUMBER(SUBSTR()) 我的是可以的 http://space.itpub.net/?uid-7364032-action-viewspace-itemid-368774 HUNTER@devjob>CREATE TABLE T_PART (ID NUMBER, CREATE_DATE DATE)
  2  PARTITION BY RANGE (CREATE_DATE)
  3  (
  4  PARTITION P2004 VALUES LESS THAN (TO_DATE('2005-1-1...]]> blog yxyup Tue, 01 Jul 2008 16:05:44 GMT Input/output error [ linux ] http://space.itpub.net/?uid-7364032-action-viewspace-itemid-366481 [root@ad /var]# top
bash: top: command not found
[root@ad /var]# ls
ls: cache: Input/output error
ls: db: Input/output error
ls: local: Input/output error
ls: preserve: Input/output error
ls: state: Input/output error
ls: tmp...]]> blog yxyup Mon, 30 Jun 2008 22:42:27 GMT ORA-16055: FAL request rejected http://space.itpub.net/?uid-7364032-action-viewspace-itemid-366440 Mon Jun 30 14:47:11 2008
ARC1: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (19502)
ARC1: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
Mon Jun 30 14:47:11 2008
Errors in file /u01/oracle/admin/hpjob/bdump/hpj...]]> blog yxyup Mon, 30 Jun 2008 15:03:30 GMT N层结构与中间件(zt) http://space.itpub.net/?uid-7364032-action-viewspace-itemid-366238
　　N层模型

　　一个系统是否能获得成功,最初常常依赖于对工具及管理方法的选择。有些方案提供者并不真正...]]> blog yxyup Sat, 28 Jun 2008 23:19:58 GMT 人生 vs 地图 http://space.itpub.net/?uid-7364032-action-viewspace-itemid-366093 我们出生时，并不是带着地图来到世界的。为在人生旅途上顺利行进，我们需要绘制地图，为此显然要付出努力。我们的努力越大，对事实的认识越清楚，地图的准确性就越高。

]]> blog yxyup Fri, 27 Jun 2008 10:30:40 GMT impdp 将数据导入数据库中不存的用户里 http://space.itpub.net/?uid-7364032-action-viewspace-itemid-366021 没有开场白,直接看测试吧


SQL>  create or replace directory dir1 as '/backup/test/';

Directory created.


SQL> grant read,write on directory dir1 to yxyup;

Grant suc...]]> blog yxyup Thu, 26 Jun 2008 17:00:05 GMT ORA-29257: host sanfran unknown [BUG] http://space.itpub.net/?uid-7364032-action-viewspace-itemid-366018 真的想骂人了

昨天下午也是这样时间,遇到了BUG,

今天又来了一个BUG,这测试没法做了,记一下吧,别的也没招


SQL> create directory dir1 as '/home/oracle/bak';
create directory dir1 as '/home/oracle/bak'
*
ERROR at line 1...]]> blog yxyup Thu, 26 Jun 2008 15:40:04 GMT UDE-00008: operation generated ORACLE error 31626 http://space.itpub.net/?uid-7364032-action-viewspace-itemid-364849 哎!人不顺了,喝口冷水都塞牙缝.

下午做了一个很简单的测试就又出来了一个BUG,记录一下吧,

SQL> show user ;
USER is "SYS"
SQL> create directory dir1 as '/home/oracle/bak';

Directory created.

SQL> grant write ...]]> blog yxyup Wed, 25 Jun 2008 17:36:54 GMT Realsync平战结合建设异地数据容灾系统及查询平台 http://space.itpub.net/?uid-7364032-action-viewspace-itemid-353105 世贸大厦的倒塌使人们清楚地看到容灾是何等重要，在至今还未清理完的废墟中深埋着800 多家公司和机构的重要数据。这其中最为世人所关注的当属金融界巨头Morgan Stanley 公司，这家执金融业之牛耳的公司在世贸大厦租有25层，惨剧发生时有2000 多名员工正在楼内...]]> blog yxyup Fri, 20 Jun 2008 22:00:23 GMT 不同编程语言和操作系统对应的薪水 http://space.itpub.net/?uid-7364032-action-viewspace-itemid-353102  

                    &...]]> blog yxyup Fri, 20 Jun 2008 21:23:49 GMT 偶得各种文件打开方式 记之 http://space.itpub.net/?uid-7364032-action-viewspace-itemid-348199 PDG格式需安装以下软件阅读 
http://www.softii.com/downinfo/41718.html

PDF格式需安装以下软件阅读 
http://www.softii.com...]]> blog yxyup Sun, 15 Jun 2008 18:21:19 GMT 互联网数据中心解决方案 http://space.itpub.net/?uid-7364032-action-viewspace-itemid-346824 互联网数据中心解决方案 blog yxyup Sat, 14 Jun 2008 20:53:25 GMT 个人格言记 http://space.itpub.net/?uid-7364032-action-viewspace-itemid-332313 1. 才能是历炼出来的,经验是积累出来的

2. 权力啊,如果得不到控制和监督实在太可怕了

3. 何为圣君? 刘伯温曰：“小事多问臣下，大事自己三思而定，乃圣君也”

4. 宽容是做人的品德,严厉是做事的准绳

 

 

]]> blog yxyup Wed, 04 Jun 2008 20:20:59 GMT ORA-12162: TNS:net service name is incorrectly specified http://space.itpub.net/?uid-7364032-action-viewspace-itemid-324413 oracle@hpdb2:/home/oracle #sqlplus /nolog

SQL*Plus: Release 10.2.0.3.0 - Production on Fri May 30 10:20:33 2008

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.

SQL&g...]]> blog yxyup Fri, 30 May 2008 10:58:43 GMT 工作整整四年了 http://space.itpub.net/?uid-7364032-action-viewspace-itemid-324411 才能是历炼出来的,经验是积累出来的

有机会,有环境,就有一切.

努力吧,兄弟!

]]> blog yxyup Fri, 30 May 2008 10:55:08 GMT oracle工作机制(转) http://space.itpub.net/?uid-7364032-action-viewspace-itemid-310310 我们从一个用户请求开始讲,ORACLE的完整的工作机制是怎样的,首先一个用户进程发出一个连接请求,如果使用的是主机命名或者是本地服务命中的主机名使用的是机器名(非IP地址)，那么这个请求都会通过DNS服务器或HOST文件的服务名解析然后传送到ORACLE监听进程,监听进程接收...]]> blog yxyup Mon, 26 May 2008 11:27:45 GMT ERROR 1193: Unknown system variable 'log_slow_queries' http://space.itpub.net/?uid-7364032-action-viewspace-itemid-268147
[25 Oct 2007 12:02] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can acce...]]>
								blog
								yxyup
								Wed, 14 May 2008 18:49:44 GMT
							
							
								个人 vs 企业
								http://space.itpub.net/?uid-7364032-action-viewspace-itemid-263187
								January


个人,
只有找到了适合自己的职位,才能把工作做好

企业,
人才只要放对了位置,就能成为好员工


February


个人,
没有功老还有苦劳,汗水换红包,天经地义


企业,
天下没有无缘无故的奖金


March

...]]>
								blog
								yxyup
								Thu, 08 May 2008 12:59:22 GMT
							
							
								权力啊,如果得不到控制和监督实在太可怕了
								http://space.itpub.net/?uid-7364032-action-viewspace-itemid-256928
								 


权力啊,如果得不到控制和监督实在太可怕了
]]>
								blog
								yxyup
								Tue, 29 Apr 2008 21:54:16 GMT
							
							
								如何将Access 数据导到 Mysql的数据库 ?
								http://space.itpub.net/?uid-7364032-action-viewspace-itemid-254313
								如何将Access 数据导到 Mysql的数据库


大致步骤如下


1.在access导出数据,导出格式为text的,数据如下,导出方法见图

0,"yxyup"
1,"yxyup1"
2,"yxyup2"

2.binary方式ftp到msyql服务器上

3. 导入mysql

mysql> create...]]>
								blog
								yxyup
								Fri, 25 Apr 2008 17:32:14 GMT
							
							
								mysql如何导出一个表的数据？
								http://space.itpub.net/?uid-7364032-action-viewspace-itemid-253303
								刚才在pub上看到一个朋友问 ,如下


mysql如何导出一个表的数据？


...]]>
								blog
								yxyup
								Fri, 25 Apr 2008 16:36:56 GMT
							
							
								简单的FTP Donwload 脚本
								http://space.itpub.net/?uid-7364032-action-viewspace-itemid-245931
								

有一个备份完成的备份集，由于磁盘空间不足，每天早上都要把这些备份集下载了一台WINDOWS 机器上做备份、同时腾出空间给明天备份集用。


 


1.ftp_auto.bat


ftp -n -s:"D:\scripts\downl...]]>
								blog
								yxyup
								Sun, 20 Apr 2008 11:57:35 GMT
							
							
								Named vs Anonymous Pl/sql Blocks testing
								http://space.itpub.net/?uid-7364032-action-viewspace-itemid-245930
								begin
for i in 1..1000000
loop
begin select object_id into :a from test1 where rownum<2; end;
end loop;
end;

call     count       cpu    elapsed  &n...]]>
								blog
								yxyup
								Sun, 20 Apr 2008 11:56:30 GMT
							
							
								ORA - 1461 encountered when generating server alert
								http://space.itpub.net/?uid-7364032-action-viewspace-itemid-245929
								ORA - 1461 encountered when generating server alert SMG-3500 

METALINK中，说是Oracle的一个bug。 METALINK, said Oracle is a bug. 

造成这个问题的原因SMON进程在更新SMON_SCN_TIME表时，引发了ORA-1461错误。 The reason for this update proce...]]>
								blog
								yxyup
								Sun, 20 Apr 2008 11:55:17 GMT
							
							
								ORA-27123: unable to attach to shared memory segme
								http://space.itpub.net/?uid-7364032-action-viewspace-itemid-245928
								hunter@HP:/home/hunter #exp userid=system/yxyup wner=hunter file='/ehirearch/hunter/exp_test/hunter.dmp' log='/ehirearch/hunter/exp_test/hunter.log' direct=y  recordlength=65535 feedback=10000 stati...]]>
								blog
								yxyup
								Sun, 20 Apr 2008 11:53:28 GMT
							
							
								Oracle AWR Top SQL section
								http://space.itpub.net/?uid-7364032-action-viewspace-itemid-245927
								

Top SQL


Th...]]>
								blog
								yxyup
								Sun, 20 Apr 2008 11:51:30 GMT
							
							
								Oracle Created (Default) Database Users
								http://space.itpub.net/?uid-7364032-action-viewspace-itemid-245925
								

Overview 



During database creation, Oracle creates several default database users or schemas. This article attempts to provide some insight and explain each of these default...]]>
								blog
								yxyup
								Sun, 20 Apr 2008 11:48:59 GMT
							
							
								Oracle Partitioned Tables
								http://space.itpub.net/?uid-7364032-action-viewspace-itemid-245924
Oracle Partitioned Tables
Version 10.2 blog yxyup Sun, 20 Apr 2008 11:47:42 GMT