alter table move partition
Hi,
I'am moving tables for different tablespaces, these tables are partitioned and was performed as follows:
alter table VE.table_name move partition tablespace new_tbs;
but, to extract the ddl of the table is as follows:
CREATE TABLE "VE"."TLA714_NOM_CTO"
( "FH_CORTE" DATE,
"CD_ENTIDAD_ABN" VARCHAR2(4),
"CD_OFICINA_ABN" VARCHAR2(4),
"NU_CTA_ABN"VARCHAR2(22),
"NU_CTE_ABN" VARCHAR2(8))
TABLESPACE "TS_DAT761" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( BUFFER_POOL DEFAULT) NOLOGGINGPARTITION BY LIST ("FH_CORTE")
(PARTITION "P1" VALUES (TO_DATE(' 2012-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS','NLS_CALENDAR=GREGORIAN')) TABLESPACE "new_tbs" PCTFREE 5 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 2048K NEXT 1024K MINEXTENTS 1MAXEXTENTS 2147483645 PCTINCREASE 0 BUFFER_POOL DEFAULT) NOLOGGING NOCOMPRESS ,
0