-
Title
Which object id needs to be specified for partitioned tables in situations like configuring SP_OP -
Description
There are times when it is required to specify the object_id of the source table in replication. Two of the most common scenario are dumping object cache on the basis of object_id and disabling posting on a target table. This solution delves on which object id needs to be specified when the source table in question is a partitioned table.
 -
Cause
General information.
-
Resolution
When the source table is partitioned, there are two types of object_id associated with it, namely OBJECT_ID and DATA_OBJECT_ID. The former is data dictionary object number of the object and the latter is the data dictionary object number of the segment (partition) that contains the object. Shareplex uses the value of OBJECT_ID field.
 -
Additional Information
The DBA data dictionary view DBA_OBJECTS contains details on the object name, object type, object id, etc.
Ã