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"
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!