-- Failed to execute: SQL Statement ==> SQLException ORA-00439: feature not enabled: Deferred Segment Creation
 --CREATE TABLE TRANSPORTER_BILL_CHGS 
   (	TRAN_ID CHAR(10) NOT NULL ENABLE, 
	LINE_NO CHAR(3) NOT NULL ENABLE, 
	CHARGE_CODE CHAR(5), 
	CHARGE_TYPE CHAR(1), 
	AMOUNT NUMBER(18,3), 
	TAX_CLASS CHAR(5), 
	TAX_CHAP CHAR(10), 
	TAX_ENV CHAR(10), 
	TAX_AMT NUMBER(18,3), 
	NET_AMT NUMBER(18,3), 
	CHARGE_BASE_VALUE NUMBER(18,3), 
	CHARGE_RATE NUMBER(14,3), 
	STD_CHARGE_AMT NUMBER(18,3), 
	VARIANCE_AMT NUMBER(18,3)
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS

 -- Failed to execute: SQL Statement ==> SQLException ORA-00955: name is already used by an existing object
 --CREATE TABLE USERS_GEOFENCE 
   (	USER_ID VARCHAR2(10), 
	GEO_FENCE_ENABLE CHAR(1), 
	GEO_FENCE_OPTION CHAR(1), 
	GEO_FENCE_STARTTIME VARCHAR2(5), 
	GEO_FENCE_ENDTIME VARCHAR2(5), 
	CHG_DATE DATE, 
	CHG_USER VARCHAR2(10), 
	CHG_TERM VARCHAR2(20), 
	TRAN_ID VARCHAR2(20) NOT NULL ENABLE
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS

 -- Failed to execute: SQL Statement ==> SQLException ORA-01950: no privileges on tablespace 'ITM_DATA_GEN'
 --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

 -- Failed to execute: SQL Statement ==> SQLException ORA-00955: name is already used by an existing object
 --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

 -- Failed to execute: SQL Statement ==> SQLException ORA-00439: feature not enabled: Deferred Segment Creation
 --CREATE TABLE WO_OBSRV_DET 
   (	TRAN_ID CHAR(10), 
	LINE_NO NUMBER(3,0), 
	SEQ_NO NUMBER(3,0), 
	OBSERV_DATA XMLTYPE
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE USERS 
 XMLTYPE COLUMN OBSERV_DATA STORE AS SECUREFILE BINARY XML (
  TABLESPACE USERS ENABLE STORAGE IN ROW CHUNK 8192
  NOCACHE LOGGING  NOCOMPRESS  KEEP_DUPLICATES ) ALLOW NONSCHEMA DISALLOW ANYSCHEMA

 -- Failed to execute: SQL Statement ==> SQLException ORA-00955: name is already used by an existing object
 --CREATE TABLE RPT_PRINT_LOG 
   (	TRAN_ID CHAR(12) NOT NULL ENABLE, 
	REPORT_NAME VARCHAR2(60), 
	PARAMETER_VAL VARCHAR2(100), 
	USER_ID__PRINT CHAR(10), 
	REPRINT_ON DATE, 
	REPRINT_CNT NUMBER(2,0), 
	TRAN_ID__CTRL CHAR(12)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE ITM_DATA

-- No of Rows = 6