Re: [EXT]Re: Strange error trying to import with Ora2PG
| От | Johnson, Bruce E - (bjohnson) |
|---|---|
| Тема | Re: [EXT]Re: Strange error trying to import with Ora2PG |
| Дата | |
| Msg-id | DB38AA4A-8F1F-45AA-8DF8-80DED6BE2009@email.arizona.edu обсуждение исходный текст |
| Ответ на | Re: Strange error trying to import with Ora2PG (Adrian Klaver <adrian.klaver@aklaver.com>) |
| Список | pgsql-general |
That’s not it. export_schema.sh writes the scripts, and then emits a ora2pg command to pull in the data (I've managed to do this a dozen times so far working out how to do things. :-)
The dates on the files in the sources directory are consistent with that, and don’t change when I run the script.
-rw-rw-r-- 1 johnson johnson 872 Sep 27 22:02 AHSC_SCHEDULE_ROUNDED_view.sql
-rw-rw-r-- 1 johnson johnson 817 Sep 27 22:02 COP_COLLEGE_HOUR_view.sql
-rw-rw-r-- 1 johnson johnson 628 Oct 3 17:06 RESERVER_VISIBLE_RESTRICTION_view.sql
-rw-rw-r-- 1 johnson johnson 515 Sep 27 22:02 RESOURCEAFFIL_WITHCODE_view.sql
-rw-rw-r-- 1 johnson johnson 535 Sep 27 22:02 UA_COLLEGE_LOOKUP_view.sql
On Oct 3, 2023, at 2:27 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:External Email
On 10/3/23 10:32, Johnson, Bruce E - (bjohnson) wrote:I am trying to import an oracle schema with ora2pg and running into an odd error when the import_all.sh script gets to a specific view.
The error is:However when I re-run the import_all.sh script it errors out at the same place with the same error (in fact the pasted error code is from running the script AFTER I fixed it). The sql isn’t being cached anywhere in the system is it?
I'm betting that every time you run import_all.sh it rewrites the scripts. Pretty sure if you look at the file the creation script will have been rewritten to its original from.I know that I modified the correct file.
It happens even if I drop the database and recreate it.
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
--
Adrian Klaver
adrian.klaver@aklaver.com
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
В списке pgsql-general по дате отправления: