> What is "schema" in this context?
Oracle "schema" == Postgres "database": a collection of objects (tables, functions, triggers, views, etc) owned by a user.