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