Oracle database: Group tables in folders, like Postgres Schemas?

Question

is there a way to group tables into Postgres's schema like structure? We have a Postgresql server we want to move to Oracle DB. We use a lot of schemas to categorize tables. Anything Similar in oracle? Oracle has Schemas but there is a one to one relation between schema and a user. Schema == User.

Is there another stack-exchange that might be more appropriate for this question?

Answer 1

You will need to create the same amount of schemas in Oracle as you did in PostgreSQL. The fact that each schema is also associated with a user should not bother you.

You don't have to log-in with all those users if that's what you are wondering.

Just create one "application" user, and grant the necessary privileges on the tables you create in the various schemas to that application user.

If you used PostgreSQL's search path feature to avoid fully qualified table names, then you'll need to create synonyms (owned by the "applicatoin" user) that point to the tables in the various schemas.