On Oct 4, 2023, at 8:38 AM, Adrian Klaver <adrian.klaver@aklaver.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