PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

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)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center