How to Migrate data to a specific Schema??

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
  • #23234

    Hi Everyone,
    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 Advance


    Hi Mohammad,

    You can use TableProperties/Schema=<schemaName> to do that.

    Please refer this link

    Hope this helps!




    Hi Pallavik,
    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.”


    please help me out



    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


    • This reply was modified 6 months ago by AdamJ.
    • This reply was modified 6 months ago by AdamJ.
Viewing 5 posts - 1 through 5 (of 5 total)
  • You must be logged in to reply to this topic.

© 2020 HVR

Test drive Contact us