Actually, Oracle automatically creates a schema when you create a user , the schema name is your user name. All tables, views, indexes and privileges created by this user will belong to this schema.

wander2001 (wander)
And if you don't specify, all those objects will be created on default tablespace of this user
2001-10-10 -04:00
This post has been archived. It cannot be replied.
Page address has been copied. To share, click to copy page address.
Share Online by QR Code

Back To Topic: Schema's difference. A schema is a collection of database objects like a user. In the meantime, we call .DDL file as a Schema. Maybe one of them wrong or there're some relations between them. tks.

Back To Forum: HOME枫下论坛枫下论坛主坛工作学习IT技术讨论