DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.AWRI$_CDB_TS$

Object Details
Object Name: AWRI$_CDB_TS$
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
TS# NUMBER
Yes
NAME VARCHAR2 (30) Yes
OWNER# NUMBER
Yes
ONLINE$ NUMBER
Yes
CONTENTS$ NUMBER
Yes
UNDOFILE# NUMBER

UNDOBLOCK# NUMBER

BLOCKSIZE NUMBER
Yes
INC# NUMBER
Yes
SCNWRP NUMBER

SCNBAS NUMBER

DFLMINEXT NUMBER
Yes
DFLMAXEXT NUMBER
Yes
DFLINIT NUMBER
Yes
DFLINCR NUMBER
Yes
DFLMINLEN NUMBER
Yes
DFLEXTPCT NUMBER
Yes
DFLOGGING NUMBER
Yes
AFFSTRENGTH NUMBER
Yes
BITMAPPED NUMBER
Yes
PLUGGED NUMBER
Yes
DIRECTALLOWED NUMBER
Yes
FLAGS NUMBER
Yes
PITRSCNWRP NUMBER

PITRSCNBAS NUMBER

OWNERINSTANCE VARCHAR2 (30)
BACKUPOWNER VARCHAR2 (30)
GROUPNAME VARCHAR2 (30)
SPARE1 NUMBER

SPARE2 NUMBER

SPARE3 VARCHAR2 (1000)
SPARE4 DATE

CON_ID NUMBER

container id
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TS#
,      NAME
,      OWNER#
,      ONLINE$
,      CONTENTS$
,      UNDOFILE#
,      UNDOBLOCK#
,      BLOCKSIZE
,      INC#
,      SCNWRP
,      SCNBAS
,      DFLMINEXT
,      DFLMAXEXT
,      DFLINIT
,      DFLINCR
,      DFLMINLEN
,      DFLEXTPCT
,      DFLOGGING
,      AFFSTRENGTH
,      BITMAPPED
,      PLUGGED
,      DIRECTALLOWED
,      FLAGS
,      PITRSCNWRP
,      PITRSCNBAS
,      OWNERINSTANCE
,      BACKUPOWNER
,      GROUPNAME
,      SPARE1
,      SPARE2
,      SPARE3
,      SPARE4
,      CON_ID
FROM SYS.AWRI$_CDB_TS$;

Dependencies

[top of page]

SYS.AWRI$_CDB_TS$ does not reference any database object

SYS.AWRI$_CDB_TS$ is not referenced by any database object