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也是遇到相同的問題,這種現象如何解析呢?