lizisor 发表于 2011-12-22 08:54

如何修改global name

<DIV>
<P><SPAN style="COLOR: #ff0000">1、更改global_names 为true;</SPAN></P>
<P>&nbsp;&nbsp; &nbsp; &nbsp; &nbsp;SQL&gt;&nbsp;alter system set global_names=true;--慎重</P>
<P><SPAN style="COLOR: #ff0000">2、查看global_names属性</SPAN></P>
<P>
<P>SQL&gt; show parameter global_name;</P>
<P>NAME &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TYPE &nbsp; &nbsp; &nbsp; &nbsp;VALUE</P>
<P>------------------------------------ ----------- ------------------------------</P>
<P>global_names &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; boolean &nbsp; &nbsp; FALSE</P>
<P></P>
<P><SPAN style="COLOR: #ff0000">3、修改global_name</SPAN></P>
<P>SQL&gt; conn sys/sys as sysdba<BR>已连接。<BR>SQL&gt; select * from global_name;<BR>GLOBAL_NAME<BR>--------------------------------------------------------------------------------<BR>ORCL.US.ORACLE.COM<BR>SQL&gt; update props$ set value$ = 'orcl' where name = 'GLOBAL_DB_NAME';<BR>已更新 1 行。<BR>SQL&gt; select * from global_name;<BR>GLOBAL_NAME<BR>--------------------------------------------------------------------------------<BR>orcl<BR><BR></P></DIV>
页: [1]
查看完整版本: 如何修改global name