Database Administration (MOSC)

MOSC Banner

alter table move partition

edited Jul 15, 2013 8:01PM in Database Administration (MOSC) 3 commentsAnswered
 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 , 

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