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也是遇到相同的问题,这种现象如何解析呢?
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/267265/viewspace-82872/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/267265/viewspace-82872/