What is this extra column?
Hello I got a curious column in a table. It's Enterprise Oracle 10.2.0.3 on AIX. I found it when I used datapump to copy a schema from one db to another. Found it created this 'extra' column. I looked at the source db and found this:
1 select name, property, segcol#, col#
2 from sys.col$
3 where obj# = 374103
4* order by col#
SQL> /
NAME PROPERTY SEGCOL# COL#
------------------------------ ---------- ---------- ----------
SYS_C00098_10072711:34:19$ 1081376 98 0
REGISTERID 0 1 1
RECORDTYPE 0 2 2
COMPCD 0 3 3
DIVCD 0 4 4
STORECD 0 5 5
REGFILEIND 0 6 6
SHIPTOGEOCODE 0 7 7
.
.
.
SQL> desc "VERTEX"."REGPRERETURNSTBL"
Name Null? Type
----------------------------------------- -------- ----------------------------
REGISTERID VARCHAR2(25)
RECORDTYPE NUMBER(3)
COMPCD VARCHAR2(5)
DIVCD VARCHAR2(5)
STORECD VARCHAR2(10)
REGFILEIND NUMBER(38)
SHIPTOGEOCODE NUMBER(9)
.
.
.
1 select dbms_metadata.get_ddl('TABLE', 'REGPRERETURNSTBL', 'VERTEX')
2* from dual
SQL> /
DBMS_METADATA.GET_DDL('TABLE','REGPRERETURNSTBL','VERTEX')
--------------------------------------------------------------------------
CREATE TABLE "VERTEX"."REGPRERETURNSTBL"
( "SYS_C00098_10072711:34:19$" VARCHAR2(255),
"REGISTERID" VARCHAR2(25),
"RECORDTYPE" NUMBER(3,0),
"COMPCD" VARCHAR2(5),
"DIVCD" VARCHAR2(5),
"STORECD" VARCHAR2(10),
"REGFILEIND" NUMBER(*,0),
"SHIPTOGEOCODE" NUMBER(9,0),
.
.
.
I could just re-create the table, but curious if anyone know what that column is and possibly how it got there. Anyone know what property 1081376 means?
TIA