-- Create table
create table LBI_SYS_VDF.T_S_SQL_DEBUG_LOG
(
LOG_TIME TIMESTAMP(6),
TASK_NAME VARCHAR2(60),
SQL_TEXT1 VARCHAR2(4000),
SQL_TEXT2 VARCHAR2(4000)
)
partition by range (LOG_TIME)
(
partition SYS_P10202 values less than (TIMESTAMP' 2015-02-28 00:00:00')
tablespace TBS_LBI_SYS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 8M
next 1M
minextents 1
maxextents unlimited
)
);
create table LBI_SYS_VDF.T_S_SQL_DEBUG_LOG
(
LOG_TIME TIMESTAMP(6),
TASK_NAME VARCHAR2(60),
SQL_TEXT1 VARCHAR2(4000),
SQL_TEXT2 VARCHAR2(4000)
)
partition by range (LOG_TIME)
(
partition SYS_P10202 values less than (TIMESTAMP' 2015-02-28 00:00:00')
tablespace TBS_LBI_SYS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 8M
next 1M
minextents 1
maxextents unlimited
)
);