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



Use the edit command in the following ways:

  • To make changes to a SharePlex command that you previously issued. This saves time when you need to issue a command again, but with slightly different syntax, or if you need to correct a syntax mistake.
  • To execute commands that contain more than 255 characters, a limitation of the operating system.

The edit command opens a temporary text file in the default text editor from within the sp_ctrl interface. You enter the command in the file, and it automatically executes when you save the file.

To use the edit command

  1. If no commands were issued previously in the current session of sp_ctrl, type the first word of the command at the sp_ctrl prompt, then press Enter. Otherwise, skip this step. (Ignore the online help or error that is displayed.)
  2. At the sp_ctrl prompt, issue the edit command to open a temporary text file.

    sp_ctrl(sysA)> edit

  3. In the text file, use the editor’s standard commands to edit out any unwanted characters and type the command string.
  4. Save and exit out of the file using the editor’s standard save command. The command executes immediately

Note: SharePlex provides keyboard shortcuts for the edit command in the for of the up arrow (  ) and the forward slash ( / ) keys.


Supported targets: All
Authorization level: The user must have the previous command’s authorization level or higher.
Issued for: The system affected by the previous command
Related commands: none


Basic command Remote options
edit | ed not available
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating