Re: Import Problem

with out hanging how to open data script of the oracle schema to change the
name.

On Thu, Sep 17, 2015 at 6:31 PM, Ramesh T <rameshparnanditech(at)gmail(dot)com>
wrote:

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