| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Duplicate column
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(bitand(cap_elem, 1),0,'N',1,'Y'),decode(bitand(cap_elem,6),0,'NONE', 6,'PERSISTENT',4,'NONPERSISTENT')
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).Received on Mon Jun 16 2003 - 19:38:16 CDT
 |
 |