How to Migrate data to a specific Schema??

  • This topic is empty.
Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • #23234
    Anonymous
    Inactive

    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

    #23235
    Pallavik
    Keymaster

    Hi Mohammad,

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

    Please refer this link https://www.hvr-software.com/docs/actions/tableproperties

    Hope this helps!

    Thanks

    PK

    #23267
    Anonymous
    Inactive

    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
    “/Schema

    schema

    “”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.”

    #23268
    Anonymous
    Inactive

    please help me out

    #23269
    AdamJ
    Participant

    Mohammad,

    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

    Adam

Viewing 5 posts - 1 through 5 (of 5 total)
  • You must be logged in to reply to this topic.
Test drive
Contact us