Re: [ADMIN] migrating oracle table to PostgresQL

2006-01-03 Thread Jim C. Nasby
On Thu, Dec 29, 2005 at 11:46:51AM +0530, Gourish Singbal wrote: > ora2pg tool can be used to accomplish the migration from oracle to > postgresql. > download it from here... > http://freshmeat.net/projects/ora2pg/ > > The one in contib directory is an old version i guess. > > About clob, blob, a

Re: [ADMIN] migrating oracle table to PostgresQL

2005-12-28 Thread Gourish Singbal
day, December 28, 2005 10:12 AMTo: Murugan GCc: pgsql-admin@postgresql.orgSubject: Re: [ADMIN] migrating oracle table to PostgresQL Yes.But Oracle is completely useless at dumping data. You may want to usethe sqltool in HSQLDB (http://hsqldb.org/) or similar that is able toconnect both to Orac

Re: [ADMIN] migrating oracle table to PostgresQL

2005-12-28 Thread Goulet, Dick
-admin@postgresql.org Subject: Re: [ADMIN] migrating oracle table to PostgresQL Yes. But Oracle is completely useless at dumping data. You may want to use the sqltool in HSQLDB (http://hsqldb.org/) or similar that is able to connect both to Oracle and PG. PLSQL developer is also able to do a

Re: [ADMIN] migrating oracle table to PostgresQL

2005-12-28 Thread Bradley Kieser
Yes. But Oracle is completely useless at dumping data. You may want to use the sqltool in HSQLDB (http://hsqldb.org/) or similar that is able to connect both to Oracle and PG. PLSQL developer is also able to do a connection to both but is commercial software. Alternatively, if you are reall

[ADMIN] migrating oracle table to PostgresQL

2005-12-28 Thread Murugan G
Title: migrating oracle table to PostgresQL Hello, I have some tables containing clob, blob, and long columns in Oracle, Is it possible to migrate these tables into PostgresQL along with data  Thanks and regards, G.Murugan, Sr. Software Engineer. Extn. 1658