Go up

Next thread:	expdp fails
Prev thread:	oracle duplicate command

Message	Score	Author	Date
Hi masters, i have one table which is containin......		javed akhtar	Aug 08, 2012, 12:04
use the split partition strategy. 1. create the......		Mohit Jain	Aug 08, 2012, 12:47
Another way: use dbms_redefinition package. R......		Michel Cadot	Aug 08, 2012, 13:05
You can use interval partition to convert the new ......		Ravinder Bhalla	Oct 05, 2012, 19:08

Follow up by mail

Click here

---

Subject:	convert table in partition
Author:	javed akhtar, India
Date:	Aug 08, 2012, 12:04, 3951 days ago
Os info:	aix
Oracle info:	11g
Message:	Hi masters, i have one table which is containing monthly partitions from 1-jan-2012 to 1-jan-2013 and the data is storing in respective partitions. now i want to convert monthly partitions into daily partitions. how can i do, plz guide me. thanks
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here

---

Subject:	Re: convert table in partition
Author:	Mohit Jain, India
Date:	Aug 08, 2012, 12:47, 3951 days ago
Score:
Message:	use the split partition strategy. 1. create the temp table with day wise partition 2. move the data from live table to temp table 3. rename the live table to bkp table 4. rename temp table to live table.
Your rating?:	This reply is Good Excellent
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here

---

Subject:	Re: convert table in partition
Author:	Michel Cadot, France
Date:	Aug 08, 2012, 13:05, 3951 days ago
Score:
Message:	Another way: use dbms_redefinition package. Regards Michel
Your rating?:	This reply is Good Excellent
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here

---

Subject:	Re: convert table in partition
Author:	Ravinder Bhalla, United States
Date:	Oct 05, 2012, 19:08, 3892 days ago
Score:
Message:	You can use interval partition to convert the new records falls into daily partitioning, but you old partitions will stay as monthly, alter table orders_tbl SET INTERVAL (NUMTODSINTERVAL(1,'DAY'));
Your rating?:	This reply is Good Excellent
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here