copying data from partition and converting

I am looking to copy data from one partition to another for testing purposes.

My table is partitioned on create_date so I would like convert the old
create_date values (2011-05-20) to a new values (2011-05-21) so it
goes into another parition. In addition, I want is there any easy way to
convert null values to a default value.

Can this be done via a SQL statement? Is so can somebody provide and example or point me to the correct place in the documentation.

Thanks

Quote:

---

Originally Posted by BeefStu

I am looking to copy data from one partition to another for testing purposes.

My table is partitioned on create_date so I would like convert the old
create_date values (2011-05-20) to a new values (2011-05-21) so it
goes into another parition.

---

A simple insert statement will do it, be sure you populate your insert statement - probably with an append hint - from souce partition, like FROM mytable PARTITION (mysourcepartition)

In regards to adding one day to the date you can always use (mydate + 1) syntax.

Quote:

---

Originally Posted by BeefStu

I want is there any easy way to
convert null values to a default value.

---

Research NVL() function, like nvl(mycolumn, defaul-value)

For those of you who are intersted here is the solution. Also in the where
clause you can use from paritition (partition_name)

Set's create_date to 2011-05-28

INSERT INTO XXX.YYY
SELECT to_date( '2011-05-28' || to_char( create_date,'HH24:MI SS'), 'YYYY-MM-DD HH24:MI SS' ),
col1, col2, col3, col4 FROM
XXX.YYY where create_date >= TO_DATE ( '2011/02/17', 'yyyy/mm/dd') AND
create_date < TO_DATE ( '2011/02/18', 'yyyy/mm/dd');