|
# 43397
bing feng
|
|
|
 To: eygle
你好,
在pl/sql中取时间点的sql语句可以用
SELECT TRUNC(SYSDATE,'MM') FROM DUAL
我想问下有没有通用的取时间点的sql语句，
就是在别的数据库中也可以用的存sql语句，
谢谢啊！
From: bing feng
2007.06.26 12:51
|
|
|
|
|
To: bing feng
没有能够完全通用的，不同的数据库有各自的特点，比如dual表别的数据库就不存在。
From: eygle
2007.06.27 13:40
|
|
|
|
|
# 43396
Chi
来自: Mexico
|
|
|
To: Eygle
I am using an old Solaris 8 machine as the location of any oracle file multiplexing and storage of RMAN.But I have zero experience of Solaris 8.This machine is about 6 years old, Can you provide some basic tools or utilitis (or quick reference) to diagnosis of the box?Check on the hardware and software condition. Thanks.
From: Chi
2007.06.26 07:11
|
|
|
|
|
To: Chi
Solaris自带了一些工具:
/usr/platform/sun4u/sbin/prtdiag
dmesg
能看到不少信息的。
From: eygle
2007.06.27 13:36
|
|
|
|
|
# 42981
rocket
|
|
|
To:
请盖老师讲解一下primary key与unique约束的具体区别和使用
From: rocket
2007.06.25 16:14
|
|
|
|
|
To: rocket
Primary key属于约束范畴，强制唯一，不能包含空值，主键会自动创建索引，一个表只能存在一个主键约束。
Unique约束限制唯一性，但是可以存在Null值，一个表中可以存在多个唯一键约束。
细致的区别还有很多。
From: eygle
2007.06.27 13:58
|
|
|
|
|
# 42974
Chi
来自: Mexico
|
|
|
To: Eygle
When doing the RMAN recovery/restore, We only recover/ restore the DB back to the status when we to the backup. so if we want to recover/restore back to the status as the moment of DB failure, we need to recover the un-backup archive log and the last active redo log too during the recovery process,assumed the mulitplexed archive log and redo log exist. But I am not sure what is the order.
1. in RAMN, recover / restore
2. in sqlplus start db mount
2. in sqlplus, restore the archivelog
3. recover the redo log
4. re-set log
5. database open
Please clarify, Thanks.
From: Chi
2007.06.24 03:11
|
|
|
|
|
# 42959
garylyell
|
|
|
To: eygle
solaris10 下怎样安装 vnc？
From: garylyell
2007.06.20 13:53
|
|
|
|
|
To: garylyell
没装过，有什么问题么？
Unix/Linux上装个VNC都是很容易的阿。
From: eygle
2007.06.21 10:35
|
|
|
|
|
# 42956
Chi
来自: Mexico
|
|
|
To: Eygle
Right now, we have 2 AIX boxes, same model, with almost identical hardwares, one Prod server and one Dev server. What is your opinion if we set up the Data Guard to convert them to Prod/Standby configuration? or just configure the Prod server with RMAN backup/recovery plan? What kinds of factor that I need to consider? Both Boxes have BAAN 5 and 10g R2. we also configure another Solaris 8 box as backup storage. Currently the Database is approx. 4 G ( from export)
From: Chi
2007.06.20 10:44
|
|
|
|
|
# 42952
xujun206
|
|
|
To:
standby db archivelog 跳号问题，现在从库不能自动恢复，日志有个错误Failed to request gap sequence ，而缺少的那些日志文件本身又不存在的，是因为主库跳号而引起的，我想问你，怎么样可以不用重做就可以解决问题啊 ？？
From: xujun206
2007.06.19 11:06
|
|
|
|
|
eygle.com
我要留言
回复
编辑