MIME-Version: 1.0
References: 
 <CAHsHJAjfwF1gso5j=oa62GrZB2HTRDD2yc3D22YKi_VwrA3vtg@mail.gmail.com>
In-Reply-To: 
 <CAHsHJAjfwF1gso5j=oa62GrZB2HTRDD2yc3D22YKi_VwrA3vtg@mail.gmail.com>
From: Muhammad Ikram <me.mikram@gmail.com>
Date: Wed, 11 Sep 2024 17:05:43 +0500
Message-ID: 
 <CAJQ7xG6SqBENUOaGxw+EkRJ25QTeZ547Cjf4pQRXCPFv_YsviQ@mail.gmail.com>
Subject: Re: Oracle -> Pg migration
To: Laszlo Forro <getforum@gmail.com>
Cc: "pgsql-novice@lists.postgresql.org" <pgsql-novice@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000e8d6000621d6cfc7"
Archived-At: 
 <https://www.postgresql.org/message-id/CAJQ7xG6SqBENUOaGxw%2BEkRJ25QTeZ547Cjf4pQRXCPFv_YsviQ%40mail.gmail.com>
Precedence: bulk

--000000000000e8d6000621d6cfc7
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi

Could you check the INPUT_FILE parameter in ora2pg config file ? I think
you can provide a SQL file instead of live connection.

or try

ora2pg -i /path/to/your/oracle_export.sql -o output.sql


Regards,
Muhammad Ikram


On Wed, Sep 11, 2024 at 2:27=E2=80=AFPM Laszlo Forro <getforum@gmail.com> w=
rote:

> Hi dear community,
> We are to dig into the option of migrating an Oracle db to Pg and found
> the Ora2Pg. However, that seem to do data migration, requires running
> Oracle db. We would like to dump the Oracle object declarations (create
> statements in SQL files) and move it to Pg first, no data migrated.
> Can you guide us if there is any tool that can support this approach?
> Thank you very much!
> LF.
>

--000000000000e8d6000621d6cfc7
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi<div><br></div><div>Could you check the INPUT_FILE param=
eter in ora2pg config file ? I think you can provide a SQL file instead of =
live connection.</div><div><br></div><div>or try</div><div><br></div><div>o=
ra2pg -i /path/to/your/oracle_export.sql -o output.sql<br></div><div><br></=
div><div><br></div><div>Regards,</div><div>Muhammad Ikram</div><div><br></d=
iv><div><br></div></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" cla=
ss=3D"gmail_attr">On Wed, Sep 11, 2024 at 2:27=E2=80=AFPM Laszlo Forro &lt;=
<a href=3D"mailto:getforum@gmail.com">getforum@gmail.com</a>&gt; wrote:<br>=
</div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;b=
order-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><d=
iv>Hi dear community,</div><div>We are to dig into the option of migrating =
an Oracle db to Pg and found the Ora2Pg. However, that seem to do data migr=
ation, requires running Oracle db. We would like to dump the Oracle object =
declarations (create statements in SQL files) and move it to Pg first, no d=
ata migrated.<br></div><div>Can you guide us if there is any tool that can =
support this approach?</div><div>Thank you very much!</div><div>LF.<br></di=
v></div>
</blockquote></div>

--000000000000e8d6000621d6cfc7--