CREATE TABLE SQLPLUS_PRODUCT_PROFILE 
   (	PRODUCT VARCHAR2(30) NOT NULL ENABLE, 
	USERID VARCHAR2(30), 
	ATTRIBUTE VARCHAR2(240), 
	SCOPE VARCHAR2(240), 
	NUMERIC_VALUE NUMBER(15,2), 
	CHAR_VALUE VARCHAR2(240), 
	DATE_VALUE DATE, 
	LONG_VALUE LONG
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE ITM_DATA_GEN;
CREATE TABLE USERTYPE_LIC_CHRGS 
   (	USER_LIC_TYPE CHAR(1) NOT NULL ENABLE, 
	CHRG_AMT NUMBER(14,3), 
	REMARKS VARCHAR2(60), 
	ADD_DATE DATE NOT NULL ENABLE, 
	ADD_USER CHAR(10) NOT NULL ENABLE, 
	ADD_TERM CHAR(15) NOT NULL ENABLE, 
	CHG_DATE DATE NOT NULL ENABLE, 
	CHG_USER CHAR(10) NOT NULL ENABLE, 
	CHG_TERM CHAR(15) NOT NULL ENABLE
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS;

-- No of Rows = 2
