Duplicate column

From: Manoj Kumar Jha <jmanoj_at_delhi.tcs.co.in>
Date: Mon, 16 Jun 2003 00:38:20 -0700
Message-ID: <F001.005B210A.20030616001919@fatcity.com>

Hi All,

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

With Regards,
Manoj Kumar Jha

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Manoj Kumar Jha
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 - 02:38:20 CDT