http://www.itpub.net/showthread.php?s=&postid=4537407#post4537407
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bi
PL/SQL Release 10.2.0.2.0 - Production
CORE 10.2.0.2.0 Production
TNS for Linux: Version 10.2.0.2.0 - Production
NLSRTL Version 10.2.0.2.0 - Production
5 rows selected.
今天我在测试机器上建立视图，参照ixora的命令生成脚本
select
'create or replace view X_$' || substr(name, 3) ||
' as select * from ' || name || ';'
from
sys.v_$fixed_table
where
name like 'X$%'
我发现有两个无法建立：
create or replace view X_$KMGSCT as select * from X$KMGSCT;
create or replace view X_$KQRFP as select * from X$KQRFP;
报ora-00957 duplicate column name
我执行select * from X$KMGSCT;
发现最后三个字段为lasttime，startime，lasttime_1 ,我猜测lasttime，lasttime_1一定是同一个字段。
X$KQRFP也是遇到相同的问题，这种现象如何解析呢？
