解决sde注册看不到空间数据的问题

 解决sde注册看不到空间数据的问题，是oracle启动设置的问题，将init.ora文件里面的_push_join_union_view参数设置为false，如果没有该参数，则手工添加该参数_push_join_union_view=false。修改完成后重新启动Oracle和SDE即可。

 

C:/oracle/ora92/database目录下的

把里面的SPFILEDEV.ORA改名，然后加一个initDEV.ora改里面的内容

C:/oracle/admin/dev/pfile/init.ora.317200892354拷贝过来的，然后，把文件名改为initDEV.ora了

 

有可能10g下修改这个配置文件不管用。alter system set "_push_jion_union_view"=false 用命令执行

 

If you are using an spfile.ora file (the default in Oracle 9.2), use SQL*Plus to connect to Oracle as a user as SYSDBA and execute:

ALTER SYSTEM SET "_push_join_union_view"=false SCOPE=SPFILE;

Make sure to use the double-quotes, else SQL*Plus will raise an error because of the leading underscore character (the underscore indicates that this is a hidden parameter). This is also a static initialization parameter, meaning you must restart your Oracle instance for it to take effect (remember to shut down ArcSDE first).

If you are using an init.ora file, add the following line to that file:

_push_join_union_view=false

The default init.ora file on UNIX systems is:

ORACLE_HOME/dbs/init[sid].ora

where [sid] is the value of your ORACLE_SID environment variable. On Windows, it is:

ORACLE_HOME/database/init[sid].ora

This may or may not be the actual location of your init.ora file (one of the drawbacks to using this older-style parameter file), but there will likely be a link or placeholder (with an IFILE or PFILE parameter) in the location identified above. As with the spfile.ora file, you must restart Oracle for this parameter to take effect.

-Michael

Michael Mannion
James W. Sewall Company
http://forums.esri.com/Thread.asp?c=2&f=59&t=96306