SDE注册看不到空间数据

在电缆公司的测试服务器上安装了Oracle、ArcGIS，把空间数据和属性数据都导入数据库，出现一个怪问题，空间搜索返回的要素指针总是为空。最后在同事的帮助下发现了问题所在。用SQL*Plus设置了一下Oracle的系统变量，问题解决。

If you are using an spfile.ora file (the default in oracle9.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 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, and the following line to that file:
_push_join_union_view=false
The default init.ora file on Unix system 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 order-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.