Re: Import Problem

Actually ,oracle have the *qa *schema i have to import to this schema to
postgres database.But in postgres database already have the *qa *schema.My
problem is that i want to change the name of the oracle schema while import
to the postgres database using or2pg.because same schema name not accept
right.manullay is not possible change name of schema in qa is have 2 gb
data when i try to change name of the data scipt is hanged.

On Thu, Sep 17, 2015 at 11:54 AM, Venkata Balaji N <nag1010(at)gmail(dot)com>
wrote:

>
> On Thu, Sep 17, 2015 at 1:27 AM, Ramesh T <rameshparnanditech(at)gmail(dot)com>
> wrote:
>
>> Hi All,
>> I'm using or2pg tool ,I exported data but I have to change the
>> schema import to postgres database.exported data more than gb.
>> Can you please let me know, how to do the change the name in data
>> script..?
>>
>
> Do you mean that, you want import the data into a different schema in
> postgres ? Where do you want to change the name ?
>
> If i understand your question correctly, there is an schema option in
> ora2pg.conf which might help you.
>
> Regards,
> Venkata B N
>
> Fujitsu Australia
>