eygle.com   eygle.com
eygle.com  
 
留言簿 - Powered by eYgLe.Com
eygle.com 我要留言
唯书有色,艳于西子 唯文有华,秀于百卉
昵称
内容 页: 1 - << < 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 > >> - 312
# 43536
anycall2010
To: eygle
　　看了您＜深入浅出＞有一个基于ＳＣＮ恢复数据，如果在进行基于ＳＣＮ进行不完全恢复的时候，如果某些数据是ＯＦＦＬＩＮＥ的，那么进行完ＳＣＮ恢复后，对这些ＯＦＦＬＩＮＥ的数据会不会有影响？
From: anycall2010
2007.09.05 00:31
To: anycall2010
　　如果做完全恢复没问题；如果是不完全恢复，resetlogs打开就有问题了。
From: eygle
2007.09.06 09:49
版主选项: 回复 编辑
# 43535
Chi


来自: Mexico

To: Eygle
　　I recently created a MV on Test machine (AIX 5.3L, Oracle 10g R2).The MV was created based on outer join of 2 tables.None of the column elements of the 2 tables has any constraint relationship with those of any other table in the schema.I also have MV log on both master tables and index of the MV and the refresh is set up by NEXT schedule daily. However I noticed that every time the MV was refresh, it generated a message in the alert log as "Join columns of outer join with table TTPPPC235201 have no uniqueness constraints".I search many places on line, including the metalink, and could not find any thing about this.I do not think this is an error.What do You think?All the tables of the schema does no have any elements constraint.

PS.How is felling being a father?lots diapers!!
From: Chi
2007.09.05 00:21
版主选项: 回复 编辑
# 43533
Jennny
To: All
　　猎头招聘：—美500强Global R&D Center 招数据库开发, base 上海
美国500强公司，下设四大块业务领域，在上海设立了全球研发中心，现在正在招数据库开发、管理方面的人才，用于开发汽车诊断软件，从junior到supervisor的职位都有，熟悉Oracl，SQL，英语好，因为要和美国总部联系，并有出国培训机会，合适者待遇优厚。

有意向者可通过以下方式联系能得到更多信息

邮箱： jenny.shao@echelon-cn.com
电话： 51001620*809
—— Jenny 邵

From: Jennny
2007.09.04 13:33
版主选项: 回复 编辑
# 43532
libing


来自: xj

To:
　　25-3月 -2007 15:27:25 * (CONNECT_DATA=(SID=TFYB)(SERVER=DEDICATED)(CID=(PROGRAM=D:\Hisys6.0\hisys60.exe)(HOST=ZYJS2)(USER=LNB))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.30)(PORT=1632)) * establish * TFYB * 12560
TNS-12560: TNS: 协议适配器错误
 TNS-00517: 丢失连接
  32-bit Windows Error: 54: Unknown error
 TNS-12500: TNS：监听器未能启动专用的服务器进程
  TNS-12547: TNS：丢失连接
 TNS-12560: TNS: 协议适配器错误
  TNS-00517: 丢失连接
 32-bit Windows Error: 54: Unknown error
25-3月 -2007 17:23:18 * (CONNECT_DATA=(SID=tfyb)(SERVER=DEDICATED)(CID=(PROGRAM=E:\Hisys6.0\hisys60.exe)(HOST=MZJS1)(USER=lnb))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.13)(PORT=1892)) * establish * tfyb * 12500
TNS-12500: TNS：监听器未能启动专用的服务器进程
 TNS-12560: TNS: 协议适配器错误
关键问题次错误是偶尔出现。比如业务比较繁忙是，我真心的希望盖国强大师
你看次问题 谢谢

From: libing
2007.09.04 11:59
To: libing
　　
12500，通常是你的服务器资源耗尽（一般是内存），使得服务器无法启动Dedicated的进程，你检查一下监听器的日志，里面应该有错误记录的。

From: eygle
2007.09.04 22:25
版主选项: 回复 编辑
# 43530
Julia
To: Vera
　　Miss you too~~ Be good!
From: Julia
2007.09.01 14:15
版主选项: 回复 编辑
# 43529
vera
To: 盖。。盖。。。盖盖盖老师
　　咦。。。太久不来。。。落伍了。。。
几时都改称为盖老师了。。。

julia i miss u~
From: vera
2007.08.31 23:27
版主选项: 回复 编辑
# 43528
Julia
To: Alice
　　谢谢Alice，嘿嘿
From: Julia
2007.08.31 10:46
版主选项: 回复 编辑
# 43527
hwq
To: eygle
　　加上了
但是
执行到这
import done in ZHS16GBK character set and AL16UTF16 NCHAR character setSegmentation fault

就退出来了


不知道 11g到9i可不可以导数据？
From: hwq
2007.08.30 17:06
版主选项: 回复 编辑
# 43526
ryan
To: 盖老师
　　您好！
 请教个NBU备份oracle DB的问题。子job备份成功，但父job报错，以前备份好的，就这几天出现的。rman输出的部分log是：
..
channel dev2: starting piece 1 at 29-AUG-07
channel dev1: finished piece 1 at 29-AUG-07
piece handle=df19435_1_631898274 comment=API Version 2.0,MMS Version 5.0.0.0
channel dev1: backup set complete, elapsed time: 03:08:37
channel dev2: finished piece 1 at 29-AUG-07
piece handle=df19436_1_631898274 comment=API Version 2.0,MMS Version 5.0.0.0
channel dev2: backup set complete, elapsed time: 03:21:13
Finished backup at 29-AUG-07

Starting Control File and SPFILE Autobackup at 29-AUG-07
released channel: dev1
released channel: dev2
RMAN-00571: ===============================
RMAN-00569: ===== ERROR MESSAGE STACK FOLLOWS ====
RMAN-00571: ================================
RMAN-03009: failure of Control File and SPFILE Autobackup command on dev1 channel at 08/29/2007 18:39:15
ORA-19580: backup conversation not active

Recovery Manager complete.

From: ryan
2007.08.30 16:17
To: ryan
　　自动备份出错了，看看你的自动备份难道不在缺省目录?
From: eygle
2007.09.03 11:41
版主选项: 回复 编辑
# 43525
alice
To: eygle&julia
　　今天得知亲爱的宝宝enmo诞生，迟来的祝福给你们和ＢＢ．
尤其是julia好伟大啊，好佩服你的坚强．
祝你们这三口之家永远开心快乐！幸福永驻！
From: alice
2007.08.30 14:07
To: alice
　　谢谢：）
From: eygle
2007.08.30 16:01
版主选项: 回复 编辑
页: 1 - << < 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 > >> - 312
我要留言
Copyright © 2003-2008 eygle.com All Rights Reserved.
Powered by: www.eYgLe.com