Database Administration (MOSC)

MOSC Banner

system-generated column names out of nowhere

edited Apr 19, 2010 8:59AM in Database Administration (MOSC) 6 commentsAnswered ✓
 Hello. I am trying to figure out why I am seeing the system-generated column names in the output from the following DDL

select index_name, column_name
from dba_ind_columns
where index_name in (select index_name from dba_indexes where table_name = 'CRD_ACCT_RECM_RSPNS_SUM')
and index_owner = 'CAPP'
order by index_name, column_position asc

my output is

CRD_ACCT_RECM_RSPNS_SUM_ALT1   ACCT_NBR
CRD_ACCT_RECM_RSPNS_SUM_ALT1   CUST_TYP_CDE
CRD_ACCT_RECM_RSPNS_SUM_ALT1   RECM_GRP_CDE
CRD_ACCT_RECM_RSPNS_SUM_ALT1   SYS_NC00017$
CRD_ACCT_RECM_RSPNS_SUM_ALT1  

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center