I have a tables without partitions and I now want to partition it. How do I go about this? I tired alter table ... add partition... but it errors with "ORA-14501: object is not partitioned "
So I tried to re-create the table with partitions:
create table quote_header_test as select * from quote_header
partition by range (ordered_date)
partition less_jul2004 values less than (to_date('01-JUL-2004','MON-DD-YYYY'));
This gives me "ORA-00933: SQL command not properly ended"