STEP TO PARTITION A NON PARTITIONED TABLE
STEP TO PARTITION A NON PARTITIONED TABLE I have a table that is not partitioned and I need to make into a partitioned table. To solve this issue its possible to partition a non-partitioned table using three different ways: A) export/import method B) Insert with a subquery method C) Partition exchange method Ive used the second method that is: 1) Create the partitioned table: create table hr.fact_navigation_new ( date_events date not null ) partition by range (date_events) ( partition part_2008_01_01 values less than (to_date(2008-01-02, yyyy-mm-dd)) tablespace part_2008_01_usr_dwh , partition part_future values less than (MAXVALUE) tablespace part_future ) enable row movement; With user SYS I created first two tablespaces: create tablespace part_2008_01_usr_dwh datafile +dwh_db/dwhdb/datafile/dtf_part_2008_01_usr_dwh_01.ora size 1024m reuse autoextend on next 51200k maxsize 32767m, +dwh_db/dwhdb/datafile/dtf_part_2008_01_usr_dwh_02.ora size 1024m reuse autoextend on next 51200k maxsi...