Alter table by rename without LOB name
When i try build some record using "Alter table by rename" option application designer create an sql statement like that:
CREATE TABLE PSYITAU_ASPAR_RUN (PROCESS_INSTANCE DECIMAL(10) NOT NULL,
OPRID VARCHAR2(30) NOT NULL,
RUN_CNTL_ID VARCHAR2(30) NOT NULL,
QRYNAME VARCHAR2(30) NOT NULL,
ITAU_CD_IDENT SMALLINT NOT NULL,
PRCSINSTANCE INTEGER NOT NULL,
RUNSTATUSDESCR VARCHAR2(10) NOT NULL,
BEGINDTTM tIMESTAMP,
ENDDTTM tIMESTAMP,
OUTPUT_CSV VARCHAR2(1) NOT NULL,
FLAG VARCHAR2(1) NOT NULL,
DESCRLONG CLOB) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 80 INITRANS 1 MAXTRANS 255
ROW STORE COMPRESS ADVANCED LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS
2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
0