3 Replies Latest reply: May 16, 2014 2:32 AM by 920799 RSS

    BISAMPLE schema to create the SAMP_CUSTOMERS_SCD table

    920799

      Hello All,

       

      We are getting the following error while creating below table for the use with Oracle sample app BISAMPLE

      Please help.. TIA

       

      SQL> sho user;

      USER is "BISAMPLE"

      SQL> CREATE TABLE BISAMPLE.SAMP_CUSTOMERS_SCD

      2  (

      CUST_KEY NUMBER,

      3    4  NAME VARCHAR2(255 CHAR),

      5  TYPE_KEY VARCHAR2(255 CHAR),

      6  FST_CONTACT_DT DATE,

      7  SEGMENT_KEY NUMBER,

      8  INCOME_LVL VARCHAR2(255 CHAR),

      9  STATUS_KEY VARCHAR2(255 CHAR),

      10 LST_ORDER_DT DATE,

      11 ADDRESS_KEY NUMBER,

      12 MARITAL_ST VARCHAR2(20 BYTE),

      13 PREV_MARITAL_ST VARCHAR2(20 BYTE),

      PREV_MARITAL_ST_DT DATE,

      14 15  BIRTH_DT DATE,

      16 CRDT_RATE NUMBER(*,0),

      17 GENDER VARCHAR2(20 BYTE),

      LTV NUMBER,

      18 19  NUM_ATTRIBUTE NUMBER,

      20 START_TIME TIMESTAMP (6),

      21 END_TIME TIMESTAMP (6),

      22 PERIOD FOR user_valid_time (start_time, end_time)

      );

      23  PERIOD FOR user_valid_time (start_time, end_time)

      *

      ERROR at line 22:

      ORA-00902: invalid datatype