×

Loading...

Topic

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)
        /*
        * Target DBMS: 'Ingres'
        */


        /*
        * Table : eic_level1
        * Description :
        * id : 12-34567-890 12:Level 890:Sequence Number 34567:Reserved
        * name :
        * type : Category: 1; Item: 0
        * manager :
        * email : Manager's E-mail
        * manager_notes : Other Information about Manger
        * notes :
        */
        create table wonme (
        id char not null,
        name varchar,
        type char not null,
        manager char not null,
        email char not null,
        manager_notes char,
        notes clob not null,
        primary key (id));
        • 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); 2001-10-10 {95} (#220820@0)
          And if you don't specify, all those objects will be created on default tablespace of this user
枫下论坛主坛 /  工作学习 /  IT技术讨论