create table ts$ /* tablespace table /
( ts# number not null, / tablespace identifier number /
name varchar2(“M_IDEN_30”) not null, / name of tablespace /
owner# number not null, / owner of tablespace /
online$ number not null, / status (see KTT.H): /
/ 1 = ONLINE, 2 = OFFLINE, 3 = INVALID /
contents$ number not null, / TEMPORARY/PERMANENT /
undofile# number, / undo_off segment file number (status is OFFLINE) /
undoblock# number, / undo_off segment header file number /
blocksize number not null, / size of block in bytes /
inc# number not null, / incarnation number of extent /
scnwrp number, / clean offline scn - zero if not offline clean /
scnbas number, / scnbas - scn base, scnwrp - scn wrap /
dflminext number not null, / default minimum number of extents /
dflmaxext number not null, / default maximum number of extents /
dflinit number not null, / default initial extent size /
dflincr number not null, / default next extent size /
dflminlen number not null, / default minimum extent size /
dflextpct number not null, / default percent extent size increase /
dflogging number not null,
/ lowest bit: default logging attribute: clear=NOLOGGING, set=LOGGING /
/ second lowest bit: force logging mode /
affstrength number not null, / Affinity strength /
bitmapped number not null, / If not bitmapped, 0 else unit size /
/ in blocks /
plugged number not null, / If plugged /
directallowed number not null, / Operation which invalidate standby are /
/ allowed /
flags number not null, / various flags: see ktt3.h /
/ 0x01 = system managed allocation /
/ 0x02 = uniform allocation /
/ if above 2 bits not set then user managed /
/ 0x04 = migrated tablespace /
/ 0x08 = tablespace being migrated /
/ 0x10 = undo tablespace /
/ 0x20 = auto segment space management /
/ if above bit not set then freelist segment managed /
/ 0x40 = COMPRESS /
/ 0x80 = ROW MOVEMENT /
/ 0x100 = SFT /
/ 0x200 = undo retention guarantee /
/ 0x400 = tablespace belongs to a group /
/ 0x800 = this actually describes a group /
/ 0x10000 = OLTP Compression /
/ 0x20000 = Columnar Low Compression /
/ 0x40000 = Columnar High Compression /
/ 0x80000 = Archive Compression /
/ 0x100000 = 12g bigfile tablespace /
/ 0x200000 = DB Consol. Shared TS /
/ 0x800000 = ILM policy present /
/ 0x1000000 = bad transport of ts in pdb /
/ 0x2000000 = ILM segment access tracking /
/ 0x4000000 = ILM row access tracking /
/ 0x8000000 = ILM update activity tracking /
/ 0x10000000 = ILM create activity tracking /
/ 0x800000000002 = SHARED /
/ 0x1000000000040=DEF_INDEX_COMPRESSION(KTT_COMPRESSED||KTT_IDX_COMPRESSED)/
/ 0x1000000000000 and 0x6000000000000 and F0000 = INDEX_COMPRESS_FOR /
/ 0xF80000000000000 = DEF_CELLCACHE /
/ 0x1000000000000000 LOST_WRITE_PROTECT ENABLED /
/ 0x2000000000000000 LOST_WRITE_PROTECT SUSPEND /
pitrscnwrp number, / scn wrap when ts was created /
pitrscnbas number, / scn base when ts was created /
ownerinstance varchar(“M_IDEN_30”), / Owner instance name /
backupowner varchar(“M_IDEN_30”), / Backup owner instance name /
groupname varchar(“M_IDEN_30”), / Group name /
spare1 number, / plug-in SCN wrap /
spare2 number, / plug-in SCN base */
spare3 varchar2(1000),
spare4 date
)