Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

exclude add partition

RobeenDec 13 2020

Oracle DB 12.1.0.2
Solaris 11
Striim as ETL tool (GG trail Reader)
Hello Team,

we are doing replication from Oracle to Kudu. DDl replication is not supported from Oracle to Kudu since they are heterogeneous env. Otherwise replication will result in error.

I have added the following parameter in the extract.

EXTRACT EXTDWH
USERIDALIAS oggscb_dwh
DDL INCLUDE MAPPED &
EXCLUDE OPTYPE ALTER OBJTYPE 'TABLE' INSTR 'ADD PARTITION'

Do you think it is a good option?

Thanks,

Roshan

This post has been answered by Robeen on Dec 15 2020
Jump to Answer

Comments

beyerch2
How do you know everything is working ok? Did you run the EPM System Diagnostics Validation test or just confirm that the install completed?

The Diagnostics Validation test will run a set of tests to confirm proper operation of the environment.
Oracle EPM System
Diagnostics
Generated on 05/10/2012 11:16 AM
Validation run on XXXXyour server nameXXXX
EPM System Diagnostics info: 11.1.2.1.0 drop 36-0 build 6321-on-03/01/2011 06:48 AM
Build version: 11.1.2.1.0.6765
OS name: Windows Server 2008 R2
OS version: 6.1

Test Status	Service	Test Description	Duration
Hyperion Foundation			
PASSED	CFG: Configuration	Validating that configuration tasks have been completed	0 seconds
PASSED	DB: Database Connectivity	Checking connection to database jdbc:weblogic:sqlserver://XXXXyouservernameXXXX:1433;databaseName=HYPv11Foundation	0 seconds
PASSED	EXT: External Authentication	Check Native Directory external authentication provider configuration	0 seconds

etc 
etc
etc
You can run this program on a product by product basis or on all of the products installed on a server at one time.

Execute the validate.bat program from the following folder : <MIDDLEWARE HOME>\user_projects\epmsystem1\bin

Reports will be stored at : <MIDDLEWARE HOME>\users_projects\epmsystem1\diagnostics\reports

NOTE: epmsystem1 may not be the folder name as this was specified during your install. epmsystem1 should be the default name.
1 - 1

Post Details

Added on Dec 13 2020
5 comments
412 views