How to ignore posting for a particular object in an Open Target environment.
The Open Target environment allows for disabling posting on particular objects, just as it is done in an Oracle target environment. This is all the more handy in such environment as some objects or datatype from the source database may not be supported in a heterogeneous environment involving a different type of target database, say Oracle to SQL server. There are other reasons that may necessitate the use of such feature. The feature allows ignoring one or more objects for posting. To ignore posting on one object on target, you can get the object_id for the object in question from source database configure the parameter on target sp_ctrl as below (note how OPO in case of Oracle target is substituted by OPX in Open Target):
sp_ctrl>set param sp_opx_disable_object_num <object_id from source database for the object to be disabled>
sp_ctrl>stop post
sp_ctrl>start post
If, at a later time, wishing to undo the above change, carry out the following steps:
sp_ctrl>reset param sp_opx_disable_object_num
sp_ctrl>stop post
sp_ctrl>start post
© 2022 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy