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 <rameshparnandit...@gmail.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 <nag1...@gmail.com> > wrote: > >> >> On Thu, Sep 17, 2015 at 1:27 AM, Ramesh T <rameshparnandit...@gmail.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 >> > >
