Optional DDL on objects in replication
You can enable the replication of the following DDL when it is issued on objects that are in the configuration file. To enable the replication of a DDL command, set the associated parameter to 1.
DDL command Set this parameter to 1
CREATE / DROP TRIGGER SP_OCT_REPLICATE_TRIGGER
CREATE / DROP SYNONYM SP_OCT_REPLICATE_SYNONYM
GRANT SP_OCT_REPLICATE_GRANT
See the SharePlex Reference Guide for details about these parameters.
SP_OCT_REPLICATE_SYNONYM
This parameter controls whether SharePlex replicates CREATE SYNONYM and DROP SYNONYM commands
that are issued for tables that are listed in the configuration file.
Default: 0 (disabled)
Range of valid values: 0 or 1
Takes effect: when Capture is restarted
SP_OCT_REPLICATE_TRIGGER
This parameter controls whether SharePlex replicates CREATE TRIGGER and DROP TRIGGER commands that
are issued for tables that are listed in the configuration file.
Default: 0 (disabled)
Range of valid values: 0 or 1
Takes effect: when Capture is restarted
SP_OCT_REPLICATE_GRANT
This parameter controls whether SharePlex replicates GRANT commands that are issued for tables that are
listed in the configuration file.
Default: 0 (disabled)
Range of valid values: 0 or 1
Takes effect: when Capture is restarted
[BEGIN] 2017/4/7 17:05:19
sp_ctrl (node1:2100)> exit
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$ clear
[oracle@node1 ~]$ sp_ctrl
*******************************************************
* SharePlex for Oracle Command Utility
* Copyright 2016 Quest Software Inc.
* ALL RIGHTS RESERVED.
* Protected by U.S. Patents: 7,461,103 and 7,065,538
*******************************************************
sp_ctrl (node1:2100)> status
Brief Status for node1
Process State PID Running Since
--------------- ------------------------------ -------- --------------------
Cop Running 2543 07-Apr-17 04:46:09
Capture Running 2551 07-Apr-17 04:46:39
Read Running 2557 07-Apr-17 04:46:42
Export Running 2566 07-Apr-17 04:46:44
Cmd & Ctrl Running 2671 07-Apr-17 05:05:32
System is used as a source machine
There is 1 active configuration file
sp_ctrl (node1:2100)> exit
[oracle@node1 ~]$ ssh node2
oracle@node2's password:
Last login: Fri Apr 7 01:32:43 2017 from node1
[oracle@node2 ~]$ sp_ctrl
*******************************************************
* SharePlex for Oracle Command Utility
* Copyright 2016 Quest Software Inc.
* ALL RIGHTS RESERVED.
* Protected by U.S. Patents: 7,461,103 and 7,065,538
*******************************************************
sp_ctrl (node2:2100)> status
Brief Status for node2
Process State PID Running Since
--------------- ------------------------------ -------- --------------------
Cop Running 2523 07-Apr-17 04:46:21
Import Running 2538 07-Apr-17 04:46:44
Post Running 2524 07-Apr-17 04:46:21
Cmd & Ctrl Running 2587 07-Apr-17 04:56:35
Cmd & Ctrl Running 2670 07-Apr-17 05:05:44
There are no active configuration files
sp_ctrl (node2:2100)>
sp_ctrl (node2:2100)>
sp_ctrl (node2:2100)>
sp_ctrl (node2:2100)> exit
[oracle@node2 ~]$ exit
logout
Connection to node2 closed.
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$ sp_ctrl
*******************************************************
* SharePlex for Oracle Command Utility
* Copyright 2016 Quest Software Inc.
* ALL RIGHTS RESERVED.
* Protected by U.S. Patents: 7,461,103 and 7,065,538
*******************************************************
sp_ctrl (node1:2100)> list param
sp_ctrl (node1:2100)> list param capture
Capture parameters:
Parameter Name Actual Value Units Set At
------------------------------ ------------------------------------ ------- ---------------
SP_OCT_ARCH_LOC Live
SP_OCT_ASM_USE_OCI 0 boolean Restart Process
SP_OCT_AUTOADD_ENABLE 1 boolean Restart Process
SP_OCT_AUTOADD_MVIEW 1 boolean Restart Process
Default Value: 0
SP_OCT_AUTOADD_SEQ 1 boolean Restart Process
Default Value: 0
SP_OCT_BIO_CHECKSUM 0 boolean Live
SP_OCT_CHECKPOINT_LOG 2 logs Live
SP_OCT_DATA_OBJ_CACHE_SIZE 50 values Live
SP_OCT_DATE_MSG 0 Live
SP_OCT_DDL_LOGGING 2 Live
SP_OCT_DEF_DAY 1 Live
SP_OCT_DEF_HOUR 0 Live
SP_OCT_DEF_MIN 0 Live
SP_OCT_DEF_MONTH 1 Live
SP_OCT_DEF_SEC 0 Live
SP_OCT_DEF_YEAR 1999 Live
SP_OCT_DENIED_USERID 0x00000000 number Live
SP_OCT_INCLUDE_UNCHANGED_COL 0 boolean Live
SP_OCT_LOG_MEMBER % Restart Process
SP_OCT_LOGWRAP_RESTART 0 seconds Live
SP_OCT_ONELINE_DEBUG Live
SP_OCT_ONELINE_DEBUG_COLUMNS 0 Live
SP_OCT_OPTIMIZE_ROW_MOVEMENT 0 boolean Live
SP_OCT_PREFER_ARCHIVE 0 boolean Restart Process
SP_OCT_REPLICATE_ALL_DDL 0 Live
SP_OCT_REPLICATE_CTAS 1 Restart Process
SP_OCT_REPLICATE_DDL 3 Live
SP_OCT_REPLICATE_DLOAD 1 Live
SP_OCT_REPLICATE_MVIEW 1 boolean Restart Process
SP_OCT_REPLICATE_POSTER 0 Restart Process
SP_OCT_REPLICATE_SEQUENCES 1 boolean Restart Process
SP_OCT_REQUIRED_DATA_IS_LOGGED 1 Restart Process
SP_OCT_TARGET_COMPATIBILITY 8.6.6 Restart Process
SP_OCT_TRUNC_PARTITION_BY_ID 0 boolean Live
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)> set param SP_OCT_REPLICATE_GRANT 1
sp_ctrl (node1:2100)> set param SP_OCT_REPLICATE_TRIGGER 1
sp_ctrl (node1:2100)> set param SP_OCT_REPLICATE_SYNONYM 1
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)> list param capture
Capture parameters:
Parameter Name Actual Value Units Set At
------------------------------ ------------------------------------ ------- ---------------
SP_OCT_ARCH_LOC Live
SP_OCT_ASM_USE_OCI 0 boolean Restart Process
SP_OCT_AUTOADD_ENABLE 1 boolean Restart Process
SP_OCT_AUTOADD_MVIEW 1 boolean Restart Process
Default Value: 0
SP_OCT_AUTOADD_SEQ 1 boolean Restart Process
Default Value: 0
SP_OCT_BIO_CHECKSUM 0 boolean Live
SP_OCT_CHECKPOINT_LOG 2 logs Live
SP_OCT_DATA_OBJ_CACHE_SIZE 50 values Live
SP_OCT_DATE_MSG 0 Live
SP_OCT_DDL_LOGGING 2 Live
SP_OCT_DEF_DAY 1 Live
SP_OCT_DEF_HOUR 0 Live
SP_OCT_DEF_MIN 0 Live
SP_OCT_DEF_MONTH 1 Live
SP_OCT_DEF_SEC 0 Live
SP_OCT_DEF_YEAR 1999 Live
SP_OCT_DENIED_USERID 0x00000000 number Live
SP_OCT_INCLUDE_UNCHANGED_COL 0 boolean Live
SP_OCT_LOG_MEMBER % Restart Process
SP_OCT_LOGWRAP_RESTART 0 seconds Live
SP_OCT_ONELINE_DEBUG Live
SP_OCT_ONELINE_DEBUG_COLUMNS 0 Live
SP_OCT_OPTIMIZE_ROW_MOVEMENT 0 boolean Live
SP_OCT_PREFER_ARCHIVE 0 boolean Restart Process
SP_OCT_REPLICATE_ALL_DDL 0 Live
SP_OCT_REPLICATE_CTAS 1 Restart Process
SP_OCT_REPLICATE_DDL 3 Live
SP_OCT_REPLICATE_DLOAD 1 Live
SP_OCT_REPLICATE_MVIEW 1 boolean Restart Process
SP_OCT_REPLICATE_POSTER 0 Restart Process
SP_OCT_REPLICATE_SEQUENCES 1 boolean Restart Process
SP_OCT_REQUIRED_DATA_IS_LOGGED 1 Restart Process
SP_OCT_TARGET_COMPATIBILITY 8.6.6 Restart Process
SP_OCT_TRUNC_PARTITION_BY_ID 0 boolean Live
sp_ctrl (node1:2100)> status
Brief Status for node1
Process State PID Running Since
--------------- ------------------------------ -------- --------------------
Cop Running 2543 07-Apr-17 04:46:09
Capture Running 2551 07-Apr-17 04:46:39
Read Running 2557 07-Apr-17 04:46:42
Export Running 2566 07-Apr-17 04:46:44
Cmd & Ctrl Running 2674 07-Apr-17 05:05:52
System is used as a source machine
There is 1 active configuration file
sp_ctrl (node1:2100)> stop capture
sp_ctrl (node1:2100)> stop read
sp_ctrl (node1:2100)> stop export
sp_ctrl (node1:2100)> start export
sp_ctrl (node1:2100)> start read
sp_ctrl (node1:2100)> start capture
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)> status
Brief Status for node1
Process State PID Running Since
--------------- ------------------------------ -------- --------------------
Cop Running 2543 07-Apr-17 04:46:09
Capture Running 2689 07-Apr-17 05:09:50
Read Running 2688 07-Apr-17 05:09:47
Export Running 2687 07-Apr-17 05:09:45
Cmd & Ctrl Running 2674 07-Apr-17 05:05:52
System is used as a source machine
There is 1 active configuration file
sp_ctrl (node1:2100)> list param
Analyze parameters:
Parameter Name Actual Value Units Set At
------------------------------ ------------------------------------ ------- ---------------
SP_ANL_CHECKPOINT_FREQ 20000 message Live
SP_ANL_CHECKPOINT_TIME 120 seconds Live
SP_ANL_LOG_FILESIZE 50000000 bytes Restart Process
SP_ANL_LOG_NUMFILES 3 number Restart Process
SP_ANL_RUN_TIME 4320 number Live
Command and Control parameters:
Parameter Name Actual Value Units Set At
------------------------------ ------------------------------------ ------- ---------------
SP_CNC_COMM_TIMEOUT 0 minutes Live
SP_CNC_LOG 0 number Live
Control Process parameters:
Parameter Name Actual Value Units Set At
------------------------------ ------------------------------------ ------- ---------------
SP_COP_IDLETIME 60 seconds Live
SP_COP_SCAN_TIMEOUT 300 seconds Live
SP_COP_SO_RCVBUF 0 bytes Restart Cop
Compare/Repair parameters:
Parameter Name Actual Value Units Set At
------------------------------ ------------------------------------ ------- ---------------
SP_DEQ_AUTO_REPAIR1 1 boolean Live
SP_DEQ_COPY_CHECK_ROWS 200000 Live
SP_DEQ_IGNORE_ORACLE_ERROR_NUM 0 number Live
SP_DEQ_IP_MAPPING Live
SP_DEQ_IP_MAPPING_OPTION 1 number Live
SP_DEQ_LOCK_WAIT 300 seconds Live
SP_DEQ_LOG_FILESIZE 50 MB Live
SP_DEQ_LOG_NUMFILES 3 number Live
SP_DEQ_MALLOC 500 MB Live
SP_DEQ_PADDER 0 number Live
SP_DEQ_PARALLELISM 2 number Live
SP_DEQ_PART_TABLE_UPDATE 0 number Live
SP_DEQ_PARTIAL_REPAIR_CLR_OOS 0 boolean Live
SP_DEQ_QUICK_COMPARE_DEFAULT 0 boolean Live
SP_DEQ_READ_BUFFER_SIZE 1 mbytes Live
SP_DEQ_ROW_LOCK_THRESHOLD 1000 number Live
SP_DEQ_SKIP_LOB 0 boolean Live
SP_DEQ_SWAP_BYTE 0 number Live
SP_DEQ_THREADS 2 threads Live
SP_DEQ_TIMEOUT 1800 seconds Live
Import parameters:
Parameter Name Actual Value Units Set At
------------------------------ ------------------------------------ ------- ---------------
SP_IMP_QUEUE_PAUSE 0 Kmsgs Live
SP_IMP_QUEUE_RESUME 0 Kmsgs Live
Configuration Management parameters:
Parameter Name Actual Value Units Set At
------------------------------ ------------------------------------ ------- ---------------
SP_OCF_FK_ANALYSIS 1 boolean Live
SP_OCF_HEAP_NEWLIST 0 boolean Live
SP_OCF_LOCK_WAIT_TIME 5 minutes Live
SP_OCF_LOG_FILESIZE 50000000 bytes Live
SP_OCF_LOG_NUMFILES 3 number Live
SP_OCF_THREAD_COUNT 3 threads Live
SP_OCF_USE_TEMPSEG_LIMIT 100 tables Live
Capture parameters:
Parameter Name Actual Value Units Set At
------------------------------ ------------------------------------ ------- ---------------
SP_OCT_ARCH_LOC Live
SP_OCT_ASM_USE_OCI 0 boolean Restart Process
SP_OCT_AUTOADD_ENABLE 1 boolean Restart Process
SP_OCT_AUTOADD_MVIEW 1 boolean Restart Process
Default Value: 0
SP_OCT_AUTOADD_SEQ 1 boolean Restart Process
Default Value: 0
SP_OCT_BIO_CHECKSUM 0 boolean Live
SP_OCT_CHECKPOINT_LOG 2 logs Live
SP_OCT_DATA_OBJ_CACHE_SIZE 50 values Live
SP_OCT_DATE_MSG 0 Live
SP_OCT_DDL_LOGGING 2 Live
SP_OCT_DEF_DAY 1 Live
SP_OCT_DEF_HOUR 0 Live
SP_OCT_DEF_MIN 0 Live
SP_OCT_DEF_MONTH 1 Live
SP_OCT_DEF_SEC 0 Live
SP_OCT_DEF_YEAR 1999 Live
SP_OCT_DENIED_USERID 0x00000000 number Live
SP_OCT_INCLUDE_UNCHANGED_COL 0 boolean Live
SP_OCT_LOG_MEMBER % Restart Process
SP_OCT_LOGWRAP_RESTART 0 seconds Live
SP_OCT_ONELINE_DEBUG Live
SP_OCT_ONELINE_DEBUG_COLUMNS 0 Live
SP_OCT_OPTIMIZE_ROW_MOVEMENT 0 boolean Live
SP_OCT_PREFER_ARCHIVE 0 boolean Restart Process
SP_OCT_REPLICATE_ALL_DDL 0 Live
SP_OCT_REPLICATE_CTAS 1 Restart Process
SP_OCT_REPLICATE_DDL 3 Live
SP_OCT_REPLICATE_DLOAD 1 Live
SP_OCT_REPLICATE_MVIEW 1 boolean Restart Process
SP_OCT_REPLICATE_POSTER 0 Restart Process
SP_OCT_REPLICATE_SEQUENCES 1 boolean Restart Process
SP_OCT_REQUIRED_DATA_IS_LOGGED 1 Restart Process
SP_OCT_TARGET_COMPATIBILITY 8.6.6 Restart Process
SP_OCT_TRUNC_PARTITION_BY_ID 0 boolean Live
Post parameters:
Parameter Name Actual Value Units Set At
------------------------------ ------------------------------------ ------- ---------------
SP_OPO_CHANGE_ID_START_VALUE Restart Process
SP_OPO_CONT_ON_ERR 0 Live
SP_OPO_DISABLE_OBJECT_NUM Live
SP_OPO_HINTS_LIMIT 100 hints Restart Process
SP_OPO_MAX_CDA 50 Restart Process
SP_OPO_ONELINE_DEBUG Live
SP_OPO_ONELINE_DEBUG_COLUMNS 0 Live
SP_OPO_OUT_OF_SYNC_SUSPEND 0 Live
SP_OPO_PARSE_TIMEOUT 100 msec Live
SP_OPO_POSTER_DELAY 0 minutes Live
SP_OPO_PRB_MISMATCH_SUSPEND 0 Live
SP_OPO_QUE_REREAD_INTERVAL 1 seconds Live
SP_OPO_READRELEASE_INTERVAL 100 Live
SP_OPO_RETRIES_MAX 10 retries Live
SP_OPO_SKIP_BAD_MESSAGE 0 Live
SP_OPO_SKIP_FAIL_DDL_ON_RESTAR 1 Restart Process
SP_OPO_SQL_CACHE_DISABLE 0 Restart Process
SP_OPO_STOP_ON_DDL_ERR 1 Live
SP_OPO_SYNC_LOG_FREQUENCY 1 Live
SP_OPO_SYNC_STATUS_TIMEOUT 180 Seconds Live
SP_OPO_TRACK_COMMITS 0 Restart Process
SP_OPO_TRACK_OPERATIONS I/U/D Restart Process
SP_OPO_TRACK_PREIMAGE Restart Process
SP_OPO_TRACK_TIME_AS_CHAR 0 Restart Process
SP_OPO_TRUSTED_SOURCE Restart Process
SP_OPO_WAIT_MSG_DELAY 300 seconds Restart Process
Open Post parameters:
Parameter Name Actual Value Units Set At
------------------------------ ------------------------------------ ------- ---------------
SP_OPX_CONT_ON_ERR 0 Live
SP_OPX_DEBUG_FLAG 0x00000000 bitflag Live
SP_OPX_DISABLE_OBJECT_NUM Live
SP_OPX_LOG_FILESIZE 50000000 bytes Restart Process
SP_OPX_LOG_NUMFILES 3 number Restart Process
SP_OPX_MAX_CDA 0 Restart Process
SP_OPX_ONELINE_DEBUG Live
SP_OPX_OUT_OF_SYNC_SUSPEND 0 Live
SP_OPX_READRELEASE_INTERVAL 1000 Restart Process
SP_OPX_SQL_CACHE_DISABLE 0 Restart Process
Read parameters:
Parameter Name Actual Value Units Set At
------------------------------ ------------------------------------ ------- ---------------
SP_ORD_DATE_MSG 0 Live
SP_ORD_DELAY_RECORDS 200 records Live
SP_ORD_DISABLE_OBJECT_NUM Live
SP_ORD_FILTER_OPEN_TGT_DDL 1 Restart Process
SP_ORD_FIRST_FIND 1 Restart Process
SP_ORD_HP_HASH 16 slots Restart Process
SP_ORD_HP_IN_SYNC 0 Restart Process
SP_ORD_ONELINE_DEBUG Live
SP_ORD_ONELINE_DEBUG_COLUMNS 0 Live
SP_ORD_SEND_DDL_TO_FIRST 1 Live
Sync parameters:
Parameter Name Actual Value Units Set At
------------------------------ ------------------------------------ ------- ---------------
SP_OSY_COMPRESSION 6 Live
SP_OSY_LOCK_TIMEOUT 2 Seconds Live
SP_OSY_POST_TIMEOUT 1800 Seconds Live
SP_OSY_THREADS 5 Thread Live
SharePlex Queues parameters:
Parameter Name Actual Value Units Set At
------------------------------ ------------------------------------ ------- ---------------
SP_QUE_MAX_QUEUES 25 queues Restart Cop
SP_QUE_POST_SHMSIZE 32 Mbytes Restart Cop
SP_QUE_Q_SHMSIZE 8 Mbytes Restart Cop
SP_QUE_SHMDBUF 32768 bytes Restart Cop
SP_QUE_SYNC 2 Restart Cop
Event Logging parameters:
Parameter Name Actual Value Units Set At
------------------------------ ------------------------------------ ------- ---------------
SP_SLG_LOG_MAXSIZE 500 mbytes Restart Cop
SP_SLG_SNMP_ACTIVE 0 Restart Cop
SP_SLG_SNMP_COMMUNITY Restart Cop
SP_SLG_SNMP_ENTERPRISE_OID 1.3.6.1.4.1.3.1.1 Restart Cop
SP_SLG_SNMP_ERROR 0 Restart Cop
SP_SLG_SNMP_EXIT 0 Restart Cop
SP_SLG_SNMP_HOST Restart Cop
SP_SLG_SNMP_INT_ERROR 0 Restart Cop
SP_SLG_SNMP_LAUNCH 0 Restart Cop
SP_SLG_SNMP_MJR_ERRNUM 0 Restart Cop
SP_SLG_SNMP_MNR_ERRNUM 0 Restart Cop
SP_SLG_SNMP_OUT_OF_SYNC 0 Restart Cop
SP_SLG_SNMP_SHUTDOWN 0 Restart Cop
SP_SLG_SNMP_STARTUP 0 Restart Cop
SP_SLG_SNMP_SYS_ERROR 0 Restart Cop
SP_SLG_SNMP_TRAP_OID 1.3.6.1.2.1.1.1.0 Restart Cop
SP_SLG_SNMP_TRAP_PROGRAM iwsnmptrap Restart Cop
System parameters:
Parameter Name Actual Value Units Set At
------------------------------ ------------------------------------ ------- ---------------
SP_SYS_API_KEY 300d8d80-1aca-11e7-9129-091566695250 Live
SP_SYS_HOST_NAME Restart Cop
SP_SYS_JOB_HISTORY_RETENTION 90 days Live
SP_SYS_LIC_25614 CN0DW1WAVEJG3NCMC4647K0YMEB0SXBJYW:X Install
SP_SYS_SUSPEND_ON_ERROR 1 Live
SP_SYS_VAR_FULL 30 mbytes Live
SP_SYS_VAR_OK 50 mbytes Live
Export parameters:
Parameter Name Actual Value Units Set At
------------------------------ ------------------------------------ ------- ---------------
SP_XPT_AES_KEY_LENGTH 128 Restart Process
SP_XPT_ALTERNATE_HOST Restart Process
SP_XPT_ENABLE_AES 0 Restart Process
SP_XPT_ENABLE_COMPRESSION 0 Restart Process
SP_XPT_PCT_DEVIATION 50 Live
SP_XPT_PORT_OVERRIDE 0 Restart Process
SP_XPT_SO_SNDBUF 0 bytes Restart Process
SP_XPT_USE_LOCALHOST 0 Restart Process
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)> exit
[oracle@node1 ~]$ sqlplus source/source
SQL*Plus: Release 11.2.0.4.0 Production on Fri Apr 7 05:10:38 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
SQL>
SQL> select tname from tab;
TNAME
------------------------------
MV_CUSTMER
T1
T3
USLOG$_MV_CUSTMER
SQL> create synonym tt1 for t1;
Synonym created.
SQL> CREATE TABLE Emp_log (
Emp_id NUMBER,
Log_date DATE,
New_salary NUMBER,
Action VARCHAR2(20)); 2 3 4 5
Table created.
SQL> create table employees( emp_id number,log_data date,salary number);
Table created.
SQL> CREATE OR REPLACE TRIGGER log_salary_increase
AFTER UPDATE OF salary ON employees
FOR EACH ROW
BEGIN
INSERT INTO Emp_log (Emp_id, Log_date, New_salary, Action)
VALUES (:NEW.employee_id, SYSDATE, :NEW.salary, 'New Salary');
END;
/ .
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@node1 ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.4.0 Production on Fri Apr 7 05:19:01 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
SQL> grant select on source.t1 to scott;
Grant succeeded.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@node1 ~]$ ssh node2
oracle@node2's password:
Last login: Fri Apr 7 05:05:41 2017 from node1
[oracle@node2 ~]$ sp_ctrl
*******************************************************
* SharePlex for Oracle Command Utility
* Copyright 2016 Quest Software Inc.
* ALL RIGHTS RESERVED.
* Protected by U.S. Patents: 7,461,103 and 7,065,538
*******************************************************
sp_ctrl (node2:2100)> status
Brief Status for node2
Process State PID Running Since
--------------- ------------------------------ -------- --------------------
Cop Running 2523 07-Apr-17 04:46:21
Post Running 2972 07-Apr-17 05:27:34
Import Running 2677 07-Apr-17 05:09:45
Cmd & Ctrl Running 2989 07-Apr-17 05:28:47
Cmd & Ctrl Running 3025 07-Apr-17 05:30:18
There are no active configuration files
sp_ctrl (node2:2100)> show sql
Last SQL statement of queue node1 and instance o.orcl-o.orcl on node2
Thread Session
------ -------
0 0
/
Thread is initializing : No SQL available yet.
Thread Session
------ -------
2 3
/
grant delete on "TARGET"."T1" to source
Thread Session
------ -------
3 8
/
grant select on "TARGET"."T1" to scott
[oracle@node1 ~]$ sqlplus source/source
SQL*Plus: Release 11.2.0.4.0 Production on Fri Apr 7 05:41:15 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select tname from tab;
TNAME
------------------------------
EMPLOYEES
EMP_LOG
MV_CUSTMER
T1
T3
TT1
USLOG$_MV_CUSTMER
7 rows selected.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@node1 ~]$ ssh node2
oracle@node2's password:
Last login: Fri Apr 7 05:30:16 2017 from node1
[oracle@node2 ~]$ sqlplus target/target
SQL*Plus: Release 11.2.0.4.0 Production on Fri Apr 7 05:41:43 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select tname from tab;
TNAME
------------------------------
EMPLOYEES
EMP_LOG
MV_CUSTMER
T1
T3
TT1
6 rows selected.
SQL>
[END] 2017/4/7 17:32:19
|
|
京ICP备12024223-8号
不良信息举报电话：13718043309
转播
分享
淘帖