Chat now with support
Chat with Support

SharePlex 8.6.6 - Administration Guide

About this Guide Conventions used in this guide Overview of SharePlex Run SharePlex Run multiple instances of SharePlex Execute commands in sp_ctrl SharePlex parameters Prepare an Oracle environment for replication Create a configuration file Configure replication to Open Target targets Configure a replication strategy Configure partitioned replication Configure named queues Configure SharePlex to maintain a change history target Replicate Oracle DDL Set up error handling Transform data Configure SharePlex security features Activate replication in your production environment Monitor SharePlex Prevent and solve replication problems Repair out-of-sync Data Procedures to maintain Oracle high availability Make changes to an active replication environment Apply an Oracle application patch or upgrade Back up Oracle data on the source or target Tune the Capture process Tune the Post process Appendix A: Peer-To-Peer Diagram Appendix B: SharePlex environment variables

report

Use this command to display the copy/append history for a table.

Usage

Supported targets: Oracle
Authorization level: Viewer (3)
Issued for: source system
Related commands: copy/append

Syntax

Basic command Command options Remote options
report

source_owner.source_table

[copy | append]

[toeditor]

[for o.source_sid]

[ on host |

on host:portnumber |

on login/password@host |

on login/password@host:portnumber ]

Syntax Description

Component Description
source_owner.source_table

This option specifies a source table for the synchronization report. Allow no spaces between components of the source owner and table name.

Examples:

sp_ctrl(SysA)> report s_user1.sync_single_tbl

copy | append

This option returns results specific to either copy or append.

Examples:

sp_ctrl(SysA)> report copy s_user1.sync_single_tbl

sp_ctrl(SysA)> report append s_user1.sync_single_tbl

toeditor

This option sets the target.

Examples:

sp_ctrl(SysA)> report s_user1.sync_single_tbl toeditor

sp_ctrl(SysA)> report copy s_user1.sync_single_tbl toeditor

for o.source_sid

This option is used for specifying results specific to the provided source SID.

Examples:

sp_ctrl(SysA)> report s_user1.sync_single_tbl for o.source_sid1

sp_ctrl(SysA)> report copy s_user1.sync_single_tbl for o.source_sid1

Remote options

These options enable you to issue the command on a remote machine and to script commands that include a login name, password, port number, or combination of those items.

Option Description
on host

Execute the command on a remote system (one other than the one where the current sp_ctrl session is running). You are prompted for login credentials for the remote system. If used, must be the last component of the command syntax.

Example: sp_ctrl(sysB)>status on SysA

on host:portnumber

Execute the command on a remote system when a remote login and port number must be provided. If used, must be the last component of the command syntax.

Example: sp_ctrl(sysB)>status on SysA:8304

on login/password@host

Execute the command on a remote system when a remote login, password, and host name must be provided. If used, must be the last component of the command syntax.

Example: sp_ctrl(sysB)>status on john/spot5489@SysA

on login/password@host:portnumber

Execute the command on a remote system when a remote login, password, host name, and port number must be provided. If used, must be the last component of the command syntax.

Example: sp_ctrl(sysB)>status on john/spot5489@SysA:8304

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating