在A表有一个触发器，将数据触发到B表上。A表和B表是在不同的数据库上，触发器是通过DBLINK完成的.现在问题是有条记录A表有，B表没有？ A，B结构一样将这条记录拿出来，手工insert时A,B有了。触发器是create or replace trigger trgxxxxxafter insert or delete or update on Afor each rowbeginif inserting theninsert into B@dblinkend if;if deleting thendelete B@dblinkend if;if updating thenupdate B@dblinkend if;exceptionwhen others thendbms_output.put_

[php]#time sqlldr lmd/logmin control=ctl.ctl parfile=par.ctlSQL*Loader: Release 10.2.0.3.0 - Production on Tue Jul 15 17:43:12 2008Copyright (c) 1982, 2005, Oracle.All rights reserved.Load completed - logical record count 22077660.real54m29.618suser18m27.470ssys4m11.590s#cat ctl.ctlload datainfile "/apps/hunter/b1.txtaa"infile "/apps/hunter/b1.txtab"infile "/apps/hunter/b1.txtac"badfile "/apps/zwfha/b.bad"appendinto table t_logsource

:rose:

1．数据库的性能数据库的性能是一个企业或组织在选择数据库时首先要考虑的，尤其是一些大型的，关键的联机事务处理应用，对数据处理的速度要求很高，能否满足主要业务响应时间的需求十分重要。信息系统运行一段时间后，由于大量的数据插入、删除和修改操作，因此随着时间的推移必定会影响运行的效率。这就需要有专门的技术人员负责监视、分析系统的性能，以改进空间和处理效率。应用系统性能的好坏只有从运行的状况来检验，需要有专门的技术人员负责对运行状况进行统计分析，依靠工作实践及经验，根据实际应用的环境，不断改进数据库

