As far as I know, you don't need to create the users, if you create the user anyway before migration then ora2pg will skip the create statement, but objects under the user/schema will be created
On Tue, Sep 5, 2023 at 10:24 AM Johnson, Bruce E - (bjohnson) < john...@pharmacy.arizona.edu> wrote: > I have an oracle database with a bunch of schemas that are the data > sources for bunch of web applications; what used to be called an > ‘intranet’. > > I’ve installed pg2sql, and it’s working, and what I want to do is pretty > much copy what I existing now as closely as possible. > > I've done ora2pg —project_base /oracle_migrate/ —init_project [schema name] > > Properly set the schema username and password in the ./config/ora2pg.conf > filer each of them > > Do I need to create the users in Postgres, or is that done as part of the > import_all.sh script? > > The schemas themselves are not all that complex, mostly just tables, views > and a handful of procedures and grants. > > Installed version of Postgres is v15. > > -- > Bruce Johnson > University of Arizona > College of Pharmacy > Information Technology Group > > Institutions do not have opinions, merely customs > > >
