We have seen creation of partitions , its benefits , different methods etc. Today we will see method to check the records we are inserting in the partitioning table are placed properly in intended partitions.

Let’s create one table using range partitioning method. 

Let us insert some random records in table.

Now lets query the table with partitioning details. Using DBMS_ROWID.ROWID_OBJECT function we can get the object_id of table partition from rowid column of table. And subobject_name of dba_objects stores table partition name.

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.