---刚学习Mysql,还请高手多多指点 :rose:1.sql mode简介在Mysql中,sql mode可以用来解决以下问题(1).通过设置不同的sql mode,可以在不同严格程序进行数据校验.有效地保证了数据准确性.(2).通过设置sql mode为ANSI模式,来保证大多数SQL符合标准SQL的语法,这样在不同数据库之间迁移时,不需要对业务修改太多.在Mysql 5.0以下,查询默认的sql mode(sql mode参数)有:real_as_float,pipes_as_concat,ansi_quotes,gnore_space和ANSI。在这些模式下可以插入超过字段定义长度的数据，或是在字段中没有定义的元素数据(如,

mysql> desc mailflag;+-------+----------+------+-----+---------+-------+| Field | Type| Null | Key | Default | Extra |+-------+----------+------+-----+---------+-------+| id| int(10)| YES| MUL | NULL||| email | char(50) | YES|| NULL||| flag| int(5)| YES|| NULL||+-------+----------+------+-----+---------+-------+3 rows in set (0.00 sec)mysql> desc mailstat;+--------+----------+------+-----+---------+-----

SQL> select sys_context('userenv','host') from dual;SYS_CONTEXT('USERENV','HOST')--------------------------------------------------------------------------------sanfranSQL> host hostname;hpdata2oracle release:10.2.0.3.0

一朋友偶得四本 eygle大师的oracle书籍,不巧的是两两重复.现在想让我帮忙转手两本,分别是《循序渐进Oracle--数据库管理、优化与备份恢复》,《深入浅出Oracle--DBA入门、进阶与诊断案例》.如有需要的朋友可PM我，或是MSN给我MSN是 yangxy007@hotmail.com[ 本帖最后由 yxyup 于 2008-6-24 14:43 编辑 ]

每天一句,看能坚持多久如有错误,请多多赐教!:rose:#1I go to work by bus/by bicycle/on foot every day.我每天上班乘公交车/骑自行车/步行.

互联网数据中心解决方案关键字:白皮书局域网电子商务互联网的飞速发展带来了一场商业模式的革命。宽带接入技术的进步引发了对宽带多媒体信息的需求，同时越来越多的互联网用户、互联网内容供应商以及电子商务的快速增长，使网页的数量保持着爆炸性的增长速度。为了最大限度地受益于互联网科技的发展，无论是大型企业、“.com”公司，还是中小型企业都在寻找托管服务供应商（HSP）来托管他们的网站，以尽可能快速、低成本的实现电子商务。他们中的一部分甚至开始寻找应用服务供应商（ASP）来托管他们的应用系统，在保证

XX银行数据中心引言摘要：本文简单介绍EMC SRDF技术，重点阐述了银行如何利用该技术进行新旧数据中心搬迁、灾难备份的系统设计，详细介绍了如何按照系统设计要求逐步将旧数据中心安全地、迅速地搬迁到新的数据中心，并最终形成一套灾难备份系统。关键字：SRDF、数据迁移、灾难备份随着银行数据集中的深入开展，各种业务数据都进行集中处理。随着业务的不断拓展，我们可能需要对旧数据中心进行扩容，并进行新中心的建设。这时，我们就需要进行数据中心的搬迁工作。而实际上对于较大型的数据中心，经常要利用灾备技术来实现数据的

Sat Mar1 08:00:31 2008Streams CAPTURE C001 started with pid=27, OS id=13807Sat Mar1 08:00:32 2008LOGMINER: Parameters summary for session# = 1LOGMINER: Number of processes = 3, Transaction Chunk Size = 1LOGMINER: Memory Size = 10M, Checkpoint interval = 10MLOGMINER: session# = 1, builder process P001 started with pid=35 OS id=13787LOGMINER: session# = 1, reader process P000 started with pid=28 OS id=13785LOGMINER: session# = 1, preparer process P002 started with pid=36 OS

or misconfigured. This error can also be caused by malfunctioning hardware.0806062:20:45 [ERROR] Failed to open the relay log './myweb1-relay-bin.000002' (relay_log_pos 98)0806062:20:45 [ERROR] Could not find target log during relay log initialization0806062:20:45 [ERROR] Failed to initialize the master info structureor misconfigured. This error can also be caused by malfunctioning hardware.0806062:21:10 [ERROR] Failed to open the relay log './myweb1-relay-bin.000002' (relay

16:56:03up 304 days, 12:38,2 users,load average: 0.31, 0.23, 0.22133 processes: 132 sleeping, 1 running, 0 zombie, 0 stoppedCPU states:cpuusernicesystemirqsoftirqiowaitidletotal25.1%0.0%4.6%0.0%1.4%0.2%68.4%cpu0022.7%0.0%2.9%0.0%5.9%0.9%67.3%cpu0123.7%0.0%3.9%0.0%0.0%0.0%72.2%cpu0224.5%0.0%5.8%0.0%0.0%0.0%

mysql刚启动时,只有以下几个进程[root@mydb2 root]# ps -ef | grep mysqldroot258710 Apr18 ?00:00:00 /bin/sh /usr/local/mysql/bin/safe_mysqldmysql373925870 May01 ?00:17:06 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql --pid-file=/usr/local/mysql/data/mydb2.pid --skip-external-lockingmysql374037390 May01 ?00:00:04 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/lo

[php]0805018:15:45 [ERROR] Got error 134 when reading table './jobs/jobs'0805018:16:03 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect key file for table './jobs/jobs.MYI'; try to repair it0805018:16:03 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect key file for table './jobs/jobs.MYI'; try to repair it0805018:16:19 [ERROR] Got error 134 when reading table './jobs/jobs'0805018:16:32 [ERROR] Got error 134 when reading table './jobs/jobs'0805018:16:36 [ERROR] Got error

mysql> showprocesslist ;+---------+----------------------+--------------------+------+---------+------+-------+-------------------+| Id| User| Host| db| Command | Time | State | Info|+---------+----------------------+--------------------+------+---------+------+-------+-------------------+| 4233559 | root| localhost| NULL | Query|0 | NULL| showprocesslist || 4233850 | unauthenticated user

Number of processes running now: 0080421 01:53:37mysqld restarted0804211:53:37InnoDB: Started; log sequence number 0 436650804211:53:37 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=mydb2-relay-bin' to avoid this problem.0804211:53:37 [ERROR] Failed to open the relay log './myweb1-relay-bin.000002' (relay_log_pos 98)0804211:53:37 [ERROR]