create schema on oracle

create user francis identified by francispassword;

my question is create a new user is equal to create a new schema, is it?
Thank you!
Francis SZE

But if you want to setup the schema in one go by creating multiple objects

multiple objects means multi users in one schema?

no.. a schema means it is for one user only.

multiple objects means multi users in one schema? ---> this means that if you want to setup n tables, x views, y sequences etc...

In this context, user is not a database object here.

so, create schema is not a must, just create a user on one database
right?
Thank you
Francis SZE

Yes, that is what i said that it is not mandatory. But create user is mandatory if at all you need to setup a schema with objects.

Thanks,