I don't know how it can have two columns with identical names. I know the X$ "tables" are unusual creatures but a duplicate column name goes against all common sense. Perhaps one of them has a space at the end of the name? Or else X$ tables aren't subject to the rules? Or else it's a bug in the describe command.
When I wonder about a particular x$ table, the only way I know of to try and figure out what the table's use is, is to spool the output of this SQL statement to a file: spool /tmp/gv_views.lst select view_name, view_definition from v$fixed_view_definition where view_name like 'GV$%' order by view_name ; and then search for the x$ table name. In the case of x$ksfmlib, I find it being used to build gv$map_library: GV$MAP_LIBRARY select inst_id,lib_idx,lib_name,vendor_name,protocol_num, version_num,path_name,decode(bitand(cap_fi le,1),0,'N',1,'Y'), decode(bitand(cap_file, 6),0,'NONE',6,'PERSISTENT',2,'NONPERSISTENT'), decode(bi tand(cap_elem, 1),0,'N',1,'Y'),decode(bitand(cap_elem,6),0,'NONE', 6,'PERSISTENT',4,'NONPERSISTENT') ,decode(cap_other,0,'N',1,'Y') from x$ksfmlib Of course some x$ tables are also used in dba_ views. For example x$ktfbfe in dba_free_space. > -----Original Message----- > From: Manoj Kumar Jha [mailto:[EMAIL PROTECTED] > > There is duplicate column on table 'X$KSFMLIB' > and duplicate column is 'CAP_ELEM' > Can any one tell me that why this so and what is significant > of this table. > > SQL> desc X$KSFMLIB > Name Null? Type > ----------------------------------------- -------- > ------------------------ > ---- > ADDR RAW(4) > INDX NUMBER > INST_ID NUMBER > LIB_IDX NUMBER > VERSION_NUM VARCHAR2(32) > VENDOR_NAME VARCHAR2(64) > PATH_NAME VARCHAR2(1024) > PROTOCOL_NUM NUMBER > LIB_NAME VARCHAR2(256) > CAP_FILE NUMBER > CAP_ELEM NUMBER > CAP_ELEM NUMBER > CAP_OTHER NUMBER > > ---------------------------------------------------------------- > Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production > PL/SQL Release 9.2.0.1.0 - Production > CORE 9.2.0.1.0 Production > TNS for 32-bit Windows: Version 9.2.0.1.0 - Production > NLSRTL Version 9.2.0.1.0 - Production > ---------------------------------------------------------------- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
