Partitioned Tables TESTING

create table prime ( x primary key ) as  select user_id from all_users;
create table DEMO1  as select user_id from all_users;
alter table DEMO1 add constraint DEMO1_pk primary key(user_id);
alter table DEMO1 add constraint DEMO1_fk foreign key(user_id) referencesp(x);  2

create table DEMO2 (username varchar2(30),user_id number, created date  ) partition by hash(user_id) partitions 8;

exec dbms_redefinition.can_redef_table( user, 'DEMO1' );
exec dbms_redefinition.start_redef_table( user, 'DEMO1', 'DEMO2' );
****************************************
variable nerrors number
begin
dbms_redefinition.copy_table_dependents
( user, 'DEMO1','DEMO2',copy_indexes => dbms_redefinition.cons_orig_params,num_errors => :nerrors );
end;
/
***************************************
exec dbms_redefinition.finish_redef_table( user, 'DEMO1', 'DEMO2' );
select dbms_metadata.get_ddl( 'TABLE', 'DEMO1' ) from dual;
 
CREATE TABLE "SCOTT"."DEMO1"
   (    "USERNAME" VARCHAR2(30),
        "USER_ID" NUMBER CONSTRAINT "SYS_C0011002" NOT NULL ENABLE NOVALIDATE,
        "CREATED" DATE,
         CONSTRAINT "DEMO1_PK" PRIMARY KEY ("USER_ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  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)
  TABLESPACE "USERS"  ENABLE NOVALIDATE
   ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS"
  PARTITION BY HASH ("USER_ID")
 (PARTITION "SYS_P61" SEGMENT CREATION IMMEDIATE
  TABLESPACE "USERS"
 NOCOMPRESS ,
 PARTITION "SYS_P62" SEGMENT CREATION IMMEDIATE
  TABLESPACE "USERS"
 NOCOMPRESS ,
 PARTITION "SYS_P63" SEGMENT CREATION IMMEDIATE
  TABLESPACE "USERS"
 NOCOMPRESS ,
 PARTITION "SYS_P64" SEGMENT CREATION IMMEDIATE
  TABLESPACE "USERS"
 NOCOMPRESS ,
 PARTITION "SYS_P65" SEGMENT CREATION IMMEDIATE
  TABLESPACE "USERS"
 NOCOMPRESS ,
 PARTITION "SYS_P66" SEGMENT CREATION IMMEDIATE
  TABLESPACE "USERS"
 NOCOMPRESS ,
 PARTITION "SYS_P67" SEGMENT CREATION IMMEDIATE
  TABLESPACE "USERS"
 NOCOMPRESS ,
 PARTITION "SYS_P68" SEGMENT CREATION IMMEDIATE
  TABLESPACE "USERS"
 NOCOMPRESS )