This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / 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.
-howru(How are you?);
2001-10-4
(#216682@0)
-
In our company, we call the ERwin file which present all the tables' structure and/or views' as the schema. Oracle have its own definition of Schema. you can get it from their web site.
-cyt(cyt);
2001-10-4
(#216968@0)
-
Hi, cyt. Do you have ERWin4.0? I really need it . Thanks!!!
-onewayticket(onewayticket);
2001-10-4
(#216981@0)
-
Sorry, the most updated ERwin in our company is 3.5. And I only have the copy of 3.0.
-cyt(cyt);
2001-10-7
(#218859@0)
-
www.smiling.com.cn oracle group
-frankcheng(frank);
2001-10-10
(#220828@0)
-
They have moved to www.itpub.net
-cyt(cyt);
2001-10-11
(#221623@0)
-
Try this site. http://surpass.swpi.edu.cn/erwin.htm
-cyt(cyt);
2001-10-10
(#220672@0)
-
That's great! Thanks you all cyt and frankcheng !
-onewayticket(onewayticket);
2001-10-10
(#220901@0)
-
A schema is a collection of all database objects under a user and the name same as this user. For example: \"select * from scott.emp\\\" The scott is schema not user.
-onewayticket(onewayticket);
2001-10-4
(#216974@0)
-
A Schema represents all database objects (tables, index, views...) of an application. This is what Rational Rose is using.
-sailor(Sailor);
2001-10-4
(#216975@0)
-
In Database Design Studio, they call such codes as schema. I'm still confused: whether there are two meaning of SCHEMA.
-howru(How are you?);
2001-10-10
{709}
(#220742@0)
-
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.And if you don't specify, all those objects will be created on default tablespace of this user
-wander2001(wander);
2001-10-10
{95}
(#220820@0)