Multidomain MDM
- Multidomain MDM 10.4 HotFix 3
- All Products
ALTER SYSTEM SET enable_goldengate_replication=true;
spool nologging.sql set pagesize 5000 select 'ALTER TABLE ' || TABLE_NAME || ' LOGGING;' from user_tables where LOGGING != 'YES' and TABLE_NAME like 'C^_%' ESCAPE '^'; exit
SQL> @nologgging.sql
UPDATE C_REPOS_TABLE SET NOLOGGING_IND = 0 WHERE NOLOGGING_IND = 1 and table_name != 'C_RBO_CLASS' and table_name != 'C_RBO_HIERARCHY' and table_name != 'C_RBO_REL_TYPE';
C:> sqlplus connect sys as sysdba; SQL> -- make sure you had previously shutdown normally SQL> STARTUP MOUNT; SQL> ALTER DATABASE ARCHIVELOG; SQL> ALTER DATABASE OPEN; SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA; SQL> ALTER SYSTEM SWITCH LOGFILE; SQL> EXIT
grant create session, connect, resource, dba to ggadmin; grant select any dictionary to ggadmin; grant create view to ggadmin; grant execute on dbms_lock to ggadmin; exec dbms_goldengate_auth.grant_admin_privilege ('GGADMIN'); grant flashback any table to ggadmin;