Re: Partitioning examples (was Re: move a row from table t1 to t2)

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Sat, 03 Feb 2007 03:00:40 GMT
Message-ID: <Xns98CBC1658D108anacedenthotmailcom@69.28.173.184>

hasta_l3_at_hotmail.com wrote in news:1170435391.044151.215140 @s48g2000cws.googlegroups.com:

> On 2 fév, 03:43, "Ana C. Dent" <anaced..._at_hotmail.com> wrote:

>> "Prasath" <prasath...._at_gmail.com> wrote in news:1170346209.864715.221880
>> @q2g2000cwa.googlegroups.com:
>>
>> >Tablet2is used to stored aged data.  Hence, using view is not the
>> > solution I am looking for.
>>
>> Just use partitioning &movethe partition from current_table to
>> archived_table

>
> Ana, would you (or anybody else :-) have a reference to a
> web site or book with examples of partionning in actual
> applications ?

http://tahiti.oracle.com -- has the whole Oracle Doc. set online

http://asktom.oracle.com -- has many fine coding examples Received on Fri Feb 02 2007 - 21:00:40 CST