Postgres Pro
Downloads
Home   >   mailing lists

Thread: Import Problem

Import Problem

From
Ramesh T
Date:
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..?

Re: Import Problem

From
Rob Sargent
Date:
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 ascii data.

Re: Import Problem

From
Venkata Balaji N
Date:

On Thu, Sep 17, 2015 at 1:27 AM, Ramesh T <rameshparnanditech@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

Re: Import Problem

From
Ramesh T
Date:
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@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 <nag1010@gmail.com> wrote:

On Thu, Sep 17, 2015 at 1:27 AM, Ramesh T <rameshparnanditech@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


Re: Import Problem

From
Ramesh T
Date:
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@gmail.com> wrote:

On Thu, Sep 17, 2015 at 1:27 AM, Ramesh T <rameshparnanditech@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

Re: Import Problem

From
Adrian Klaver
Date:
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 <rameshparnanditech@gmail.com
> <mailto:rameshparnanditech@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
>     <nag1010@gmail.com <mailto:nag1010@gmail.com>> wrote:
>
>
>         On Thu, Sep 17, 2015 at 1:27 AM, Ramesh T
>         <rameshparnanditech@gmail.com
>         <mailto:rameshparnanditech@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
>
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com