-
Partition a table
Dear all,
I have an old and non-partitioned table with couple hundred millions of rows. Now we need to partition the table to increase performance. Is there a way that I can add partition to the table without recreating it? I tried this and got error:
alter table test add partition by range (DATE)
(partition DEC04 values less than ('01-JAN-05'),
partition JUN05 values less than ('01-JUL-05'));
alter table test add partition by range (DATE)
*
ERROR at line 1:
ORA-00902: invalid datatype
I know that Oracle will allow me to add partitions to existing partitioned table, but what about a non-partitioned table?
Any help will be appreciated.
Thanks,
Unna
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|