Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: create view?ora-00957 duplicate column name?

Re: create view?ora-00957 duplicate column name?

From: lfree <a_at_a.a>
Date: Wed, 21 Jun 2006 10:45:47 +0800
Message-ID: <e7abr0$4dk$1@news.yaako.com>


> >
> > 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US