Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: create view?ora-00957 duplicate column name?
> >
> > 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?
>
> Nothing has been done on this script since 8i, so you would need to
> verify whether it is still compatible after *2 new major* releases.
> Apart from that it looks appropiate to submit this remark directly to
> Steve Adams, being the author of the Ixora website.
>
I only want to know why field LASTTIME has two?
Received on Tue Jun 20 2006 - 21:45:47 CDT