DDL Source for TABLE a1.DBOTARGETUSER.DBOSTAT_LSTATS

This page was created on: 28 March 2017, 11:53

[ DB a1 Home ] [ Schema DBOTARGETUSER Home ] [ TABLES Home ] [ DDL Wizard Home ]

CREATE TABLE "DBOSTAT_LSTATS" 
    (
        "RUNID" VARCHAR2 ( 250 ) NOT NULL ENABLE,
        "RULEID" VARCHAR2 ( 50 ) NOT NULL ENABLE,
        "RULEBLOCK" NUMBER ( *,0 ) NOT NULL ENABLE,
        "RULENUM" NUMBER ( *,0 ) NOT NULL ENABLE,
        "RULESUBSCRIPT" NUMBER ( *,0 ) NOT NULL ENABLE,
        "RULETYPE" VARCHAR2 ( 50 ) NOT NULL ENABLE,
        "RULECREATED" DATE NOT NULL ENABLE,
        "RULEUPDATED" DATE NOT NULL ENABLE,
        "SECONDSACTIVE" NUMBER ( *,0 ) NOT NULL ENABLE,
        "RULESTATUS" CHAR ( 1 ) NOT NULL ENABLE,
        "RULETARGET" VARCHAR2 ( 100 ) ,
        "LOADEDROWS" NUMBER ( *,0 ) ,
        "RULERPN" NUMBER ( *,0 ) ,
        "LOADEDRPN" NUMBER ( *,0 ) ,
        "RULEMODE" VARCHAR2 ( 2 ) ,
        "NOTE" VARCHAR2 ( 50 ) 
    ) 
    PCTFREE 10 
    PCTUSED 40 
    INITRANS 1 
    MAXTRANS 255 TABLESPACE "USERS" LOGGING NOCOMPRESS 
;


DDL Dependent on TABLE DBOSTAT_LSTATS
Indexes
a1_DBOTARGETUSER_INDEX_IX_DBOSTAT_LSTATS.htm

[ DDL Wizard Home ]

This page was generated by the public version of the Net 2000 Ltd. DDLWizard software. Net 2000 Ltd. publishes other useful software for Oracle databases: Data Masker which replaces sensitive information in test and development databases with realistic looking anonymous data and DataBee the simplest and easiest way to create referentially correct subsets of large Oracle databases.