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