Use the following to truncate specific partitions
alter table ... truncate partition ...
Showing posts with label dba. Show all posts
Showing posts with label dba. Show all posts
Wednesday, April 4, 2007
add new partitions
Use the following to add new date partitions ...
alter table ... add partition ... values less than (to_date(...))
...
alter table ... add partition ... values less than (to_date(...))
...
Subscribe to:
Posts (Atom)