Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id D092A632C35
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Fri, 30 Jan 2009 07:53:12 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 04495-04 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Fri, 30 Jan 2009 07:53:08 -0400 (AST)
X-Greylist: delayed 00:06:45.051887 by SQLgrey-1.7.6
Received: from ns1.aaaonlinux.net (NS1.AAAONLINUX.net [70.84.189.18])
	by mail.postgresql.org (Postfix) with ESMTP id 0CD06632C30
	for <pgsql-admin@postgresql.org>; Fri, 30 Jan 2009 07:53:08 -0400 (AST)
Received: (qmail 21062 invoked by uid 508); 30 Jan 2009 11:53:24 -0000
Received: from unknown (HELO direction.biz) (59.163.21.147)
	by ns1.aaaonlinux.net with SMTP; 30 Jan 2009 11:53:24 -0000
Received: from [172.16.2.20] ([172.16.2.20])
	(authenticated user s.borse@direction.biz)
	by direction.biz (direction.biz) (MDaemon PRO v9.0.0)
	with ESMTP id md50000317579.msg
	for <pgsql-admin@postgresql.org>; Fri, 30 Jan 2009 17:14:07 +0530
Subject: How to migrate from oracle to postgres !!
From: Suresh Borse <s.borse@direction.biz>
Reply-To: s.borse@direction.biz
To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Content-Type: multipart/alternative; boundary="=-A++gUIuWwHqbm1BTyZeR"
Organization: DSS
Date: Fri, 30 Jan 2009 17:04:59 +0530
Message-Id: <1233315299.2247.33.camel@dss-052.dsslp.com>
Mime-Version: 1.0
X-Mailer: Evolution 2.10.3 (2.10.3-9.fc7) 
X-Authenticated-Sender: s.borse@direction.biz
X-Spam-Processed: direction.biz, Fri, 30 Jan 2009 17:14:07 +0530
	(not processed: spam filter heuristic analysis disabled)
X-MDRemoteIP: 172.16.2.20
X-Return-Path: s.borse@direction.biz
X-MDaemon-Deliver-To: pgsql-admin@postgresql.org
X-MDAV-Processed: direction.biz, Fri, 30 Jan 2009 17:14:09 +0530
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200901/168
X-Sequence-Number: 31215


--=-A++gUIuWwHqbm1BTyZeR
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

Dear All,

How to migrate existing database which in Oracle  to postgres?

Please provide me the solution/limitation for triggers , procedure ,
packages & views while migrating.


Thanks & Regards,

Suresh Borse
(DBA)


--=-A++gUIuWwHqbm1BTyZeR
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
  <META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
  <META NAME="GENERATOR" CONTENT="GtkHTML/3.14.1">
</HEAD>
<BODY>
<FONT SIZE="2">Dear All,</FONT><BR>
<BR>
<FONT SIZE="2">How to migrate existing database which in Oracle&nbsp; to postgres?</FONT><BR>
<BR>
<FONT SIZE="2">Please provide me the solution/limitation for triggers , procedure , packages &amp; views while migrating.</FONT><BR>
<BR>
<BR>
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<TR>
<TD>
<FONT SIZE="2">Thanks </FONT><FONT SIZE="2"><FONT COLOR="#000000">&amp; Regards,</FONT></FONT><BR>
<BR>
<FONT SIZE="2">Suresh Borse</FONT><BR>
<FONT SIZE="2"><FONT COLOR="#000000">(D</FONT></FONT><FONT SIZE="2">BA</FONT><FONT SIZE="2"><FONT COLOR="#000000">)</FONT></FONT><BR>
<BR>
</TD>
</TR>
</TABLE>
</BODY>
</HTML>

--=-A++gUIuWwHqbm1BTyZeR--