Partition a table

[nbajrach]

how to partition on a table if table already exits without any partition.


This is what i tried but gave me error

SQL> alter table sip add partition by range(si_id)

2 partition p1_si values less than (50001),

3 partition p2_si values less than (100001),

4 partition p3_si values less than (150001),

5 partition p4_si values less than (200001);

alter table si add partition by range(si_id)

*

ERROR at line 1:

ORA-00902: invalid datatype

[AdusumalliGopikumar]

I think this might work now ,

alter table sip add partition by range(si_id)

(partition p1_si values less than (50001),

partition p2_si values less than (100001),

partition p3_si values less than (150001),

partition p4_si values less than (200001));

[nbajrach]

Same error

alter table si add partition by range(si_id)
*


ERROR at line 1:

ORA-00902: invalid datatype

[debasisdas]

Partition can't be added to a non-partitioned table.