- October 1, 2019 at 1:20 pm #23234
I was trying to migrate data from oracle database to greenplum database, but while preforming HVR refresh for replication of tables from oracle to greenplum, HVR is moving them into a different schema,I want my tables to move to a specific target schema. How to achieve it?
Thanks in AdvanceOctober 1, 2019 at 1:32 pm #23235PallavikKeymaster
You can use TableProperties/Schema=<schemaName> to do that.
Please refer this link https://www.hvr-software.com/docs/actions/tableproperties
Hope this helps!
PKOctober 3, 2019 at 1:19 am #23267
Thanks for the reply but that’s not working
let me explain the scenario.
I’m taking tables from ‘X’ schema from oracle and while trying to refresh into Greenplum, HVR is looking for X schema in Greenplum.
But i wanted to move into ‘Y’ schema
I tried to change the schema to ‘y’ in table properties and another error popped up as conflict among schema’s
But the documentation which you sent says the schema operation differently
“”Name of database schema or user which owns the base table””. By default, the base table is assumed to be owned by the database username that HVR uses to connect to the database.”October 3, 2019 at 1:20 am #23268
please help me outOctober 3, 2019 at 7:31 am #23269AdamJParticipant
It looks like you would need to set the /Schema TableProperties twice. Once for your Source (ORACLE), and once for your Target (GREEN).
See my pseudo example below:
ora_green ORACLE * * TableProperties /Schema=X
ora_green ORACLE * * Capture
ora_green GREEN * * TableProperties /Schema=Y
ora_green GREEN * * Integrate
- You must be logged in to reply to this topic.