# 43797
Juila
|
|
To: 猫咪
老公,累得我想吐了。。。。。。
From: Juila 2007.12.16 22:59
|
|
|
|
# 43792
江大鱼
|
|
To:
我的目的是想修改oracle 的 default Sort,这样应用程序就不用一个一个该,也不用每次修改session
NLS_SORT=SCHINESE_PINYIN_M
NLS_COMP=ANSI
重启Oracle
但是select * fromNLS_SESSION_PARAMETERS 看到这两个参数去不是这样
NLS_SORT=BINARY
NLS_COMP=ANSI
中文排序不起作用?为什么呀!!!
From: 江大鱼 2007.12.13 23:50
|
|
|
|
# 43791
江大鱼
|
|
To:
如果将Oracle的中文排序固化!
1。设定环境变量
set NLS_SORT=SCHINESE_RADICAL_M ;export NLS_SORT (sh)
or setenv NLS_SORT SCHINESE_RADICAL_M (csh)
or regedit
HKLC\SOFTWARE\ORACLE\home0\NLS_SORT (win)
2.在session中修改
alter session set NLS_SORT=SCHINESE_RADICAL_M
3.直接使用NLSSORT函数
select name,id from t
order by NLSSORT(name,NLS_SORT = SCHINESE_STROKE_M)
第2,3中方式不好。但第1中方式,我好想试过不行,有没有其他的方式。或者第一种方式我可能哪里做的不对!
From: 江大鱼 2007.12.13 17:02
|
|
|
|
# 43790
Juila
|
|
To: Eygle
哦哦哦哦!!! 我一无所有!!!
票明天送到,好开心!
From: Juila 2007.12.12 19:13
|
|
|
|
# 43789
Chi
来自: Mexico
|
|
To: Eygle
In you data guard Step-by step, you have a step called
打开备用数据库: and command following
SQL> alter database commit to switchover to primary;
I am little confused with this step. It is done on the standby or on primary. Why you have to do it?Because there is another one in the bottom of that file
在备用节点
did it again.
can you explain little more. Some steps, I am confused where it should be done, primaryor stand by.I am also reading the Offical doc about 10g R2, that is my server, too.
From: Chi 2007.12.12 16:04
|
|
|
|
# 43787
wang219
|
|
To: to eygle
数据库启动没有问题,当切换日志时报ora_03113错误数据库历程失败
盖老师这一般什么问题
From: wang219 2007.12.11 06:20
|
|
|
|
# 43786
StepIn
|
|
To: eygle
请问一下eygle,能否推荐一两本书可以跟《循序渐进Oracle》配合读的,我是初学者,想通过学习,参加认证考试。
From: StepIn 2007.12.11 00:07
|
|
|
|
# 43785
oralnx
|
|
To: Eygle
盖老师:
这几个东东,分别起什么作用?
谢谢...
Adalnctl.shadcmctl.sh adfmsctl.shadrepctl.shgsmstart.sh
Adapcctl.shaddisctl.shadfrmctl.shadstpall.shjtffmctl..sh
Adaprstctl.shadexecsql.pl adncnv.log adstrtal.sh
Adautocfg.sh adfmcctl.shadpreclone.pladtcfctl.sh
From: oralnx 2007.12.10 21:12
|
|
|
|
|