SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Table Partitioning Dynamically

NTRFeb 2 2015 — edited Feb 2 2015

Hi All,

I am using Oracle Database 12c Release 12.1.0.1.0 - 64bit.

I want to create partition dynamically using interval partion. It means based on the system timestamp it has to create the multiple partition dynamically.

Ex:

1. If a table has data for same day with different timestamp, then i have to have different partitioning for different timestamp.

2. If i want to truncate the older timestamp for the same day, then it will be easy to do that.

Timestamp	Partition
30/01/2015 7:30:00	P1
30/01/2015 8:30:00	P2
30/01/2015 10:30:00	P3

Thanks in advanvce.

Regards,

NTR

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 2 2015

Added on Feb 2 2015

2 comments

3,180 views