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