| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> (no subject)
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: rahul.mehendale_at_tatainfotech.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: ListGuru_at_fatcity.com (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 Tue Oct 22 2002 - 02:43:26 CDT
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |