create view?ora-00957 duplicate column name?

From: lfree <a_at_a.a>
Date: Mon, 19 Jun 2006 09:30:26 +0800
Message-ID: <e74un9$sp4$1@news.yaako.com>

select * from v$version

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.

I reference document of www.ixora.com.au: http://www.ixora.com.au/scripts/sql/create_xviews.sql select
  'create or replace view X_$' || substr(name, 3) ||   ' as select * from ' || name || ';'
from
  sys.v_$fixed_table
where
  name like 'X$%'
/
I find to create view X_$KMGSCT and X_$KQRFP has erroe: 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
I use sqlplus login sys as dba, run `DESC X$KMGSCT` : SQL> DESC X$KMGSCT
ADDR RAW(8)
INDX NUMBER
INST_ID NUMBER
GRANTYPE NUMBER
GRANSIZE NUMBER
COMPONENT VARCHAR2(64)
OPCODE NUMBER
OPMODE NUMBER
PARNO NUMBER
CURSIZE NUMBER
USERSIZE NUMBER
INITSIZE NUMBER
TARGSIZE NUMBER
MINSIZE NUMBER
MAXSIZE NUMBER
OPERCNT NUMBER
LASTOPER NUMBER
LASTMODE NUMBER
LASTTIME DATE
STARTTIME DATE
LASTTIME DATE I find field LASTTIME has two. why? Received on Sun Jun 18 2006 - 20:30:26 CDT