Oracle Database Discussions

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!

To know partition name in range partition table

944524Jan 5 2016 — edited Jan 5 2016

Hi,

is there a way to indetify the partition name i.e SYS_PXXXX name for a table which has range partition without inserting a record in that table . My table T1 has range parition on date column which is of one day interval duration, hence wanted to know which partition name it will go. For eg.

date_col

I know that i am going to insert in T1 with date_col as 01-JUL-2015 of 1000 records. How will i know which partition name oracle will decide

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 2 2016

Added on Jan 5 2016

#general-database-discussions

6 comments

5,184 views