Postgres Pro
Downloads
Home   >   mailing lists

package conversion error from oracle to postgresql database !!!!!!!!! - Mailing list pgsql-admin

From dbatoCloud Solution
Subject package conversion error from oracle to postgresql database !!!!!!!!!
Date
Msg-id CAEz7P_tS=-_fFo4mm35-2o7W721j+APYQpn_mbnC2f1STiXJ6Q@mail.gmail.com
Whole thread Raw
Responses Re: package conversion error from oracle to postgresql database !!!!!!!!!  (Sandeep Saxena <sandeep.lko@gmail.com>)
Re: package conversion error from oracle to postgresql database !!!!!!!!!  (Mladen Gogala <gogala.mladen@gmail.com>)
List pgsql-admin
Tree view
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@doliordv265 comsod_code]$


Thanks

Ashok

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

Ashokkumar Mani

 +91 81975 99922 

W: https://dbatocloudsolution.blogspot.in/ | E: dbatocloud17@gmail.com



pgsql-admin by date:

Previous
From: Wells Oliver
Date:
Subject: Re: Very slow 101-feeling design/query..
Next
From: Sandeep Saxena
Date:
Subject: Re: package conversion error from oracle to postgresql database !!!!!!!!!