Re: [EXT]Re: Strange error trying to import with Ora2PG

On Oct 4, 2023, at 8:38 AM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> wrote:

If you search the source file directory for "reserver_visible_restriction" is there another file that contains it?

Sigh…that was it…Thank you.

There are two ‘views’ directories, one under ’sources/views’ and the other under /schema/views. Clearly the script is running the other one.

~/oracle_migration$ tree calendar3

calendar3

├── config

│ ├── ora2pg.conf

│ └── ora2pg.conf.orig

SNIP

├── schema

│ ├── dblinks

│

SNIP

│ └── views

│ ├── AHSC_SCHEDULE_ROUNDED_view.sql

│ ├── COP_COLLEGE_HOUR_view.sql

│ ├── RESERVER_VISIBLE_RESTRICTION_view.sql

│ ├── RESOURCEAFFIL_WITHCODE_view.sql

│ ├── UA_COLLEGE_LOOKUP_view.sql

│ └── view.sql

└── sources

SNIP

└── views

├── AHSC_SCHEDULE_ROUNDED_view.sql

├── COP_COLLEGE_HOUR_view.sql

├── RESERVER_VISIBLE_RESTRICTION_view.sql

├── RESOURCEAFFIL_WITHCODE_view.sql

├── UA_COLLEGE_LOOKUP_view.sql

└── view.sql

29 directories, 127 files

--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group

Institutions do not have opinions, merely customs