package conversion error from oracle to postgresql database !!!!!!!!!

From: dbatoCloud Solution <dbatocloud17(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: package conversion error from oracle to postgresql database !!!!!!!!!
Date: 2021-12-12 05:46:58
Message-ID: CAEz7P_tS=-_fFo4mm35-2o7W721j+APYQpn_mbnC2f1STiXJ6Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi All,
While migrating oracle to PostgreSQL database using ora2pg tool. I have got
this below error for the package. Could someone please help with this?
psql:./schema/packages/package.sql:??: ERROR: schema "utl_file" does not
exist
LINE 75: file_type utl_file.file_type := utl_file.fopen(file_dir, ...
^
ERROR: an error occurs when importing file ./schema/packages/package.sql.
[ybos(at)doliordv265 comsod_code]$

Thanks

Ashok

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Ashokkumar Mani

+91 81975 99922

W: https://dbatocloudsolution.blogspot.in/
<http://dbatocloudsolution.blogspot.in/> | E: dbatocloud17(at)gmail(dot)com

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Sandeep Saxena 2021-12-12 05:49:52 Re: package conversion error from oracle to postgresql database !!!!!!!!!
Previous Message Wells Oliver 2021-12-11 22:52:07 Re: Very slow 101-feeling design/query..