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

回到话题: 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.

回到论坛: HOME枫下论坛枫下论坛主坛工作学习IT技术讨论