Re: [GENERAL] oracle_fdw with oracle os authentication

2012-10-29 Thread Albe Laurenz
[added CC to oracle-fdw-general, where this should be] Papiernik Anna-AAP053 wrote: > I have Oracle with OS authentication. > > And I have installed PostgreSQL and I want to migrate data from Oracle to PostgreSQL database. > > > > I have performed steps: > > CREATE EXTENSION oracle_fdw; > >

Re: [GENERAL] oracle_fdw with oracle os authentication

2012-10-24 Thread Xiong He
rnik Anna-AAP053"; Date: Tue, Oct 23, 2012 06:07 PM To: "pgsql-general@postgresql.org"; Subject: [GENERAL] oracle_fdw with oracle os authentication I have Oracle with OS authentication. And I have installed PostgreSQL and I want to migrate data from Oracle to PostgreSQ

[GENERAL] oracle_fdw with oracle os authentication

2012-10-23 Thread Papiernik Anna-AAP053
I have Oracle with OS authentication. And I have installed PostgreSQL and I want to migrate data from Oracle to PostgreSQL database. I have performed steps: CREATE EXTENSION oracle_fdw; CREATE SERVER oradb FOREIGN DATA WRAPPER oracle_fdw OPTIONS (dbserver ''); GRANT USAGE ON FOREIGN SERVER oradb

[GENERAL] oracle_fdw with oracle os authentication

2012-10-23 Thread Papiernik Anna-AAP053
Hi I have Oracle with OS authentication. And I have installed PostgreSQL and I want to migrate data from Oracle to PostgreSQL database. I have performed steps: CREATE EXTENSION oracle_fdw; CREATE SERVER oradb FOREIGN DATA WRAPPER oracle_fdw OPTIONS (dbserver ''); GRANT USAGE ON FOREIGN SERVER or