Hi
I have unpartitioned table with aroung 2 million rows. When I was creating
an index on the table, it failed as it was not able to extend the temp
segment. I added a temp segment and recreated the index.
But now i see the index is created on some columns which cannot be seen in
the DESCRIBE TABLE command.
The columns created are :
SYS_NC00022$
SYS_NC00023$
SYS_NC00024$
SYS_NC00025$
SYS_NC00026$
SYS_NC00027$
What are these columns. When I do a describe on the table, I cannot see
these columns but when I do a select as follows, I see some data in these
columns :
SELECT
SYS_NC00022$,SYS_NC00023$,SYS_NC00024$,SYS_NC00025$,SYS_NC00026$,SYS_NC00027
$ FROM <TABLENAME> ;
SYS_NC00022$ SYS_NC00023$ SYS_NC00024$ SYS_NC00025$ SYS_NC00026$
SYS_NC00027$
AFD2BAFF C8FF C7CCFF CFFF
CFFF CEFF
AFD2BAFF C8FF C7CFFF CFFF
CFFF CEFF
AFD2BAFF CAFF CCCAFF CFFF
CFFF CEFF
BAB3BAFF C8FF C9CFFF CFFF
CFFF CEFF
ACBABCFF C8FF CDCAFF C8FF
C8FF C9FF
AFD2BAFF C8FF C7CBFF CFFF
CFFF CEFF
........
......
........
....
What are these columns and what is the data contained in it?
TIA
-rM
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rahul Mehendale
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).
