Main Tables Views Materialized Views Indexes Constraints Triggers Procedures Functions Packages Sequences Java Sources Jobs Sanity Check Index DDL scrips
Description Columns Primary key Check Constraints Foreign keys Unique Keys Options Indexes Referenced by Triggers Partitions

QRTZ_JOB_DETAILS

DDL script

Columns

NameTypeNullableDefault valueComment
JOB_NAMEVARCHAR2(200)N  
JOB_GROUPVARCHAR2(200)N  
DESCRIPTIONVARCHAR2(250)Y  
JOB_CLASS_NAMEVARCHAR2(250)N  
IS_DURABLEVARCHAR2(1)N  
IS_VOLATILEVARCHAR2(1)N  
IS_STATEFULVARCHAR2(1)N  
REQUESTS_RECOVERYVARCHAR2(1)N  
JOB_DATABLOBY  

Primary key:

Constraint NameColumns
SYS_C009257JOB_NAME , JOB_GROUP

Options:

OptionSettings
TablespaceUSERS
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumnsDDL script
IDX_QRTZ_J_REQ_RECOVERYNORMALNONUNIQUEREQUESTS_RECOVERY DDL script
SYS_C009257NORMALUNIQUEJOB_NAME , JOB_GROUP DDL script
SYS_IL0000021452C00009$$LOBUNIQUE DDL script

Referenced by:

TableConstraint
QRTZ_JOB_LISTENERS SYS_C009262
QRTZ_TRIGGERS SYS_C009272
Generated by OraSchemaDoc, (c) Petr Vanek, 2005; Aram Kananov, 2002, on Wed Mar 4 07:58:24 2020