Re: Import Problem

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(at)gmail(dot)com
> <mailto: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 <mailto:nag1010(at)gmail(dot)com>> wrote:
>
>
> On Thu, Sep 17, 2015 at 1:27 AM, Ramesh T
> <rameshparnanditech(at)gmail(dot)com
> <mailto: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
>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com