Re: [GENERAL] Import Problem

2015-09-17 Thread Adrian Klaver
On 09/17/2015 06:03 AM, Ramesh T wrote: with out hanging how to open data script of the oracle schema to change the name. Like Postgres, or2pg has documentation: http://ora2pg.darold.net/config.html#oracle_schema_to_export On Thu, Sep 17, 2015 at 6:31 PM, Ramesh T mailto:rameshparnandit...@

Re: [GENERAL] Import Problem

2015-09-17 Thread Ramesh T
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 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

Re: [GENERAL] Import Problem

2015-09-17 Thread Ramesh T
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 r

Re: [GENERAL] Import Problem

2015-09-16 Thread Venkata Balaji N
On Thu, Sep 17, 2015 at 1:27 AM, Ramesh T 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

Re: [GENERAL] Import Problem

2015-09-16 Thread Rob Sargent
On 09/16/2015 09:27 AM, Ramesh T 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..? sed is your friend, if you have a

[GENERAL] Import Problem

2015-09-16 Thread Ramesh T
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..?